java实现简单通讯录

package com.wuhu.books.dao.imp; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.wuhu.books.dao.BooksDao; import com.wuhu.books.model.Books; import com.wuhu.books.utils.JDBCUtils; public class BooksDaoImp implements BooksDao { List<Books> list = new ArrayList<Books>(); public boolean deteleBookById(int id) { // TODO Auto-generated method stub boolean isOk; try { Connection conn = JDBCUtils.getConn(); String sql = "DELETE FROM tbl_adbook WHERE tbl_adbook.id=?;"; PreparedStatement state = conn.prepareStatement(sql); state.setInt(1, id); state.executeUpdate(); JDBCUtils.close(conn, state, null); isOk = true; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return false; } public boolean insertBooks(Books book) { // TODO Auto-generated method stub boolean isOk = false; try { Connection conn = JDBCUtils.getConn(); String sql = "INSERT INTO tbl_adbook(id,pname,sex,tel,mobel,adress,relation) VALUES (?,?,?,?,?,?,?);"; PreparedStatement state = conn.prepareStatement(sql); state.setInt(1, book.getId()); state.setString(2, book.getName()); state.setString(3, book.getSex()); state.setString(4, book.getTel()); state.setString(5, book.getMobel()); state.setString(6, book.getAdress()); state.setString(7, book.getRelation()); list.add(book); state.executeUpdate(); JDBCUtils.close(conn, state, null); isOk = true; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return isOk; } public List<Books> selectAll() { // TODO Auto-generated method stub try { Connection conn = JDBCUtils.getConn(); String sql = "SELECT tbl_adbook.id, tbl_adbook.pname, tbl_adbook.sex,tbl_adbook.tel,tbl_adbook.mobel,tbl_adbook.adress,tbl_adbook.relation FROM tbl_adbook;"; PreparedStatement state = conn.prepareStatement(sql); ResultSet rs = state.executeQuery(); while (rs.next()) { int bookId = rs.getInt(1); String bookName = rs.getString(2); String bookSex = rs.getString(3); String bookTel = rs.getString(4); String bookMobel = rs.getString(5); String bookAdress = rs.getString(6); String bookRelation = rs.getString(7); Books book = new Books(); book.setId(bookId); book.setName(bookName); book.setSex(bookSex); book.setTel(bookTel); book.setMobel(bookMobel); book.setAdress(bookAdress); book.setRelation(bookRelation); list.add(book); } JDBCUtils.close(conn, state, rs); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } public Books selectById(int id) { // TODO Auto-generated method stub Books book = new Books(); try { Connection conn = JDBCUtils.getConn(); String sql = "SELECT tbl_adbook.id, tbl_adbook.pname, tbl_adbook.sex,tbl_adbook.tel,tbl_adbook.mobel,tbl_adbook.adress,tbl_adbook.relation FROM tbl_adbook WHERE tbl_adbook.id=?;"; PreparedStatement state = conn.prepareStatement(sql); state.setInt(1, id); ResultSet rs = state.executeQuery(); while (rs.next()) { int bookId = rs.getInt(1); String bookName = rs.getString(2); String bookSex = rs.getString(3); String bookTel = rs.getString(4); String bookMobel = rs.getString(5); String bookAdress = rs.getString(6); String bookRelation = rs.getString(7); book.setId(bookId); book.setName(bookName); book.setSex(bookSex); book.setTel(bookTel); book.setMobel(bookMobel); book.setAdress(bookAdress); book.setRelation(bookRelation); } JDBCUtils.close(conn, state, rs); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return book; } public Books selectByname(String name) { // TODO Auto-generated method stub Books book = new Books(); try { Connection conn = JDBCUtils.getConn(); String sql = "SELECT tbl_adbook.id, tbl_adbook.pname, tbl_adbook.sex,tbl_adbook.tel,tbl_adbook.mobel,tbl_adbook.adress,tbl_adbook.relation FROM tbl_adbook WHERE tbl_adbook.pname=?;"; PreparedStatement state = conn.prepareStatement(sql); state.setString(1, name); ResultSet rs = state.executeQuery(); while (rs.next()) { int bookId = rs.getInt(1); String bookName = rs.getString(2); String bookSex = rs.getString(3); String bookTel = rs.getString(4); String bookMobel = rs.getString(5); String bookAdress = rs.getString(6); String bookRelation = rs.getString(7); book.setId(bookId); book.setName(bookName); book.setSex(bookSex); book.setTel(bookTel); book.setMobel(bookMobel); book.setAdress(bookAdress); book.setRelation(bookRelation); } JDBCUtils.close(conn, state, rs); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return book; } public Books selectByrelation(String relation) { // TODO Auto-generated method stub Books book = new Books(); try { Connection conn = JDBCUtils.getConn(); String sql = "SELECT tbl_adbook.id, tbl_adbook.pname, tbl_adbook.sex,tbl_adbook.tel,tbl_adbook.mobel,tbl_adbook.adress,tbl_adbook.relation FROM tbl_adbook WHERE tbl_adbook.relation=?;"; PreparedStatement state = conn.prepareStatement(sql); state.setString(1, relation); ResultSet rs = state.executeQuery(); while (rs.next()) { int bookId = rs.getInt(1); String bookName = rs.getString(2); String bookSex = rs.getString(3); String bookTel = rs.getString(4); String bookMobel = rs.getString(5); String bookAdress = rs.getString(6); String bookRelation = rs.getString(7); book.setId(bookId); book.setName(bookName); book.setSex(bookSex); book.setTel(bookTel); book.setMobel(bookMobel); book.setAdress(bookAdress); book.setRelation(bookRelation); } JDBCUtils.close(conn, state, rs); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return book; } public boolean updateBooks(Books book) { // TODO Auto-generated method stub boolean isOk = false; try { Connection conn = JDBCUtils.getConn(); String sql = "UPDATE tbl_adbook SET pname=?,sex=?,tel=?,mobel=?,adress=?,relation=? WHERE id=?;"; PreparedStatement state = conn.prepareStatement(sql); state.setInt(1, book.getId()); state.setString(2, book.getName()); state.setString(3, book.getSex()); state.setString(4, book.getTel()); state.setString(5, book.getMobel()); state.setString(6, book.getAdress()); state.setString(7, book.getRelation()); state.execute(); JDBCUtils.close(conn, state, null); isOk = true; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return isOk; } }