javabean+jsp 弱功能网上商城

package exe1; //import exe1.UserBean; //import exe1.AdminBean; import java.sql.*; import java.util.ArrayList; import java.util.List; public class function1 extends DbCon { Connection con = null; PreparedStatement pSta = null; Statement sta = null; ResultSet rs = null; String sql = null; // 插入数据 public int insert(exe1.UserBean bean) { con = getCon(); int result = 0; try { sql = "insert into user ( \n" + " OuserName , \n" + " Opassword , \n" + " Oname , \n" + " Osex , \n" + " Oaddress , \n" + " Ophone , \n" + " Opost , \n" + " Oemail , \n" + " OregIp , \n" + " OregTime )" + "values (?,?,?,?,?,?,?,?,?,?)"; pSta = con.prepareStatement(sql); pSta.setString(1, bean.getBuserName()); pSta.setString(2, bean.getBpassword()); pSta.setString(3, bean.getBname()); pSta.setString(4, bean.getBsex()); pSta.setString(5, bean.getBaddress()); pSta.setString(6, bean.getBphone()); pSta.setString(7, bean.getBpost()); pSta.setString(8, bean.getBemail()); pSta.setString(9, bean.getBregIp()); pSta.setString(10, bean.getBregTime()); //pSta.setString(11, bean.getBlogin()); result = pSta.executeUpdate(); return result; } catch (Exception e) { e.printStackTrace(); } finally { try { closeDb(con, pSta, rs); } catch (Exception e) { e.printStackTrace(); } return result; } } // 登入 public boolean login(String user, String passwd) { con = getCon(); boolean result = false; String str = ""; try { sql = "select Opassword from user where OuserName=?"; pSta = con.prepareStatement(sql); pSta.setString(1, user); rs = pSta.executeQuery(); if (rs.next()) str = rs.getString("Opassword"); if (str.equals(passwd)) result = true; else result = false; } catch (Exception e) { e.printStackTrace(); } finally { try { closeDb(con, pSta, rs); } catch (Exception e) { e.printStackTrace(); } return result; } } // 修改用户资料 public boolean change2(String userName, String name, String sex, String address, String phone, String post) { con = getCon(); boolean result = false; try { /* * sql="update user" +"set " +"Oname='?' , \n" +"Osex='?' , \n" * +"Oaddress= '?', \n" +"Ophone='?' , \n" +"Opost='?' \n" +"where * OuserName='?'"; pSta=con.prepareStatement(sql); pSta.setString(1, * name); pSta.setString(2, sex); pSta.setString(3, address); * pSta.setString(4, phone); pSta.setString(5, post); * pSta.setString(6, userName); result=pSta.executeUpdate(); */ /*sql = "update user set"; sql = sql + "Oname='" + name + "',"; sql = sql + "Osex='" + sex + "',"; sql = sql + "Oaddress='" + address + "',"; sql = sql + "Ophone='" + phone + "',"; sql = sql + "Opost='" + post + "'"; sql = sql + "where OuserName='" + userName + "'"; sta = con.createStatement(); result = sta.execute(sql);*/ String sql2="update user set Oname=? where OuserName=?"; pSta=con.prepareStatement(sql2); pSta.setString(1, name); pSta.setString(2, userName); return result; } catch (Exception e) { e.printStackTrace(); } finally { try { closeDb(con, sta, rs); } catch (Exception e) { e.printStackTrace(); } return result; } } public exe1.UserBean query(String user) { con = getCon(); exe1.UserBean bean = new exe1.UserBean(); try { sql = "select * from user where OuserName=?"; pSta = con.prepareStatement(sql); pSta.setString(1, user); rs = pSta.executeQuery(); if (rs.next()) { bean.setBuserName(rs.getString("OuserName")); bean.setBpassword(rs.getString("Opassword")); bean.setBname(rs.getString("Oname")); bean.setBsex(rs.getString("Osex")); bean.setBaddress(rs.getString("Oaddress")); bean.setBphone(rs.getString("Ophone")); bean.setBpost(rs.getString("Opost")); bean.setBemail(rs.getString("Oemail")); bean.setBregIp(rs.getString("OregIp")); bean.setBregTime(rs.getString("OregTime")); } return bean; } catch (Exception e) { e.printStackTrace(); } finally { try { closeDb(con, pSta, rs); } catch (Exception e) { e.printStackTrace(); } return bean; } } // 删除用户 public boolean delete(String user) { con = getCon(); boolean result = false; try { sql = "delete from user where OuserName=?"; pSta = con.prepareStatement(sql); pSta.setString(1, user); result = pSta.execute(); return result; } catch (Exception e) { e.printStackTrace(); } finally { try { closeDb(con, pSta, rs); } catch (Exception e) { e.printStackTrace(); } return result; } } // 查找所有用户 public List listAll() { con = getCon(); List list = new ArrayList(); exe1.UserBean bean; try { sql = "select * from user"; sta = con.createStatement(); rs = sta.executeQuery(sql); while (rs.next()) { bean = new exe1.UserBean(); bean.setBuserName(rs.getString("OuserName")); bean.setBpassword(rs.getString("Opassword")); bean.setBname(rs.getString("Oname")); bean.setBsex(rs.getString("Osex")); bean.setBaddress(rs.getString("Oaddress")); bean.setBphone(rs.getString("Ophone")); bean.setBpost(rs.getString("Opost")); bean.setBemail(rs.getString("Oemail")); bean.setBregIp(rs.getString("OregIp")); bean.setBregTime(rs.getString("OregTime")); list.add(bean); } return list; } catch (Exception e) { e.printStackTrace(); } finally { try { closeDb(con, pSta, rs); } catch (Exception e) { e.printStackTrace(); } return list; } } //修改用户资料 public int change(String userName, String name, String sex,String address, String phone, String post) { con = getCon(); int result = 0; try { sta=con.createStatement(); sta.addBatch("update user set Oname='"+name+"' where OuserName='"+userName+"'"); sta.addBatch("update user set Osex='"+sex+"' where OuserName='"+userName+"'"); sta.addBatch("update user set Oaddress='"+address+"' where OuserName='"+userName+"'"); sta.addBatch("update user set Ophone='"+phone+"' where OuserName='"+userName+"'"); sta.addBatch("update user set Opost='"+post+"' where OuserName='"+userName+"'"); int b[]=sta.executeBatch(); result=b.length; return result; }catch (Exception e) { e.printStackTrace(); } finally { try { closeDb(con, sta, rs); } catch (Exception e) { e.printStackTrace(); } return result; } } }