JSP+JavaBean+Servlet制作通讯录.zip

package cn.com.sise.dao.impl; import cn.com.sise.dao.ContactDao; import cn.com.sise.dto.Contact; import cn.com.sise.utils.JDBCUtil; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; import java.util.UUID; public class ContactDaoMySQLImpl implements ContactDao{ @Override public void addContact(Contact contact) { Connection conn = null; PreparedStatement stmt = null; try { conn = JDBCUtil.getConnection(); String sql = "INSERT INTO contact(id,name,gender,age,phone,email,qq,type) VALUES(?,?,?,?,?,?,?,?)"; //创建PrepareStatement stmt = conn.prepareStatement(sql); String id = UUID.randomUUID().toString().replace("-",""); //设置参数 stmt.setString(1,id); stmt.setString(2,contact.getName()); stmt.setString(3,contact.getGender()); stmt.setInt(4,contact.getAge()); stmt.setString(5,contact.getPhone()); stmt.setString(6,contact.getEmail()); stmt.setString(7,contact.getQq()); stmt.setString(8,contact.getType()); //执行 stmt.executeUpdate(); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException(e); } finally { JDBCUtil.close(conn,stmt); } } @Override public void updateContact(Contact contact) { Connection conn = null; PreparedStatement stmt = null; try { conn = JDBCUtil.getConnection(); String sql = "UPDATE contact SET name=?,gender=?,age=?,phone=?,email=?,qq=?,type=? WHERE id=?"; //创建PrepareStatement stmt = conn.prepareStatement(sql); String id = UUID.randomUUID().toString().replace("-",""); //设置参数 stmt.setString(1,contact.getName()); stmt.setString(2,contact.getGender()); stmt.setInt(3,contact.getAge()); stmt.setString(4,contact.getPhone()); stmt.setString(5,contact.getEmail()); stmt.setString(6,contact.getQq()); stmt.setString(7,contact.getType()); stmt.setString(8,contact.getId()); //执行 stmt.executeUpdate(); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException(e); } finally { JDBCUtil.close(conn,stmt); } } @Override public void deleteContact(String id) { Connection conn = null; PreparedStatement stmt = null; try { conn = JDBCUtil.getConnection(); String sql = "DELETE FROM contact WHERE id=?"; //创建PrepareStatement stmt = conn.prepareStatement(sql); //设置参数 stmt.setString(1,id); //执行 stmt.executeUpdate(); } catch (Exception e) { e.printStackTrace(); throw new RuntimeException(e); } finally { JDBCUtil.close(conn,stmt); } } @Override public List<Contact> findAll() { Connection conn = null; PreparedStatement stmt = null; ResultSet rs = null; try{ //获取连接 conn = JDBCUtil.getConnection(); String sql = "SELECT * FROM contact"; //创建PreparedStatement stmt = conn.prepareStatement(sql); //执行 rs = stmt.executeQuery(); List<Contact> list = new ArrayList<Contact>(); while(rs.next()){ Contact c = new Contact(); c.setId(rs.getString("id")); c.setName(rs.getString("name")); c.setGender(rs.getString("gender")); c.setAge(rs.getInt("age")); c.setPhone(rs.getString("phone")); c.setEmail(rs.getString("email")); c.setQq(rs.getString("qq")); c.setType(rs.getString("type")); list.add(c); } return list; }catch(Exception e){ e.printStackTrace(); throw new RuntimeException(e); }finally{ JDBCUtil.close(conn, stmt ,rs); } } @Override public Contact findById(String id) { Connection conn = null; PreparedStatement stmt = null; ResultSet rs = null; try { conn = JDBCUtil.getConnection(); String sql = "SELECT * FROM contact WHERE id=?"; //创建PrepareStatement stmt = conn.prepareStatement(sql); //设置参数 stmt.setString(1,id); //执行 rs = stmt.executeQuery(); Contact contact = null; while (rs.next()){ contact = new Contact(); contact.setId(rs.getString("id")); contact.setName(rs.getString("name")); contact.setGender(rs.getString("gender")); contact.setAge(rs.getInt("age")); contact.setPhone(rs.getString("phone")); contact.setEmail(rs.getString("email")); contact.setQq(rs.getString("qq")); contact.setType(rs.getString("type")); } return contact; } catch (Exception e) { e.printStackTrace(); throw new RuntimeException(e); } finally { JDBCUtil.close(conn,stmt); } } @Override public boolean checkContact(String name) { Connection conn = null; PreparedStatement stmt = null; ResultSet rs = null; try { conn = JDBCUtil.getConnection(); //进行数据库查询操作 String sql = "SELECT * FROM contact WHERE name=?"; //创建PrepareStatement stmt = conn.prepareStatement(sql); //设置参数 stmt.setString(1,name); //执行 rs = stmt.executeQuery(); if (rs.next()){ return true; }else { return false; } } catch (Exception e) { e.printStackTrace(); throw new RuntimeException(e); } finally { JDBCUtil.close(conn,stmt); } } public ArrayList<Contact> findType(Contact c) { Connection conn = null; PreparedStatement stmt = null; ResultSet rs = null; try{ //获取连接 conn = JDBCUtil.getConnection(); String sql = "SELECT * FROM contact where type=?"; //创建PreparedStatement stmt = conn.prepareStatement(sql); stmt.setString(1,c.getType()); //执行 rs = stmt.executeQuery(); List<Contact> list = new ArrayList<Contact>(); while(rs.next()){ c = new Contact(); c.setId(rs.getString("id")); c.setName(rs.getString("name")); c.setGender(rs.getString("gender")); c.setAge(rs.getInt("age")); c.setPhone(rs.getString("phone")); c.setEmail(rs.getString("email")); c.setQq(rs.getString("qq")); c.setType(rs.getString("type")); list.add(c); } return (ArrayList<Contact>) list; }catch(Exception e){ e.printStackTrace(); throw new RuntimeException(e); }finally{ JDBCUtil.close(conn, stmt ,rs); } } }