JAVA JSP 网络通讯录+server2005+vmc

package com.book.operation; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; import com.book.common.DBConnection; import com.book.entity.Book; public class BookBo extends DBConnection{ private Connection conn=null; private PreparedStatement pstmt=null;//批处理语句 private ResultSet rs=null; /** * 根据用户id查找所有联系人 */ public List getAllBookByuid(int userId){ String sql ="select * from Book where userId=?"; List<Book> listBook = new ArrayList<Book>(); try { conn=this.getConn(); pstmt=conn.prepareStatement(sql); pstmt.setInt(1, userId); rs=pstmt.executeQuery(); while(rs.next()){ Book book = new Book(); book.setAddress(rs.getString("address")); book.setComAddress(rs.getString("comAddress")); book.setCompany(rs.getString("company")); book.setComPhone(rs.getString("comPhone")); book.setId(rs.getInt("id")); book.setMobilePhone(rs.getString("mobilePhone")); book.setName(rs.getString("name")); book.setPhone(rs.getString("phone")); book.setSex(rs.getString("sex")); book.setUserId(rs.getInt("userId")); book.setRelation(rs.getInt("relation")); listBook.add(book); } } catch (Exception e) { System.out.print("根据用户id查找所有联系人失败getAllBookByuid"); e.printStackTrace(); }finally{ this.closeAll(conn, pstmt, rs); } return listBook; } /** * 根据用户ID 和 联系人类型查询列表 */ public List getbookbyid(int userId, int relation ){ String sql ="select * from Book where userId=? and relation=?"; List<Book> listBook = new ArrayList<Book>(); Book book =null; try { conn=this.getConn(); pstmt=conn.prepareStatement(sql); pstmt.setInt(1, userId); pstmt.setInt(2, relation); rs=pstmt.executeQuery(); while(rs.next()){ book = new Book(); book.setAddress(rs.getString("address")); book.setComAddress(rs.getString("comAddress")); book.setCompany(rs.getString("company")); book.setComPhone(rs.getString("comPhone")); book.setId(rs.getInt("id")); book.setMobilePhone(rs.getString("mobilePhone")); book.setName(rs.getString("name")); book.setPhone(rs.getString("phone")); book.setSex(rs.getString("sex")); book.setUserId(rs.getInt("userId")); book.setRelation(rs.getInt("relation")); listBook.add(book); } } catch (Exception e) { System.out.print("根据用户id查找所有联系人失败getAllBookByuid"); e.printStackTrace(); }finally{ this.closeAll(conn, pstmt, rs); } return listBook; } /** * 根据联系人id删除对应的联系人 */ public int deletebookByid(int id){ String sql = "delete from Book where id=?"; String [] getValue = { id + "" }; return this.executeSQL(sql, getValue); } /** * 添加联系人 */ public int addbook(Book book){ String sql = "insert into Book values(?,?,?,?,?,?,?,?,?,?)"; String [] getValue={book.getName(),book.getSex(),book.getPhone(),book.getAddress(),book.getMobilePhone(),book.getCompany(),book.getComPhone(),book.getComAddress(),book.getRelation()+"",book.getUserId()+""}; return this.executeSQL(sql, getValue); } }