prg.rar_jsp通讯录_通讯录_项目管理

package com.prg.dao; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.prg.model.entity.AddressBook; public class AddressBookDao { PreparedStatement pre=null; ResultSet res=null; //鏌ヨ鎵�湁鐗╁搧淇℃伅 public List queryAll(){ List<AddressBook> list=new ArrayList<AddressBook>(); String sql="select * from addressInfo"; new DBConn().getConn(); try { pre=DBConn.conn.prepareStatement(sql); res=pre.executeQuery(); while(res.next()){ AddressBook add=new AddressBook(); add.setId(res.getInt(1)); add.setName(res.getString(2)); add.setSex(res.getString(3)); add.setAddress(res.getString(4)); add.setPhoneNum(res.getString(5)); add.setQq(res.getString(6)); add.setShipId(res.getInt(8)); add.setEmail(res.getString(7)); list.add(add); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ try { res.close(); pre.close(); DBConn.conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return list; } public boolean remove(int gnu){ String sql="delete from addressInfo where id="+gnu; boolean fag=false; new DBConn().getConn(); try { pre=DBConn.conn.prepareStatement(sql); int a=pre.executeUpdate(); if(a>0){ fag=true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ try { pre.close(); DBConn.conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return fag; } public boolean add(AddressBook add){ boolean fag=false; String sql="insert into addressInfo values('"+add.getName()+"','"+add.getSex()+"','"+add.getAddress()+"','"+add.getPhoneNum()+"','"+add.getQq()+"','"+add.getEmail()+"',"+add.getShipId()+")"; new DBConn().getConn(); int a=0; try { pre=DBConn.conn.prepareStatement(sql); a=pre.executeUpdate(); if(a>0){fag=true;} } catch (SQLException e) { e.printStackTrace(); }finally{ try { pre.close(); DBConn.conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return fag; } public boolean update(AddressBook add){ boolean fag=false; String sql="update addressInfo set name='"+add.getName()+"',"+"phoneNum='"+add.getPhoneNum()+"',"+"qq='"+add.getQq()+"',"+"address='"+add.getAddress()+"',"+"email='"+add.getEmail()+"',"+"ship="+add.getShipId()+"where id="+add.getId(); System.out.println(sql); int b=0; new DBConn().getConn(); try { pre=DBConn.conn.prepareStatement(sql); b=pre.executeUpdate(); if(b>0){ fag=true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ try { pre.close(); DBConn.conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return fag; } public AddressBook searchOne(int id){ String sql="select * from addressInfo where id="+id; AddressBook add=new AddressBook(); new DBConn().getConn(); try { pre=DBConn.conn.prepareStatement(sql); res=pre.executeQuery(); while(res.next()){ add.setId(res.getInt(1)); add.setName(res.getString(2)); add.setSex(res.getString(3)); add.setAddress(res.getString(4)); add.setPhoneNum(res.getString(5)); add.setQq(res.getString(6)); add.setShipId(res.getInt(8)); add.setEmail(res.getString(7)); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ try { res.close(); pre.close(); DBConn.conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return add; } }