JDBC操作技巧

public static final String DBDRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
 public static final String DBURL="jdbc:sqlserver://10.81.35.35:1433;databaseName=Company";
 public static final String DBUSERNAMW="sa";
 public static final String DBPSD="1111111";
 private Connection conn=null;
 
 public DataBaseConnection(){
 try{
 Class.forName(DBDRIVER);
 conn=DriverManager.getConnection(DBURL,DBUSERNAMW,DBPSD);
 }catch(Exception e){
 e.printStackTrace();
 }
 }

 public Connection getConnection(){
 return this.conn ;
 }
 
 public void close() throws SQLException{
 if(this.conn!=null){
 conn.close();
 }
 }

PreparedStatement pstm = null;
 String sql = "insert into Person(UserName,Password) values(?,?)";
 try {
 pstm = this.conn.prepareStatement(sql);
 pstm.setString(1, person.getUserName());
 pstm.setString(2, person.getPassword());
 int count = pstm.executeUpdate();
 if (count > 0) {
 flag = true;
 }
 } catch (Exception e) {
 throw e;
 } finally {
 try {
 pstm.close();
 } catch (Exception e) {
 }
 }

public List findByParams(Map params)
 throws Exception {
 Iterator it = params.entrySet().iterator();
 List list = new ArrayList();
 Person person = null;
 String key = null;
 Object value = null;
 PreparedStatement pstm = null;
 while (it.hasNext()) {
 Map.Entry entry = (Map.Entry) it
 .next();
 key = entry.getKey();
 value = entry.getValue();
 }
 String sql = String.format(
 "select userid,username,password from person where %s=?", key);
 pstm = this.conn.prepareStatement(sql);
 pstm.setObject(1, value);
 ResultSet rs = pstm.executeQuery();
 while(rs.next()) {
 person = new Person();
 person.setUserID(rs.getInt(1));
 person.setUserName(rs.getString(2));
 person.setPassword(rs.getString(3));
 }
 rs.close();
 pstm.close();
 return list;
 }