java利用JDBC的方式实现增删改查的…

public void insert(LoginUser user) {
  Connection conn = null;
  try {
   conn = DBConnection.getConnection();

   String sql = "insert into tongxunlu(username,sex,mobliephone,address,fixphone,postcalcode,email) values(?,?,?,?,?,?,?)";
   PreparedStatement pst = conn.prepareStatement(sql);
   pst.setString(1, user.getName());
   pst.setString(2, user.getSex());
   pst.setString(3, user.getMobilephone());
   pst.setString(4, user.getAddress());
   pst.setString(5, user.getFixedPhone());
   pst.setString(6, user.getPostalCode());
   pst.setString(7, user.getEmail());
   pst.executeUpdate();
   pst.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException e) {
   e.printStackTrace();
  } finally {
   DBConnection.closeConnection(conn);
  }
 }

 
 public void update(LoginUser user) {
  Connection conn = null;
  try {
   conn = DBConnection.getConnection();
   String sql = "update tongxunlu set username=?,sex=?,mobilephone=?,address=?,fixphone=?,postalcode=?,email=? where userid=?";
   PreparedStatement pst = conn.prepareStatement(sql);
   pst.setString(1, user.getName());
   pst.setString(2, user.getSex());
   pst.setString(3, user.getMobilephone());
   pst.setString(4, user.getAddress());
   pst.setString(5, user.getFixedPhone());
   pst.setString(6, user.getPostalCode());
   pst.setString(7, user.getEmail());
   pst.setInt(8, user.getUserID());
   pst.executeUpdate();
   pst.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException e) {
   e.printStackTrace();
  } finally {
   DBConnection.closeConnection(conn);
  }
 }

 
 public void delete(LoginUser user) {
  Connection conn = null;
  try {
   conn = DBConnection.getConnection();

   String sql = "delete from tongxunlu where userid=?";
   PreparedStatement pst = conn.prepareStatement(sql);
   pst.setInt(1, user.getUserID());
   pst.executeUpdate();
   pst.close();

  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException e) {
   e.printStackTrace();
  } finally {
   DBConnection.closeConnection(conn);
  }
 }

 
 public ArrayList selectAll() {
  ArrayList users = new ArrayList();
  Connection conn = null;
  try {
   conn = DBConnection.getConnection();

   String sql = "select * from tongxunlu";
   PreparedStatement pst = conn.prepareStatement(sql);
   ResultSet rs = pst.executeQuery();

   while (rs.next()) {
    LoginUser user = new LoginUser();
    user.setUserID(rs.getInt("userid"));
    user.setName(rs.getString("username"));
    user.setSex(rs.getString("userpass"));
    user.setMobilephone(rs.getString("mobliephone"));
    user.setAddress(rs.getString("address"));
    user.setFixedPhone(rs.getString("fixphone"));
    user.setPostalCode(rs.getString("postalCode"));
    user.setEmail(rs.getString("email"));
    users.add(user);
   }

   rs.close();
   pst.close();
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException e) {
   e.printStackTrace();
  } finally {
   DBConnection.closeConnection(conn);
  }

  return users;
 }

 
 public LoginUser selectByID(int userId) {
  Connection conn = null;
  LoginUser user = new LoginUser();
  try {
   conn = DBConnection.getConnection();

   String sql = "select * from tongxunlu where userid=?";
   PreparedStatement pst = conn.prepareStatement(sql);
   pst.setInt(1, userId);
   ResultSet rs = pst.executeQuery();

   while (rs.next()) {
    user.setUserID(rs.getInt("userid"));
    user.setName(rs.getString("username"));
    user.setSex(rs.getString("userpass"));
    user.setMobilephone(rs.getString("mobliephone"));
    user.setAddress(rs.getString("address"));
    user.setFixedPhone(rs.getString("fixphone"));
    user.setPostalCode(rs.getString("postalCode"));
    user.setEmail(rs.getString("email"));
   }

   rs.close();
   pst.close();
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch (SQLException e) {
   e.printStackTrace();
  } finally {
   DBConnection.closeConnection(conn);
  }

  return user;
 }

 public boolean checkLogin(LoginUser user) {
  boolean flag = false;
  Connection conn = null;
  try {// 1.2
   conn = DBConnection.getConnection();
   // 3
   String sql = "select count(*) from tongxunlu where username=?,sex=? ,mobilephone=?,address=?,fixphone=?,postalcode=?,email=?";
   PreparedStatement ps = conn.prepareStatement(sql);
   ps.setString(1, user.getName());
   ps.setString(2, user.getSex());
   ps.setString(3, user.getMobilephone());
   ps.setString(4, user.getAddress());
   ps.setString(5, user.getFixedPhone());
   ps.setString(6, user.getPostalCode());
   ps.setString(7, user.getEmail());
   ps.setInt(8, user.getUserID());
   // 4
   ResultSet rs = ps.executeQuery();
   // 5
   while (rs.next()) {
    System.out.println(rs.getInt(1));
    if (rs.getInt(1) > 0) {
     flag = true;
    }
   }// 6
   rs.close();
   ps.close();

  } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } finally {// 6
   DBConnection.closeConnection(conn);
  }

  return flag;
 }