addressbook(struts增删改查例子)

package com.addressbook.model; import java.sql.SQLException; import java.util.List; public class AddressBO { public List findByProperty(){ java.sql.Connection con=null; java.sql.PreparedStatement pstmt=null; java.sql.ResultSet rs=null; try { con=com.addressbook.db.DBConnection.getConnection(); String sql="select * from addressbook where"; if(this.name!=null || !this.name.equals("")){ sql+=" name like '%"+this.name+"%' and"; } if(this.phone!=null || !this.phone.equals("")){ sql+=" phone like '%"+this.phone+"%' and"; } if(this.address!=null || !this.address.equals("")){ sql+=" address like '%"+this.address+"%' and"; } pstmt=con.prepareStatement(sql.substring(0,sql.length()-3) +" order by id"); rs=pstmt.executeQuery(); java.util.List list=new java.util.ArrayList(); while(rs.next()){ AddressBO ab=new AddressBO(); ab.setAddress(rs.getString("address")); ab.setId(rs.getInt("id")); ab.setName(rs.getString("name")); ab.setPhone(rs.getString("phone")); list.add(ab); } return list; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ try { rs.close(); pstmt.close(); con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return null; } public void insert(){ java.sql.Connection con=null; java.sql.PreparedStatement pstmt=null; try { con=com.addressbook.db.DBConnection.getConnection(); pstmt=con.prepareStatement("insert into addressbook values(?,?,?)"); pstmt.setString(1, this.name); pstmt.setString(2, this.phone); pstmt.setString(3,this.address); pstmt.executeUpdate(); //rs=pstmt.executeQuery(); //return list; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ try { //rs.close(); pstmt.close(); con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } //return null; } public List findAll(){ java.sql.Connection con=null; java.sql.PreparedStatement pstmt=null; java.sql.ResultSet rs=null; try { con=com.addressbook.db.DBConnection.getConnection(); pstmt=con.prepareStatement("select * from addressbook"); rs=pstmt.executeQuery(); java.util.List list=new java.util.ArrayList(); while(rs.next()){ AddressBO ab=new AddressBO(); ab.setAddress(rs.getString("address")); ab.setId(rs.getInt("id")); ab.setName(rs.getString("name")); ab.setPhone(rs.getString("phone")); list.add(ab); } return list; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ try { rs.close(); pstmt.close(); con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return null; } private String name; private String phone; private String address; private int id; public String getName() { return name; } public void setName(String name) { this.name = name; } public String getPhone() { return phone; } public void setPhone(String phone) { this.phone = phone; } public String getAddress() { return address; } public void setAddress(String address) { this.address = address; } public int getId() { return id; } public void setId(int id) { this.id = id; } }