資源簡介
全部功能源代碼,和數(shù)據(jù)庫建表語句,是個功能比較全的校友錄系統(tǒng)。

代碼片段和文件信息
package?bean;
import?java.sql.*;
public?class?Bean_to_Database{
??//聲明全局變量
??Connection?con;
??Statement?stmt;
??ResultSet?rs;
??
??//裝載驅動程序
??public?Bean_to_Database(){
????try{
??????Class.forName(“sun.jdbc.odbc.JdbcOdbcDriver“);
????}
????catch(ClassNotFoundException?e){
??????System.out.println(e.toString());
????}
??}
??//刪除的方法
??public?boolean?delete(String?sql){
????try{
??????con=DriverManager.getConnection(“jdbc:odbc:message_manager“““““);
??????stmt=con.createStatement();
??????sql=this.toChinese(sql);
??????stmt.executeUpdate(sql);
??????return(true);
????}
????catch(SQLException?e1){
??????System.out.println(e1.toString());
??????return(false);
????}?
??}
??//添加的方法
??public?boolean?add(String?sql){
????try{
??????con=DriverManager.getConnection(“jdbc:odbc:message_manager“““““);
??????stmt=con.createStatement();
??????//sql=this.toChinese(sql);
??????stmt.executeUpdate(sql);
??????return(true);
????}
????catch(SQLException?e2){
??????System.out.println(e2.toString());
??????return(false);
????}?
??}
??//查詢的方法
??public?ResultSet?query(String?sql){
????try{
??????con=DriverManager.getConnection(“jdbc:odbc:message_manager“““““);
??????stmt=con.createStatement();
??????//sql=this.toChinese(sql);
??????rs=?stmt.executeQuery(sql);
?????
????}
????catch(SQLException?e3){
??????System.out.println(e3.toString());
????}??
?????return?rs;?
??}
??public??static?String?toChinese(String?str){
?? try{
?? ??if(str==null)
?? ????return?null;
??
?? ??else
?? ???str=new?String(str.getBytes(“ISO8859-1“)“GBK“);
?? ???return?str;
?? }??
?? catch(Exception?e){
?? return?e.toString();
??
?? }
??
??
?? }
}
//這里沒有關閉連接和容器
//刪除的方法和添加的方法一樣是否可以合并
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-09-05?09:56??同學錄源代碼\
?????目錄???????????0??2014-08-26?09:17??同學錄源代碼\tongxunlu\
?????文件????????8395??2006-08-28?19:51??同學錄源代碼\tongxunlu\ADDO.JSP
?????文件????????6303??2006-08-27?12:21??同學錄源代碼\tongxunlu\ADDOO.JSP
?????文件????????9201??2006-08-28?19:54??同學錄源代碼\tongxunlu\ADDS.JSP
?????文件????????6935??2006-08-27?12:20??同學錄源代碼\tongxunlu\ADDSS.JSP
?????文件????????8588??2006-08-28?19:55??同學錄源代碼\tongxunlu\ADDT.JSP
?????文件????????6353??2006-08-27?12:22??同學錄源代碼\tongxunlu\ADDTT.JSP
?????文件????????1201??2006-08-28?20:10??同學錄源代碼\tongxunlu\CHAKAN.JSP
?????文件????????2155??2006-08-27?11:59??同學錄源代碼\tongxunlu\CHAXUN.JSP
?????文件?????????823??2006-08-27?11:12??同學錄源代碼\tongxunlu\CHAXUN1.JSP
?????文件?????????561??2006-08-21?10:30??同學錄源代碼\tongxunlu\CONN.JSP
?????文件?????????712??2006-08-20?21:30??同學錄源代碼\tongxunlu\DEL_O.JSP
?????文件?????????735??2006-08-20?21:31??同學錄源代碼\tongxunlu\DEL_S.JSP
?????文件?????????738??2006-08-28?20:17??同學錄源代碼\tongxunlu\DEL_T.JSP
?????文件?????????504??2006-08-20?10:40??同學錄源代碼\tongxunlu\FOOTER.JSP
?????文件????????7307??2006-08-28?20:54??同學錄源代碼\tongxunlu\GAI_O.JSP
?????文件????????7969??2006-08-28?20:54??同學錄源代碼\tongxunlu\GAI_S.JSP
?????文件????????7394??2006-08-28?20:52??同學錄源代碼\tongxunlu\GAI_T.JSP
?????文件???????17907??2006-08-21?15:00??同學錄源代碼\tongxunlu\GENGGAI.JSP
?????文件?????????414??2006-08-20?17:09??同學錄源代碼\tongxunlu\HEADER1.JSP
?????目錄???????????0??2013-09-05?09:56??同學錄源代碼\tongxunlu\IMAGES\
?????文件???????19855??2006-07-27?20:49??同學錄源代碼\tongxunlu\IMAGES\10.JPG
?????文件??????186875??2006-08-20?10:50??同學錄源代碼\tongxunlu\IMAGES\7.GIF
?????文件???????31559??2006-07-27?19:13??同學錄源代碼\tongxunlu\IMAGES\HNUIN.JPG
?????文件???????15872??2007-10-02?22:34??同學錄源代碼\tongxunlu\IMAGES\Thumbs.db
?????文件????????4339??2006-07-27?18:56??同學錄源代碼\tongxunlu\IMAGES\u=6218785292949642169&gp=1.jpg
?????文件????????1871??2014-08-26?09:17??同學錄源代碼\tongxunlu\LOGIN.JSP
?????文件????????1875??2006-08-26?16:14??同學錄源代碼\tongxunlu\LOGIN.JSP.bak
?????文件?????????294??2006-08-21?11:08??同學錄源代碼\tongxunlu\LOGOUT.JSP
?????文件????????1105??2006-08-18?15:54??同學錄源代碼\tongxunlu\SHANCHU.JSP
............此處省略74個文件信息
評論
共有 條評論