Model1实现增删改查的小例子.doc

Model1例子 作者：深蓝王子 SqlBean.java package com.jq92.bean; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class SqlBean { Connection con; PreparedStatement pre; ResultSet rs; public SqlBean(){ try { Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver); con=DriverManager.getConnection(jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jq92Model1,sa,sa); } catch (ClassNotFoundException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } } public int getInsert(String sql,JavaBean jBean){ int count=0; try { //获得prepareStatement pre=con.prepareStatement(sql); //为前面的？赋值 pre.setString(1,jBean.getName()); pre.setString(2,jBean.getPassword()); pre.setString(3,jBean.getSex()); pre.setInt(4,jBean.getAge()); count=pre.executeUpdate(); } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } return count; } public int getDelete(String sql,int id){ int count=0; try { pre=con.prepareStatement(sql); pre.setInt(1, id); count = pre.executeUpdate(); } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } return count; } public int getUpdate(String sql,JavaBean jBean){ int count=0; try { pre=con.prepareStatement(sql); pre.setString(1,jBean.getName()); pre.setString(2,jBean.getPassword()); pre.setString(3,jBean.getSex()); pre.setInt(4,jBean.getAge()); pre.setInt(5,jBean.getId()); count=pre.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } return count; } public ResultSet getUpdate2(String sql,int id){ try { pre=con.prepareStatement(sql); pre.setInt(1, id); rs = pre.executeQuery(); } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } return rs; } public ResultSet g