java web网络通讯录

package com.cn.operation; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Statement; import java.util.*; import com.cn.common.DBConnection; import com.cn.entity.Book; public class BookBo { private Connection conn; private Statement stm; private PreparedStatement ps; private ResultSet rs; public List selectAllBook(int userId) { List list = new ArrayList(); String sql = "select * from book where userId=" + userId; try { conn = DBConnection.getConnection(); stm = conn.createStatement(); rs = stm.executeQuery(sql); while (rs.next()) { Book book = new Book(); book.setId(rs.getInt("id")); book.setName(rs.getString("name")); book.setSex(rs.getString("sex")); book.setPhone(rs.getString("phone")); book.setAddress(rs.getString("address")); book.setMobilePhone(rs.getString("mobilePhone")); book.setCompany(rs.getString("company")); book.setComPhone(rs.getString("comPhone")); book.setComAddress(rs.getString("comAddress")); list.add(book); } } catch (Exception e) { e.printStackTrace(); } finally { DBConnection.closeResultSet(rs); DBConnection.closeStatement(stm); DBConnection.closeConnection(); } return list; } public List selectBookByRelation(int userId,String relation) { List list = new ArrayList(); String sql = "select * from book where userId=? and relation= ? "; try { conn = DBConnection.getConnection(); ps = conn.prepareStatement(sql); ps.setInt(1, userId); ps.setString(2, relation); rs = ps.executeQuery(); while (rs.next()) { Book book = new Book(); book.setId(rs.getInt("id")); book.setName(rs.getString("name")); book.setSex(rs.getString("sex")); book.setPhone(rs.getString("phone")); book.setAddress(rs.getString("address")); book.setMobilePhone(rs.getString("mobilePhone")); book.setCompany(rs.getString("company")); book.setComPhone(rs.getString("comPhone")); book.setComAddress(rs.getString("comAddress")); list.add(book); } } catch (Exception e) { e.printStackTrace(); } finally { DBConnection.closeResultSet(rs); DBConnection.closeStatement(stm); DBConnection.closeConnection(); } return list; } public int insertBook(Book book) { String sql = "insert into book values(?,?,?,?,?,?,?,?,?,?) "; int count = 0; try { conn = DBConnection.getConnection(); ps = conn.prepareStatement(sql); ps.setString(1, book.getName()); ps.setString(2, book.getSex()); ps.setString(3, book.getPhone()); ps.setString(4, book.getAddress()); ps.setString(5, book.getMobilePhone()); ps.setString(6, book.getCompany()); ps.setString(7, book.getComPhone()); ps.setString(8, book.getComAddress()); ps.setString(9, book.getRelation()); ps.setInt(10, book.getUserId()); count = ps.executeUpdate(); } catch (Exception e) { e.printStackTrace(); } finally { DBConnection.closeStatement(ps); DBConnection.closeConnection(); } return count; } public int deleteBookById(String id) { String sql = "delete from book where id= ? "; int count = 0; try { conn = DBConnection.getConnection(); ps = conn.prepareStatement(sql); ps.setString(1, id); count = ps.executeUpdate(); } catch (Exception e) { e.printStackTrace(); } finally { DBConnection.closeStatement(ps); DBConnection.closeConnection(); } return count; } }