jsp+servlet+javaBean自我大总结常用模式.doc

jsp+servlet+javaBean自我大总结常用模式<br>

<br>第一步：建一个操作员表。

createtableTOPERATOR
(
OPERATOR_IDNVARCHAR2(20)primarykey,
OPERATOR_NAMEVARCHAR2(20),
OPERATOR_PWDVARCHAR2(20),
IS_ADMINCHAR(1)
)

第二步：创建javaBean
/**o
*操作实体类
*
*@authorchenlijiang2010-12-1
*/
publicclassOperatorimplementsSerializable{
privatestaticfinallongserialVersionUID=1L;
publicstaticfinalintADMIN=1;
publicstaticfinalintOPER=2;
privateStringoperator_id;
privateStringoperator_name;
privateStringoperator_pwd;
privateStringis_admin;
publicStringgetOperator_id(){
returnoperator_id;
}

publicvoidsetOperator_id(StringoperatorId){
operator_id=operatorId;
}

publicStringgetOperator_name(){
returnoperator_name;
}

publicvoidsetOperator_name(StringoperatorName){
operator_name=operatorName;
}

publicStringgetOperator_pwd(){
returnoperator_pwd;
}

publicvoidsetOperator_pwd(StringoperatorPwd){
operator_pwd=operatorPwd;
}

publicStringgetIs_admin(){
returnis_admin;
}

publicvoidsetIs_admin(StringisAdmin){
is_admin=isAdmin;
}
}
第三步：建立一个类，封装所有数据库操作

/**
*把对数据库的操作放在本类中。update：对数据库的修改操作select:查询数据库中的数据
*
*@authorchenlijiang2010-12-14
*/
publicclassDbUtil{
privatefinalStringurl;
privatefinalStringuser;
privatefinalStringpassword;
privatefinalThreadLocal<Connection>th=newThreadLocal<Connection>();
static{
try{
Class.forName("oracle.jdbc.OracleDriver");
}catch(ClassNotFoundExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
}

privateDbUtil(){
url="jdbc:oracle:thin:@localhost:1521:orcl";
user="system";
password="orcl";
}
//单例模式
privatestaticDbUtildbUtil;
publicstaticDbUtilgetDbUtil(){
if(dbUtil==null){
dbUtil=newDbUtil();
}
returndbUtil;
}

//获得Connection连接
publicConnectiongetConnection(){
Connectionconn=th.get();
if(conn==null){
try{
conn=DriverManager.getConnection(url,user,password);
//conn.setAutoCommit(false);
th.set(conn);
}catch(SQLExceptione){
//TODOAuto-generatedcatchblock
e.printStackTrace();
}
}

returnconn;
}

//关闭连接
publicvoidcloseConnection(){
Connectionconn=th.get();
if(conn!=null){
try{
th.r