struts2 + jsp 简单通讯录

package com.wd.Dao; 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.wd.model.Contacts; public class ContactsDao extends ConnJdbc{ public static final String EDIT = "update coninfo set tellphone = ? where username = ? and contacts = ?"; public static final String DELETE = "delete from coninfo where username = ? and contacts = ?"; public static final String FINFBYUAC = "select * from coninfo where username = ? and contacts = ?"; public static final String SAVACONT = "insert into coninfo (username,contacts,tellphone) values (?,?,?)"; public static final String FIND ="select * from coninfo where username = ? and contacts like ?"; //修改电话号码 public void update(Contacts cont){ try { Connection conn = getConnection(); PreparedStatement pre = conn.prepareStatement(EDIT); pre.setString(1, cont.getTellphone()); pre.setString(2, cont.getUsername()); pre.setString(3, cont.getContacts()); pre.executeUpdate(); conn.close(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } //保存联系人信息 public void save(Contacts cont){ try { Connection conn = getConnection(); PreparedStatement pre = conn.prepareStatement(SAVACONT); pre.setString(1, cont.getUsername()); pre.setString(2, cont.getContacts()); pre.setString(3, cont.getTellphone()); pre.executeUpdate(); pre.close(); conn.close(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } //根据用户名和联系人名查找 public Contacts findByUAC(String username,String contacts){ Contacts cont = null; try { Connection conn = getConnection(); PreparedStatement pre = conn.prepareStatement(FINFBYUAC); pre.setString(1, username); pre.setString(2, contacts); ResultSet res = pre.executeQuery(); while(res.next()){ cont = new Contacts(); cont.setUsername(res.getString("username")); cont.setContacts(res.getString("contacts")); cont.setTellphone(res.getString("tellphone")); } pre.close(); res.close(); conn.close(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return cont; } //删除记录 public void delete(String username,String contacts){ try { Connection conn = getConnection(); PreparedStatement pre = conn.prepareStatement(DELETE); pre.setString(1, username); pre.setString(2, contacts); pre.execute(); pre.close(); conn.close(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } //根据用户名和联系人修改号码 public List<Contacts> findByContacts(String username,String name){ ArrayList<Contacts> conts = new ArrayList<Contacts>(); try { Connection conn = getConnection(); PreparedStatement pre = conn.prepareStatement(FIND); pre.setString(1, username); pre.setString(2, "%" + name + "%"); ResultSet res = pre.executeQuery(); while(res.next()){ Contacts cont = new Contacts(); cont.setUsername(res.getString("username")); cont.setContacts(res.getString("contacts")); cont.setTellphone(res.getString("tellphone")); conts.add(cont); } pre.close(); res.close(); conn.close(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return conts; } }