資源簡介
數據庫課程設計,java+sqlserver實現c/s系統下的企業庫存管理子系統。

代碼片段和文件信息
import?java.awt.*;
import?java.sql.*;
import?java.awt.event.*;
import?javax.swing.*;
public?class?AddCargo?extends?Jframe{
private?JTextField?CnameCTypeCNum;
private?JButton?SaveCancel;
public?AddCargo(final?int?IdUserfinal?String?l){
super(“貨物信息“);
Container?con?=?getContentPane();
con.setLayout(new?FlowLayout());
Box?CnameBox?=?Box.createHorizontalBox();
Box?CTypeBox?=?Box.createHorizontalBox();
Box?CNumBox?=?Box.createHorizontalBox();
Box?ButtonBox?=?Box.createHorizontalBox();
Box?VertBox?=?Box.createVerticalBox();
VertBox.add(Box.createVerticalStrut(50));
Cname?=?new?JTextField(10);
CnameBox.add(new?JLabel(“貨物名:“));
CnameBox.add(Cname);
CnameBox.add(Box.createHorizontalStrut(10));
VertBox.add(CnameBox);
VertBox.add(Box.createVerticalStrut(50));
CType?=?new?JTextField(20);
CTypeBox.add(new?JLabel(“貨物種類:“));
CTypeBox.add(CType);
VertBox.add(CTypeBox);
VertBox.add(Box.createVerticalStrut(50));
CNum?=?new?JTextField(20);
CNumBox.add(new?JLabel(“貨物數量:“));
CNumBox.add(CNum);
VertBox.add(CNumBox);
VertBox.add(Box.createVerticalStrut(50));
Save?=?new?JButton(“確認“);
Cancel?=?new?JButton(“取消“);
ButtonBox.add(Save);
ButtonBox.add(Box.createHorizontalStrut(15));
ButtonBox.add(Cancel);
VertBox.add(ButtonBox);
con.add(VertBox);
Save.addActionListener(
new?ActionListener(){
@Override
public?void?actionPerformed(ActionEvent?e)?{
//?TODO?Auto-generated?method?stub
file?F;
F?=?new?file();
String?c?=?F.readFileByLines(“config.txt“);
String?cmd[];
cmd?=?c.split(“\““);
String?driverName?=?cmd[1];
String?dbURL?=?cmd[3];
String?userName?=?cmd[5];
String?userPwd?=?cmd[7];
try
{
Class.forName(driverName);
Connection?dbConn=DriverManager.getConnection(dbURLuserNameuserPwd);
Statement?stm?=?dbConn.createStatement();
ResultSet?rs?=?stm.executeQuery(“select?*?from?Cargo“);
Integer?Re?=?null;
String?Res[];
while(rs.next())
{
Res?=?rs.getString(1).split(“?“);
Re?=?Re.parseInt(Res[0]);
}
Re?+=?1;
Integer?count?=?null;
int?count1;
count1?=?count.parseInt(CNum.getText());
rs.close();
stm.execute(
“insert?into?Cargo?values?(“?+?
“‘“?+?Re.toString()?+?“‘“?+
“‘“?+?Cname.getText()?+?“‘“?+
“‘“?+?CType.getText()?+?“‘“?+
CNum.getText()?+?“)“
);
JOptionPane.showMessageDialog(AddCargo.this“注冊成功貨號為:“?+?Re.toString());
dispose();
Menu?M?=?new?Menu(IdUserl);
M.setDefaultCloseOperation(Jframe.EXIT_ON_CLOSE);
}
catch(Exception?e1)
{
e1.printStac
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????4259840??2016-06-30?08:24??WarehouseManager.mdf
?????文件?????1064960??2016-06-30?08:24??WarehouseManager_log.ldf
?????目錄???????????0??2018-07-04?10:52??課程設計\
?????文件?????????427??2016-06-22?09:40??課程設計\.classpath
?????文件?????????388??2016-06-22?09:29??課程設計\.project
?????目錄???????????0??2018-07-04?10:52??課程設計\.settings\
?????文件?????????629??2016-06-22?09:29??課程設計\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2018-07-04?10:52??課程設計\bin\
?????文件????????3319??2016-06-28?08:52??課程設計\bin\AddCargo$1.class
?????文件?????????865??2016-06-28?08:52??課程設計\bin\AddCargo$2.class
?????文件????????2321??2016-06-28?08:52??課程設計\bin\AddCargo.class
?????文件????????3963??2016-06-28?08:52??課程設計\bin\AddUser$1.class
?????文件?????????975??2016-06-28?08:52??課程設計\bin\AddUser$2.class
?????文件????????3321??2016-06-28?08:52??課程設計\bin\AddUser.class
?????文件????????2878??2016-06-28?08:53??課程設計\bin\AlterCargo$1.class
?????文件?????????878??2016-06-28?08:53??課程設計\bin\AlterCargo$2.class
?????文件????????3926??2016-06-28?08:53??課程設計\bin\AlterCargo.class
?????文件????????2777??2016-06-28?08:53??課程設計\bin\DeleteCargo$1.class
?????文件?????????884??2016-06-28?08:53??課程設計\bin\DeleteCargo$2.class
?????文件????????3852??2016-06-28?08:53??課程設計\bin\DeleteCargo.class
?????文件????????2745??2016-06-28?08:53??課程設計\bin\DeleteUser$1.class
?????文件?????????878??2016-06-28?08:53??課程設計\bin\DeleteUser$2.class
?????文件????????4258??2016-06-28?08:53??課程設計\bin\DeleteUser.class
?????文件????????1461??2016-06-27?09:26??課程設計\bin\file.class
?????文件????????3914??2016-06-28?11:21??課程設計\bin\In_Out$1.class
?????文件?????????884??2016-06-28?11:21??課程設計\bin\In_Out$2.class
?????文件????????5520??2016-06-28?11:21??課程設計\bin\In_Out.class
?????文件????????3028??2016-06-28?08:53??課程設計\bin\Login$1.class
?????文件?????????774??2016-06-28?08:53??課程設計\bin\Login$2.class
?????文件?????????618??2016-06-28?08:53??課程設計\bin\Login$3.class
?????文件????????1922??2016-06-28?08:53??課程設計\bin\Login.class
............此處省略57個文件信息
評論
共有 條評論