java web课程设计网上书店jsp

package com.sp.model1; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class UserBeanBo { private Connection ct=null; private PreparedStatement ps=null; private ResultSet rs=null; public boolean addUsers(String username, String truename,String passwd ,String address,String postcode,String phone,String email ){ boolean bl=false; ct=new ConDB().getCon(); try { ps = ct.prepareStatement("insert into users values(?,?,?,?,?,?,?,?)"); ps.setString(1,username); ps.setString(2,truename); ps.setString(3,passwd); ps.setString(4,address); ps.setString(5,postcode); ps.setInt(6,5); ps.setString(7,phone); ps.setString(8,email); int a=ps.executeUpdate(); if(a==1){ bl=true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ this.close(); } return bl; } public boolean updataUser(String s_id ,String name,String truename,String passwd,String address,String phone,String email,String postcode,String s_grade){ boolean bl=false; ct=new ConDB().getCon(); try { System.out.println("*****************************************"); int id=Integer.parseInt(s_id); int grade=Integer.parseInt(s_grade); ps=ct.prepareStatement("update users set username=' "+name+" ',truename=' "+truename+" ',passwd=' "+passwd+ " ',address1=' "+address+ " ',email=' "+email+" ',postcode=' "+postcode+" ' ,grade=' "+grade+ " 'where userId=' "+id+" ' "); System.out.println("&&&&&&&&&&&&&&&&&&&&&&&&&&&&"); int a=ps.executeUpdate(); if(a==1){ bl=true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); System.out.println("123132"); }finally{ this.close(); } return bl; } public UserBean getUserBean(String u){ UserBean ub=new UserBean(); ct=new ConDB().getCon(); try { ps=ct.prepareStatement("select top 1 * from users where username=?"); ps.setString(1,u); rs=ps.executeQuery(); if(rs.next()){ ub.setUserId(rs.getLong(1)); ub.setUserName(rs.getString(2)); ub.setTrueName(rs.getString(3)); ub.setPasswd(rs.getString(4)); ub.setEmail(rs.getString(5)); ub.setPhone(rs.getString(6)); ub.setAddress(rs.getString(7)); ub.setPostcode(rs.getString(8)); ub.setGrade(rs.getInt(9)); } } catch (SQLException e) { // TODO Auto-generated catch block // e.printStackTrace(); System.out.println("==="); } return ub; } public boolean checkUser(String u,String p){ boolean al=false; UserBean ub=new UserBean(); ct=new ConDB().getCon(); try { ps=ct.prepareStatement("select top 1 passwd from users where username=? "); ps.setString(1, u); rs=ps.executeQuery(); if(rs.next()){ String dbPasswd=rs.getString(1); if(dbPasswd.equals(p)){ al=true; } } } catch (SQLException e) { // TODO Auto-generated catch block // e.printStackTrace(); System.out.println("------"); }finally{ this.close(); } return al; } public void close(){ if(rs!=null){ try { rs.close(); rs=null; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } if(ps!=null){ try { ps.close(); ps=null; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } if(ct!=null){ try { ct.close(); ct=null; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } }