留言板eclipse做的一个留言板

package hh.doit; import hh.doit.*; import hh.bean.*; import hh.connection.*; import java.util.*; import java.sql.*; import java.util.ArrayList; import java.util.List; import java.sql.*; public class caozuo { public void add(Conn m) { Connection conn = DBManger.getConnection(); String sql = "insert into liuyanban(ID,name,email,subject) values(?,?,?,?)"; try { PreparedStatement ps = conn.prepareStatement(sql); ps.setString(1, m.getID()); ps.setString(2, m.getName()); ps.setString(3, m.getEmail()); ps.setString(4, m.getSubject()); ps.executeUpdate(); ps.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public void delete(String id) { Connection conn = DBManger.getConnection(); String sql = "delete from liuyanban where ID=?"; try { PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, id); pstmt.executeUpdate(); pstmt.close(); } catch (SQLException e1) { // TODO 自动生成 catch 块 e1.printStackTrace(); } finally { try { conn.close(); } catch (SQLException e1) { // TODO 自动生成 catch 块 e1.printStackTrace(); } } } public List getEmps() { Connection conn = DBManger.getConnection(); List list = new ArrayList(); String sql = "select * from liuyanban"; try { Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql); while (rs.next()) { Conn e = new Conn(); e.setID(rs.getString("ID")); e.setName(rs.getString("name")); e.setEmail(rs.getString("email")); e.setSubject(rs.getString("subject")); list.add(e); } rs.close(); stmt.close(); } catch (SQLException e1) { // TODO 自动生成 catch 块 e1.printStackTrace(); } finally { try { conn.close(); } catch (SQLException e1) { // TODO 自动生成 catch 块 e1.printStackTrace(); } } return list; } public Conn findById(String id) { Connection conn = DBManger.getConnection(); Conn e = null; String sql = "select * from liuyanban where ID=?"; try { PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, id); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { e = new Conn(); e.setID(rs.getString("ID")); e.setName(rs.getString("name")); e.setEmail(rs.getString("email")); e.setSubject(rs.getString("subject")); } rs.close(); pstmt.close(); } catch (SQLException e1) { // TODO 自动生成 catch 块 e1.printStackTrace(); } finally { try { conn.close(); } catch (SQLException e1) { // TODO 自动生成 catch 块 e1.printStackTrace(); } } return e; } public List selectbylike(String ID) { String sql = "select * from liuyanban where ID like ?"; Connection conn = new DBManger().getConnection(); ID = "%" + ID + "%"; List list = new ArrayList(); try { PreparedStatement psmt = conn.prepareStatement(sql); psmt.setString(1, ID); ResultSet rs = psmt.executeQuery(); while (rs.next()) { Conn selb2 = new Conn(); selb2.setID(rs.getString(1)); selb2.setName(rs.getString(2)); selb2.setEmail(rs.getString(3)); selb2.setSubject(rs.getString(4)); list.add(selb2); } rs.close(); System.out.println("传递成功!!!!!"); psmt.close(); conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return list; } public void update(Conn e) { Connection conn = DBManger.getConnection(); String sql = "update liuyanban set name=?,email=?,subject=? where ID=?"; try { PreparedStatement pstmt = conn.prepareStatement(sql); pstmt.setString(1, e.getName()); pstmt.setString(2, e.getEmail()); pstmt.setString(3, e.getSubject()); pstmt.setString(4, e.getID()); pstmt.executeUpdate(); pstmt.close(); } catch (SQLException e1) { // TODO 自动生成 catch 块 e1.printStackTrace(); } finally { try { conn.close(); } catch (SQLException e1) { // TODO 自动生成 catch 块 e1.printStackTrace(); } } } }