网络百宝箱（应用Jsp开发）

package com.javaBean.luo; import java.sql.*; public class AddListUser { private String userName; private int user; private String sort; private String name; private String mobile; private String home; private String office; private String email; private String qq; private String msn; private String post; private String address; private String other; public String getUserName() { return userName; } public void setUserName(String userName) { this.userName = userName; } public String getSort() { return sort; } public void setSort(String sort) { this.sort = sort; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getMobile() { return mobile; } public void setMobile(String mobile) { this.mobile = mobile; } public String getHome() { return home; } public void setHome(String home) { this.home = home; } public String getOffice() { return office; } public void setOffice(String office) { this.office = office; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; } public String getQq() { return qq; } public void setQq(String qq) { this.qq = qq; } public String getMsn() { return msn; } public void setMsn(String msn) { this.msn = msn; } public String getPost() { return post; } public void setPost(String post) { this.post = post; } public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } public String getOther() { return other; } public void setOther(String other) { this.other = other; } private Connection conn; public AddListUser() { try { Class.forName("org.gjt.mm.mysql.Driver"); conn = DriverManager.getConnection( "jdbc:mysql://127.0.0.1:3306/test", "root", ""); } catch (Exception e) { e.printStackTrace(); } } public int findID(){ try { PreparedStatement pstate = conn .prepareStatement("select id from users where username=?"); pstate.setString(1, this.getUserName()); ResultSet rs = pstate.executeQuery(); if (rs.next()) { user=rs.getInt("id"); rs.close(); return user; } else return 0; } catch (Exception e) { e.printStackTrace(); return 0; } } public boolean insertList() { try { int id; if((id=this.findID())!=0){ PreparedStatement pstate = conn .prepareStatement("insert into list(user,sort,name,mobile,home,office,email,qq,msn,post,address,other)values(?,?,?,?,?,?,?,?,?,?,?,?)"); pstate.setInt(1,id); pstate.setString(2, this.getSort()); pstate.setString(3, this.getName()); pstate.setString(4, this.getMobile()); pstate.setString(5, this.getHome()); pstate.setString(6, this.getOffice()); pstate.setString(7, this.getEmail()); pstate.setString(8, this.getQq()); pstate.setString(9, this.getMsn()); pstate.setString(10, this.getPost()); pstate.setString(11, this.getAddress()); pstate.setString(12, this.getOther()); int r = pstate.executeUpdate(); if (r == 1) { return true; } else return false; } else return false; } catch (Exception e) { e.printStackTrace(); return false; } } }