myaddressdao.java

JSP通讯录程序(适合初学者研究),JSP通讯录程序(适合初学者研究)

package dao;
import java.sql.*;
import java.util.*;
import connectionMananger.*;
import Bean.*;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class myaddressDao {
    private Connection conn = null;
    private PreparedStatement prst = null;
    private ResultSet rst = null;
    public Vector getAllDatas(String sql){
        Vector ve = new Vector();
        try{
            conn = CoonactionManager.getCon();
            prst = conn.prepareStatement(sql);
            rst = prst.executeQuery();
            while(rst.next()){
                MyaddressBean bean = new MyaddressBean();
                bean.setId(rst.getInt(1));
                bean.setFirstname(rst.getString(2));
                bean.setLastname(rst.getString(3));
                bean.setDepartment(rst.getString(5));
                bean.setJobTitle(rst.getString(4));
                bean.setOffph(rst.getInt(6));
                bean.setMobile(rst.getInt(7));
                bean.setEmail(rst.getString(8));
                ve.add(bean);
            }
        }
        catch(Exception ex){
            ex.printStackTrace();
        }
        finally
        {
           //this.CloseAll();
        }
        return ve;
    }
    public int InsertInf(String sql){
        int n = 0;
        try{
            conn = CoonactionManager.getCon();
            prst = conn.prepareStatement(sql);
            n = prst.executeUpdate();
        }
        catch(Exception ex){
            ex.printStackTrace();
        }
        finally{
            //this.CloseAll();
        }
        return n;
    }
    public int DeleteUser(String sql){
        int n = 0;
        try{
            conn = CoonactionManager.getCon();
            prst = conn.prepareStatement(sql);
            n = prst.executeUpdate();
        }
        catch(Exception ex){
            ex.printStackTrace();
        }
        return n;
    }
    public int Update(String sql){
        int n = 0;
        try{
            conn =CoonactionManager.getCon();
            prst = conn.prepareStatement(sql);
            n = prst.executeUpdate();
        }
        catch(Exception ex){
            ex.printStackTrace();
        }
        return n;
    }
    public void CloseAll(){
        try{
            if(conn!=null)conn.close();
            if(prst!=null)prst.close();
            if(rst!=null)rst.close();
        }
        catch(Exception ex){
            ex.printStackTrace();
    }
    }
}