資源簡介
很好的例子哦 大家可以借鑒一下 希望提出寶貴意見

代碼片段和文件信息
package?ku;
import?java.sql.*;
public?class?Sql?{
?String?sDBDriver=“sun.jdbc.odbc.JdbcOdbcDriver“;
??String?sConnStr=“jdbc:odbc:abc“;
Connection?connect=null;
ResultSet?rs=null;
????public?Sql(){
???? try{
???? Class.forName(sDBDriver);
???? }catch(java.lang.ClassNotFoundException?e){
???? System.err.println(e.getMessage());
???? }
????}
//執行查詢類的語句。有返回
????public?ResultSet?executeQuery(String?sql)?{
try{
connect=DriverManager.getConnection(sConnStr);
Statement?stmt=connect.createStatement();
rs=stmt.executeQuery(sql);
}catch(SQLException?ex){
System.err.println(ex.getMessage());
}
return?rs;
}
????//執行更新類的語句?無返回
????public?void?executeUpdate(String?sql)
????{
????
???? Statement?stmt=null;
???? rs=null;
???? try
???? {???connect=DriverManager.getConnection(sConnStr);
???? stmt=connect.createStatement();
???? stmt.executeUpdate(sql);
???? stmt.close();
???? connect.close();
???? }
???? catch(SQLException?ex)
???? {
???? System.err.println(ex.getMessage());
???? }
????
????
????}
???
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件??????????0??2070-06-16?08:30??CG7條\.me
?????文件??????94530??2008-06-18?10:08??CG7條\.me
?????文件?????????26??2008-06-20?09:04??CG7條\.me
?????文件???????3428??2008-06-17?11:21??CG7條\.me
?????文件??????24797??2008-06-20?09:04??CG7條\.me
?????文件??????????0??2070-06-16?08:31??CG7條\.me
?????文件???????1479??2008-06-18?09:47??CG7條\.me
?????文件????????987??2070-06-16?10:13??CG7條\.me
?????文件???????1302??2070-06-16?09:49??CG7條\.me
?????文件???????1986??2008-06-17?09:58??CG7條\.me
?????文件????????835??2008-06-17?08:53??CG7條\.me
?????文件???????1128??2070-06-16?10:40??CG7條\.me
?????文件???????1211??2008-06-17?09:53??CG7條\.me
?????文件???????1543??2008-06-17?09:53??CG7條\.me
?????文件???????1784??2008-06-17?11:09??CG7條\.me
?????文件???????1200??2070-06-16?09:58??CG7條\.me
?????文件???????1303??2008-06-17?11:19??CG7條\.me
?????文件???????1805??2008-06-18?10:05??CG7條\.me
?????文件???????1686??2008-06-17?10:33??CG7條\.me
?????文件???????1531??2008-06-17?10:21??CG7條\.me
?????文件???????1797??2008-06-18?09:35??CG7條\.me
?????文件????????835??2070-06-16?09:17??CG7條\.me
?????文件???????1598??2008-06-18?08:59??CG7條\.me
?????文件???????2014??2008-06-18?09:55??CG7條\.me
?????文件???????1997??2008-06-18?09:56??CG7條\.me
?????文件???????2014??2008-06-18?09:55??CG7條\.me
?????文件????????835??2070-06-16?09:29??CG7條\.me
?????文件??????????0??2070-06-16?10:29??CG7條\.me
?????文件???????1407??2008-06-17?09:58??CG7條\.me
?????文件???????1804??2008-06-17?10:44??CG7條\.me
............此處省略428個文件信息
評論
共有 條評論