javaBean封裝數(shù)據(jù)庫的訪問

111111111111111111111111111111111111111111111111111111111111111packagecom;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;publicclassdb(Stringurl="jdbc:mysql://localhost/liuyan?useUnicode=true&characterEncoding=gb2312";Stringusername="root”;Stringpassword="lovebin”;Connectioncon=null;Statementstmt;ResultSetrs;publicdb()(stmt=null;rs=null;try{Class.forName("com.mysql.jdbc.Driver");}catch(ClassNotFoundExceptione){System.out.println("loadDriverexception");}try{con=DriverManager.getConnection(url,username,password);}catch(SQLExceptione){System.out.println("SQLexception");}if(con!=null){System.out.println("lianjiechenggong");}}publicbooleanexeSql(StringstrSql){try{stmt=con.createStatement();stmt.executeUpdate(strSql);returntrue;}catch(Exceptionex){System.out.println(ex.toString());returnfalse;}publicResultSetexeSqlQuery(StringstrSql){try{stmt=con.createStatement();rs=stmt.executeQuery(strSql);}catch(Exceptionex){System.out.println(ex.toString());rs=null;}returnrs;}}2222222222222222222222222222222222222222222222222222222222222222packagecom;importjava.sql.*;importjava.text.*;publicclassusersextendsdb{privateintUserID;privateStringUserName;privateStringUserPassword;privateStringstrSql;publicusers(){UserID=0;UserName="”;UserPassword="”;strSql="”;}publicbooleanadd_user(){strSql="insertintousers(UserName,UserPassword)”;strSql=strSql+"values(";strSql=strSql+””'+UserName+"',”;strSql=strSql+"'"+UserPassword+"'";strSql=strSql+")”;booleanisAdd=super.exeSql(strSql);returnisAdd;}publicbooleanis_exist()strSql="select*from'users'whereUserName=UserName”;ResultSetrs=null;booleanisExist=false;try{rs=super.exeSqlQuery(strSql);while(rs.next()){isExist=true;}}catch(Exceptionex){System.out.println(ex.toString());}returnisExist;}publicbooleanuser_valid(){strSql="select*fromuserswhereUserName="+””'+UserName+””'+"andUserPassword="+"'"+UserPassword+"'";ResultSetrs=null;booleanisvalid=false;try{rs=super.exeSqlQuery(strSql);while(rs.next()){this.UserID=rs.getInt("UserID");isvalid=true;}}catch(Exceptionex){System.out.println(ex.toString());}returnisvalid;}publicbooleaninit(){strSql="select*fromuserswhereUserID=";strSql=strSql+UserID;try{ResultSetrs=super.exeSqlQuery(strSql);if(rs.next()){this.UserID=rs.getInt("UserID");this.UserName=rs.getString("UserName");this.UserPassword=rs.getString("UserPassword");returntrue;}else{returnfalse;}}catch(Exceptionex){System.out.println(ex.toString());returnfalse;}}publicResultSetshow_all_users(){strSql="select*fromusers";ResultSetrs=null;try{rs=super.exeSqlQuery(strSql);}catch(Exceptionex){System.out.println(ex.toString());}returnrs;}publicintgetUserID(){returnUserID;}publicvoidsetUserID(intuserID){UserID=userID;}publicStringgetUserName(){returnUserName;}publicvoidsetUserName(StringuserName){UserName=userName;}publicStringgetUserPassword(){returnUserPassword;}publicvoidsetUserPassword(StringuserPassword){UserPassword=userPassword;333333333333333333333333333333333333333333333333packagecom;importjava.sql.*;importjava.text.*;publicclasswordsextendsdb(privateintWordsID;privateStringWordsTitle;privateStringWordsContent;privateStringWordsTime;privateintUserID;privateStringstrSql;privateSimpleDateFormattimeFormatter;publicwords(){WordsID=0;WordsTitle="”;WordsContent="”;UserID=0;WordsTime=timeFormatter.format(newjava.util.Date());strSql="”;timeFormatter=newSimpleDateFormat("yyyy-mm-ddhh:mm:ss");}publicbooleanadd_words(){strSql="insertintowords(WordsTitle,WordsContent,WordsTime,UserID)”;strSql=strSql+"values(WordsTitle,WordsContent,WordsTime,UserID)”;booleanisAdd=super.exeSql(strSql);returnisAdd;}publicbooleaninit(){strSql="select*fromwordswhereWordsID=";strSql=strSql+WordsID;try{ResultSetrs=super.exeSqlQuery(strSql);if(rs.next())this.WordsID=rs.getInt(WordsID);this.WordsTitle=rs.getString(WordsTitle);this.WordsContent=rs.getString(WordsContent);this.WordsTime=rs.getString(WordsTime);this.UserID=rs.getInt(UserID);returntrue;}else{returnfalse;}}catch(Exceptionex){System.out.println(ex.toString());returnfalse;}}publicResultSetshow_all_words(){strSql="select*fromwords";ResultSetrs=null;try{rs=super.exeSqlQuery(strSql);}catch(Exceptionex){System.out.println(ex.toString());}returnrs;}publicintgetWordsID(){returnWordsID;}publicvoidsetWordsID(intwordsID){WordsID=wordsID;}publicStringgetWordsTitle(){returnWordsTitle;}publicvoidsetWordsTitle(StringwordsTitle){WordsTitle=wordsTitle;}publicStringgetWordsContent(){returnWordsContent;}publicvoidsetWordsContent(StringwordsContent)(WordsContent=wordsContent;}publicStringgetWordsTime()(returnWordsTime;}publicvoidsetWordsTime(StringwordsTime)(WordsTime=wordsTime;