資源簡介
隨著時代的發展,學生不再是一味地被強制上課,而是可以根據每個人的不同安排,自主地選擇課程。學生選課系統數據庫正是由此應運而生。 選課系統數據庫是為了向廣大師生提供課程的信息,一方面支持學生自主選課,一方面支持教務員,系統管理員提供給師生的管理服務。

代碼片段和文件信息
package?test;
import?java.sql.*;
public?class?CreateCoffees?{
????public?static?void?main(String?args[])?{
????????String?url?=?“jdbc:mysql://localhost/sample“;
????????Connection?con?=?null;
????????String?createString;
????????createString?=?“create?table?COFFEES?“?+
????????????????????????????“(COF_NAME?VARCHAR(32)?“?+
????????????????????????????“SUP_ID?INTEGER?“?+
????????????????????????????“PRICE?FLOAT?“?+
????????????????????????????“SALES?INTEGER?“?+
????????????????????????????“TOTAL?INTEGER)“;
????????Statement?stmt?=?null;
????????try?{
????????????Class.forName(“com.mysql.jdbc.Driver“);
????????}?catch(java.lang.ClassNotFoundException?e)?{
????????????System.err.print(“ClassNotFoundException:?“);
????????????System.err.println(e.getMessage());
????????}
????????try?{
????????????con?=?DriverManager.getConnection(url“root“?“1234“);
????????????stmt?=?con.createStatement();
????????????stmt.executeUpdate(createString);????????????
????????}?catch(SQLException?ex)?{
????????????System.err.println(“SQLException:?“?+?ex.getMessage());
????????}?finally?{
???????? try?{
stmt.close();
}?catch?(SQLException?e)?{
e.printStackTrace();
}
????????????????try?{
con.close();
}?catch?(SQLException?e)?{
e.printStackTrace();
}
????????}
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????349??2008-03-08?14:56??選課\JDBC1例子代碼\.classpath
?????文件????????381??2008-03-08?14:56??選課\JDBC1例子代碼\.project
?????文件???????2145??2008-03-08?19:44??選課\JDBC1例子代碼\bin\test\CreateCoffees.class
?????文件???????2638??2008-03-08?20:01??選課\JDBC1例子代碼\bin\test\InsertCoffees.class
?????文件???????2525??2008-03-08?20:38??選課\JDBC1例子代碼\bin\test\Join.class
?????文件???????3191??2008-03-08?20:01??選課\JDBC1例子代碼\bin\test\SelectCoffees.class
?????文件???????2985??2008-03-09?18:00??選課\JDBC1例子代碼\bin\test\TransactionPairs.class
?????文件???????2834??2008-03-08?20:28??選課\JDBC1例子代碼\bin\test\UpdateCoffees.class
?????目錄??????????0??2008-05-05?14:34??選課\JDBC1例子代碼\bin\test
?????目錄??????????0??2008-05-05?14:34??選課\JDBC1例子代碼\bin
?????文件???????1349??2008-03-08?19:44??選課\JDBC1例子代碼\src\test\CreateCoffees.java
?????文件???????1461??2008-03-08?20:01??選課\JDBC1例子代碼\src\test\InsertCoffees.java
?????文件???????1799??2008-03-08?20:38??選課\JDBC1例子代碼\src\test\Join.java
?????文件???????1596??2008-04-21?09:25??選課\JDBC1例子代碼\src\test\SelectCoffees.java
?????文件???????1998??2008-03-09?18:00??選課\JDBC1例子代碼\src\test\TransactionPairs.java
?????文件???????1516??2008-03-08?20:28??選課\JDBC1例子代碼\src\test\UpdateCoffees.java
?????目錄??????????0??2008-05-05?14:34??選課\JDBC1例子代碼\src\test
?????目錄??????????0??2008-05-05?14:34??選課\JDBC1例子代碼\src
?????目錄??????????0??2008-05-05?14:34??選課\JDBC1例子代碼
?????文件????????232??2008-03-08?20:40??選課\JDBC2例子代碼\.classpath
?????文件????????381??2008-03-08?20:40??選課\JDBC2例子代碼\.project
?????文件????????608??2008-03-08?21:55??選課\JDBC2例子代碼\bin\blob\BlobSelect$1.class
?????文件???????3331??2008-03-08?21:55??選課\JDBC2例子代碼\bin\blob\BlobSelect.class
?????文件???????2704??2008-03-08?21:53??選課\JDBC2例子代碼\bin\blob\InsertPictureToMySql.class
?????目錄??????????0??2008-05-05?14:34??選課\JDBC2例子代碼\bin\blob
?????文件????????628??2008-03-09?09:47??選課\JDBC2例子代碼\bin\clob\ClobSelectMySQL$1.class
?????文件???????3722??2008-03-09?09:47??選課\JDBC2例子代碼\bin\clob\ClobSelectMySQL.class
?????文件???????3013??2008-03-09?09:41??選課\JDBC2例子代碼\bin\clob\InsertTextFileToMySQL.class
?????目錄??????????0??2008-05-05?14:34??選課\JDBC2例子代碼\bin\clob
?????文件???????3271??2008-03-09?10:08??選課\JDBC2例子代碼\bin\date\TestNormalization.class
............此處省略94個文件信息
- 上一篇:DAC7811資料以及驅動程序
- 下一篇:招干考試管理系統*源代碼
評論
共有 條評論