資源簡介
java題庫試卷管理系統【適宜用于畢設】:
功能:試題的新增、刪除、查詢(試題類型支持:選擇題、填空題、判斷題、簡答題、論述題); 試卷的新增、查詢、刪除(一個試卷對應多個試題)。
注:修改PaperSystem.java中的url后即可連接數據庫執行(使用mysql數據庫,并提供建庫建表腳本)。

代碼片段和文件信息
import?java.sql.*;
import?javax.swing.table.*;
public?class?ConnectDB?
{
private?Connection?connection;
??? public?ConnectDB(String?driverString?urlString?userString?password)?throws?ClassNotFoundExceptionSQLException
{
???? this.connection=null;
???? Class.forName(driver);
???? this.connection=DriverManager.getConnection(urluserpassword);
????}
????public?void?finalize()?throws?SQLException
????{
???? connection.close();
????}
????public?int?dataUpdate(String?sql)?throws?SQLException
????{
???? Statement?statement=this.connection.createStatement();
???? int?result=statement.executeUpdate(sql);
???? statement.close();
???? return?result;
????}
????public?int?select(String?sqlDefaultTableModel?dtm)throws?SQLException
????{
???? Statement?statement=this.connection.createStatement();
???? ResultSet?resultset=statement.executeQuery(sql);
???? ResultSetmetaData?rsmd=resultset.getmetaData();
???? int?c=rsmd.getColumnCount();
???? int?r=0;
???? String?[]data=new?String[c];
???? while(resultset.next())
???? {
???? for(int?i=0;i ???? {
???? data[i]=resultset.getString(i+1);
???? if(data[i]!=null)
???? data[i]=data[i].trim();
???? }
???? dtm.addRow(data);
???? r++;
???? }
???? return?r;
????}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????1849??2008-12-23?16:57??ConnectDB.class
?????文件???????1274??2008-12-03?23:05??ConnectDB.java
?????文件??????24255??2008-12-23?16:57??PaperSystem.class
?????文件??????30646??2008-12-21?09:53??PaperSystem.java
?????文件???????4510??2011-01-02?23:40??題管理系統.sql
-----------?---------??----------?-----??----
????????????????62534????????????????????5
- 上一篇:PL0詞法分析器java實現
- 下一篇:JAVA面試重點話術張大大吐血整理.doc
評論
共有 條評論