package?db;
import?java.sql.*;?
public?class?QueryBean?
{?
??public?String?query_statement;?/*定義sql語句*/?
??public?String?param[];?/*查詢條件*/?
??public?ResultSet?result=null;?/*查詢結(jié)果*/
??public?Connection?conn;?
??//設(shè)置查詢參數(shù)
??public?void?setParam（String[]?param）?
??{?
????this.param=param;?
??}?
??//設(shè)置SQL查詢語句
??public?void?setQuerystatement（String?query_statement）?
??{?
????this.query_statement=query_statement;?
??}?
??//設(shè)置連接參數(shù)
??public?void?setConnection（String?driverNameString?jdbcURLString?usernameString?passwd）?throws?Exception?
??{?
????Connection?conn1;?
????Class.forName（driverName）;?
????conn1=DriverManager.getConnection（jdbcURLusernamepasswd）;?
????conn1.setAutoCommit（false）;?
????this.conn?=?conn1;?
??}?
??/*獲取查詢結(jié)果*/?
??public?ResultSet?getResult（）?
??{?
????try?
????{?
??????PreparedStatement?select_stm=conn.prepareStatement（query_statementjava.sql.ResultSet.TYPE_SCROLL_INSENSITIVEjava.sql.ResultSet.CONCUR_READ_ONLY）;?
??????if?（param!=null）?
????????for（int?i=0;i?????????select_stm.setString（i+1param[i]）;?
??????result=select_stm.executeQuery（）;?
????}catch（Exception?e）{System.out.println（e）;}?
????return?result;?
??}?
??/*對(duì)數(shù)據(jù)庫(kù)進(jìn)行增加記錄操作*/?
??public?void?insertRecord（）?throws?SQLExceptionjava.io.UnsupportedEncodingException?
??{?
????try?
????{?
??????PreparedStatement?insert_stm=conn.prepareStatement（query_statement）;?
??????if?（param!=null）?
????????for（int?i=0;i???????????insert_stm.setString（i+1param[i]）;?
??????insert_stm.executeUpdate（）;?
??????insert_stm.close（）;?
??????conn.commit（）;?
????}?
????catch（Exception?e）?
????{?
??????System.out.println（e）;?
??????conn.rollback（）;?
????}?
??}?
??/*對(duì)數(shù)據(jù)記錄進(jìn)行更新操作*/?
??public?void?updateRecord（）?throws?SQLExceptionjava.io.UnsupportedEncodingException?
??{?
????try?
????{?
??????PreparedStatement?update_stm=conn.prepareStatement（query_statement）;?
??????if?（param!=null）?
????????for?（int?i=0;i??????????update_stm.setString（i+1param[i]）;?
??????update_stm.executeUpdate（）;?
??????update_stm.close（）;?
??????conn.commit（）;?
?????}?
?????catch（Exception?e）?
?????{?
???????System.out.println（e）;?
???????conn.rollback（）;?
?????}?
??}?
??/*刪除數(shù)據(jù)記錄*/?
??public?void?deleteRecord（）?throws?SQLExceptionjava.io.UnsupportedEncodingException?
??{?
????try?
????{?
??????PreparedStatement?delete_stm=conn.prepareStatement（query_statement）;?
??????if?（param!=null）?
????????for?（int?i=0;i??????????delete_stm.setString（i+1param[i]）;?
??????delete_stm.executeUpdate（）;?
??????delete_stm.close（）;?
??????conn.commit（）;?
????}?
????catch（Exception?e）?
????{?
??????System.out.println（e）;?
??????conn.rollback（）;?
????}?
???}?
}?

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????154??2005-12-21?16:07??蔣星海?05062037\jsp\accesspage.jsp

?????文件????????759??2005-12-21?16:52??蔣星海?05062037\jsp\accesspagea.jsp

?????文件???????4170??2008-09-01?09:07??蔣星海?05062037\jsp\air.jpg

?????文件????????190??2008-09-01?10:31??蔣星海?05062037\jsp\connect.jsp

?????文件?????147456??2006-04-29?10:58??蔣星海?05062037\jsp\db\msg.mdb

?????文件????????192??2008-09-01?09:28??蔣星海?05062037\jsp\db1\member.ldb

?????文件?????233472??2008-06-22?07:39??蔣星海?05062037\jsp\db1\member.mdb

?????文件???????1027??2008-06-22?08:47??蔣星海?05062037\jsp\home.gif

?????文件????????128??2008-06-22?09:18??蔣星海?05062037\jsp\left.html

?????文件???????1750??2005-12-21?15:57??蔣星海?05062037\jsp\login.jsp

?????文件???????2130??2005-12-21?16:23??蔣星海?05062037\jsp\logina.jsp

?????文件????????468??2005-12-21?16:56??蔣星海?05062037\jsp\logout.jsp

?????文件???????3091??2008-06-22?06:58??蔣星海?05062037\jsp\main.jsp

?????文件????????288??2008-09-01?11:44??蔣星海?05062037\jsp\main3.html

?????文件????????267??2008-06-22?08:24??蔣星海?05062037\jsp\me.jsp

?????文件????????594??2005-12-23?15:22??蔣星海?05062037\jsp\msg.html

?????文件???????3280??2008-06-22?10:26??蔣星海?05062037\jsp\my3.html

?????文件???????1187??2008-06-22?07:37??蔣星海?05062037\jsp\mym.jsp

?????文件??????25675??2008-09-01?09:05??蔣星海?05062037\jsp\pic\20072241444371444.jpg

?????文件???????1062??2001-06-18?17:24??蔣星海?05062037\jsp\pic\first.jpg

?????文件???????1829??2001-06-21?13:43??蔣星海?05062037\jsp\pic\icon0.jpg

?????文件???????1830??2001-06-21?13:43??蔣星海?05062037\jsp\pic\icon1.jpg

?????文件???????1781??2001-06-21?13:43??蔣星海?05062037\jsp\pic\icon2.jpg

?????文件???????1987??2001-06-21?13:43??蔣星海?05062037\jsp\pic\icon3.jpg

?????文件???????1916??2001-06-21?13:43??蔣星海?05062037\jsp\pic\icon4.jpg

?????文件???????1054??2001-06-18?17:24??蔣星海?05062037\jsp\pic\last.jpg

?????文件???????2656??2001-06-21?01:13??蔣星海?05062037\jsp\pic\msg.jpg

?????文件????????966??2001-06-18?17:24??蔣星海?05062037\jsp\pic\next.jpg

?????文件????????993??2001-06-18?17:24??蔣星海?05062037\jsp\pic\previous.jpg

????..A.SH.?????28672??2008-09-01?09:44??蔣星海?05062037\jsp\pic\Thumbs.db

............此處省略496個(gè)文件信息