addressbookbean.java

swnglu数据库连接统struts和hinernate

package model;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;


public class AddressBookBean {
	private String name;
	private String phone;
	private String address;
	private String email;
	
	public AddressBookBean(	String name, String phone, String address,String email){
		this.name = name;
		this.phone = phone;
		this.address =  address;
		this.email=email;
		
	}
	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	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 void insert() throws Exception{
		Connection conn = null;
		PreparedStatement pStmt = null;
		String strsql = null;
		
		try{
		conn = DbUtil.connectToDb();
		
		conn.setAutoCommit(false);
		
		strsql = "INSERT INTO T_ADDRESSBOOK VALUES(?,?,?);";
		pStmt = conn.prepareStatement(strsql);
		pStmt.setString(1, name);
		pStmt.setString(2, phone);
		pStmt.setString(3, address);
		pStmt.setString(4, email);
		pStmt.executeUpdate();
		
		conn.commit();
		
		}
		catch(Exception e){
			try{
			conn.rollback();
			}
			catch(SQLException ex){
				ex.printStackTrace();
			}
			throw e;
			
		}
		finally{
			pStmt.close();
			conn.close();
		}
	}
	
	public  static Vector search(String strsql) throws Exception{
		Vector addressbookbeans = new Vector();
		Connection conn = null;
		PreparedStatement pStmt = null;
		ResultSet rst = null;
		
		conn = DbUtil.connectToDb();
		pStmt = conn.prepareStatement(strsql);
		rst = pStmt.executeQuery();
		
		while(rst.next()){
			//System.out.print(rst.getString("name"));
			//System.out.print(rst.getString("phone"));
			//System.out.println(rst.getString("address"));
			addressbookbeans.add(new AddressBookBean(
					rst.getString("name"),
					rst.getString("phone"),
					rst.getString("email"),
					rst.getString("address")));
		}
		
		rst.close();
		pStmt.close();
		conn.close();
		return addressbookbeans;
		
	}


	/*
	 * public static void main(String[] args) {
		// TODO Auto-generated method stub
		AddressBookBean abb = new AddressBookBean("frend1","12345678","address1");
		try{
			Vector myabbs = abb.search("select * from t_addressbook");
		abb.insert();
		System.out.println(" success");
		}
		catch(Exception e){
			e.printStackTrace();
		}

	}
	 */
	

}