userregist.java

java 开发工具书上的一些代码

package com.netbeans.web;
import java.sql.*;
public class UserRegist {    
    /** Creates a new instance of UserRegist */
    private Connection con;
    private UserInfo userInfo;
    public UserRegist() {
    }
    public void setUserInfo(UserInfo userInfo){
        this.userInfo=userInfo;
    }
    public void regist(){
        String sql="insert into userinfo values(?,?,?,?,?)";
        PreparedStatement pstmt=null;//声明一个预处理对象
        try{
            this.connectTODB();
            //使用con创建一个预处理对象，并设置其参数
            pstmt=con.prepareStatement(sql);
            pstmt.setString(1,this.userInfo.getUserName());
            pstmt.setString(2,this.userInfo.getDepartName());
            pstmt.setString(3,this.userInfo.getSalary());
            pstmt.setString(4,this.userInfo.getJobPosition());
            pstmt.setString(5,this.userInfo.getDepartName());
            pstmt.executeUpdate();
        }catch(Exception e){
            e.printStackTrace();
        }finally{
            try{
                if(pstmt!=null){
                    pstmt.close();
                }
                if(con!=null){
                    con.close();
                }                
            }catch(Exception e){
                e.printStackTrace();
            }
        }
    }
    private void connectTODB(){
        String CLASSFORNAME="sun.jdbc.odbc.JdbcOdbcDriver";
        String CONNECTSTR="jdbc:odbc:javabean";
        try{
            Class.forName(CLASSFORNAME);
            this.con=DriverManager.getConnection(CONNECTSTR);
        } catch(Exception e) {
            e.printStackTrace();
        }
    }
    
}