資源簡介
1.完成一個小型的數據庫信息管理系統（或部分功能），并填寫工程作業報告；
2.高級語言使用java，后臺數據庫使用大型數據庫管理系統SQL Server
代碼片段和文件信息
package?student;
import?java.util.*;
import?java.sql.*;
import?javax.swing.*;
public?class?database?{
static?String?driverName?=?“com.microsoft.sqlserver.jdbc.SQLServerDriver“;
static?String?dbURL?=?“jdbc:sqlserver://localhost:1433;DatabaseName=student“;
static?String?userName?=?“sa“;?//?默認用戶名
static?String?userPwd?=?“lvyalei123“;?//?密碼
public?static?Connection?conn?=?null;
public?static?void?openDB（）?{
try?{
Class.forName（driverName）;
conn?=?DriverManager.getConnection（dbURL?userName?userPwd）;
if?（conn.isClosed（））?{
JOptionPane.showMessageDialog（null?“Database?is?closed!“?“Error“?JOptionPane.INFORMATION_MESSAGE）;
}
}?catch?（Exception?e）?{
e.printStackTrace（）;
}
}
public?static?void?insert（int?s1?String?s2?String?s3?String?s4?int?s5）?throws?SQLException?{
openDB（）;
try?{
String?sql?=?“insert?into?student?values（‘“?+?s1?+?“‘‘“?+?s2?+?“‘‘“?+?s3?+?“‘‘“?+?s4?+?“‘‘“?+?s5?+?“‘）“;
Statement?statement?=?conn.createStatement（）;
int?a?=?statement.executeUpdate（sql）;
if?（a?==?1）?{
JOptionPane.showMessageDialog（null?“插入成功“?“成功“?JOptionPane.INFORMATION_MESSAGE）;
}
}?catch?（Exception?e）?{
JOptionPane.showMessageDialog（null?“插入失敗“?“失敗“?JOptionPane.INFORMATION_MESSAGE）;
closeDB（）;
}
}
public?static?void?update（int?a1?String?a2int?a3）?throws?SQLException?{
openDB（）;
CallableStatement?callableStatement?=?conn.prepareCall（“{call?update_student?（???）}“）;
callableStatement.setInt（1?a1）;
callableStatement.setString（2?a2）;
callableStatement.setInt（3?a3）;
callableStatement.registerOutParameter（1?Types.INTEGER）;
callableStatement.registerOutParameter（2?Types.INTEGER）;
callableStatement.registerOutParameter（3?Types.INTEGER）;
int?a?=?callableStatement.executeUpdate（）;
if?（a?==?1）?{
JOptionPane.showMessageDialog（null?“更新成功“?“成功“?JOptionPane.INFORMATION_MESSAGE）;
}?else?{
JOptionPane.showMessageDialog（null?“更新失敗“?“失敗“?JOptionPane.INFORMATION_MESSAGE）;
}
closeDB（）;
}
public?static?void?delete（int?id）?throws?SQLException?{
openDB（）;
Statement?stmt?=?conn.createStatement（）;
try?{
conn.setAutoCommit（false）;
stmt?=?conn.createStatement（）;
int?a?=stmt.executeUpdate（“delete?from?score?where?student_id=‘“?+?id?+?“‘“）;
int?b?=stmt.executeUpdate（“delete?from?student?where?id=‘“?+?id?+?“‘“）;
conn.commit（）;//?提交JDBC事務
conn.setAutoCommit（true）;//?恢復JDBC事務的默認提交方式
if?（a!=0&&b!=0）?//刪除學生和成績
{
JOptionPane.showMessageDialog（null?“刪除成功“?“成功“?JOptionPane.INFORMATION_MESSAGE）;
}?
else//若學生不存在，刪除失敗
{
JOptionPane.showMessageDialog（null?“刪除失敗“?“失敗“?JOptionPane.INFORMATION_MESSAGE）;
}
stmt.close（）;
}?catch?（Exception?exc）?{
//若SQL語句執行異常，刪除失敗
JOptionPane.showMessageDialog（null?“刪除失敗“?“失敗“?JOptionPane.INFORMATION_MESSAGE）;
conn.rollback（）;//?回滾JDBC事務
exc.printStackTrace（）;
stmt.close（）;
}
}
p ?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????4112384??2018-05-28?15:15??數據庫工程作業\student.bak
?????文件???????23414??2018-05-28?15:24??數據庫工程作業\student.sql
?????目錄???????????0??2018-06-14?09:22??數據庫工程作業\student_java\
?????文件?????????355??2018-05-20?14:47??數據庫工程作業\student_java\.classpath
?????文件?????????383??2018-05-20?14:46??數據庫工程作業\student_java\.project
?????目錄???????????0??2018-06-14?09:22??數據庫工程作業\student_java\.settings\
?????文件?????????598??2018-05-20?14:46??數據庫工程作業\student_java\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2018-06-14?09:22??數據庫工程作業\student_java\bin\
?????目錄???????????0??2018-06-14?09:22??數據庫工程作業\student_java\bin\student\
?????文件????????3931??2018-05-25?19:46??數據庫工程作業\student_java\bin\student\databa
?????文件????????1205??2018-05-25?19:21??數據庫工程作業\student_java\bin\student\delete$deleteLisener.class
?????文件?????????685??2018-05-25?19:21??數據庫工程作業\student_java\bin\student\delete$returnLisener.class
?????文件????????5061??2018-05-25?19:21??數據庫工程作業\student_java\bin\student\delete.class
?????文件?????????717??2018-05-25?19:21??數據庫工程作業\student_java\bin\student\DeletePanel.class
?????文件????????2832??2018-05-25?20:51??數據庫工程作業\student_java\bin\student\find$findLisener.class
?????文件?????????673??2018-05-25?20:51??數據庫工程作業\student_java\bin\student\find$returnLisener.class
?????文件????????4210??2018-05-25?20:51??數據庫工程作業\student_java\bin\student\find.class
?????文件?????????711??2018-05-25?20:51??數據庫工程作業\student_java\bin\student\FindPanel.class
?????文件????????1836??2018-05-25?20:51??數據庫工程作業\student_java\bin\student\insert$insertLisener.class
?????文件?????????685??2018-05-25?20:51??數據庫工程作業\student_java\bin\student\insert$returnLisener.class
?????文件????????5243??2018-05-25?20:51??數據庫工程作業\student_java\bin\student\insert.class
?????文件?????????717??2018-05-25?20:51??數據庫工程作業\student_java\bin\student\InsertPanel.class
?????文件????????2253??2018-05-25?19:12??數據庫工程作業\student_java\bin\student\login$creatNewWindow.class
?????文件????????2306??2018-05-25?19:12??數據庫工程作業\student_java\bin\student\login.class
?????文件?????????714??2018-05-25?19:12??數據庫工程作業\student_java\bin\student\LoginPanel.class
?????文件?????????714??2018-05-25?19:02??數據庫工程作業\student_java\bin\student\MainPanel.class
?????文件?????????693??2018-05-25?19:02??數據庫工程作業\student_java\bin\student\mainwin$deleteListener.class
?????文件?????????685??2018-05-25?19:02??數據庫工程作業\student_java\bin\student\mainwin$findListener.class
?????文件?????????693??2018-05-25?19:02??數據庫工程作業\student_java\bin\student\mainwin$insertListener.class
?????文件?????????693??2018-05-25?19:02??數據庫工程作業\student_java\bin\student\mainwin$updateListener.class
?????文件????????1872??2018-05-25?19:02??數據庫工程作業\student_java\bin\student\mainwin.class
............此處省略29個文件信息
- 上一篇：JavaGUI+JDBC模擬ATM項目
- 下一篇：學生信息管理系統課程設計
評論
共有 條評論
川公網安備 51152502000135號