-
大小: 4.45MB文件類型: .rar金幣: 2下載: 0 次發(fā)布日期: 2023-09-27
- 語言: Java
- 標簽: 數(shù)據(jù)庫??
資源簡介
本人自己做了兩個星期的數(shù)據(jù)課程設計。壓縮包里含有商品管理系統(tǒng)java工程(Eclipse)、商品庫存數(shù)據(jù)庫7個基本表和1張記錄表、一篇5000字的課程設計報告和一篇短小的說明。

代碼片段和文件信息
import?java.awt.Dimension;
import?java.awt.Font;
import?java.awt.Toolkit;
import?java.awt.event.ActionEvent;
import?java.awt.event.ActionListener;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.SQLException;
import?javax.swing.JButton;
import?javax.swing.Jframe;
import?javax.swing.JLabel;
import?javax.swing.JOptionPane;
import?javax.swing.JTextField;
public?class?ChangePassword?extends?Jframe?implements?ActionListener?{
String?name;//?登陸的用戶名
JLabel?label_1?=?new?JLabel(“修改密碼“);
JLabel?label_2?=?new?JLabel(“新?密?碼:“);
JLabel?label_3?=?new?JLabel(“密碼確認:“);
JTextField?textField_1?=?new?JTextField();
JTextField?textField_2?=?new?JTextField();
JButton?button_ok?=?new?JButton(“確認“);
JButton?button_cancel?=?new?JButton(“取消“);
Font?font_2?=?new?Font(“Monospaced“?Font.BOLD?19);
Connection?conn;
Jframe?frame;
public?ChangePassword(String?name)?{
conn?=?new?ConnectionDB().getConnection();
frame?=?new?Jframe(“修改密碼“);
frame.setIconImage(frame.getToolkit().getImage(“java.png“));
Dimension?dimension?=?Toolkit.getDefaultToolkit().getScreenSize();//?獲取屏幕大小
int?width?=?400;//?窗口寬度
int?height?=?300;
frame.setLayout(null);
label_1.setBounds(140?20?120?50);
label_1.setFont(font_2);
label_2.setBounds(90?100?100?30);
label_3.setBounds(90?160?100?30);
textField_1.setBounds(160?100?150?30);
textField_2.setBounds(160?160?150?30);
button_ok.setBounds(80?230?80?30);
button_cancel.setBounds(240?230?80?30);
frame.add(label_1);
frame.add(label_2);
frame.add(label_3);
frame.add(textField_1);
frame.add(textField_2);
frame.add(button_ok);
button_ok.addActionListener(this);
frame.add(button_cancel);
button_cancel.addActionListener(this);
frame.setBounds((dimension.width?-?width)?/?2?(dimension.height?-?height)?/?2?width?height);//?窗口居中
frame.setVisible(true);
frame.setResizable(false);
}
@Override
public?void?actionPerformed(ActionEvent?e)?{
//?TODO?Auto-generated?method?stub
int?i?=?1;
if?(e.getSource()?==?button_ok)?{
String?sql?=?null;
if?(textField_1.getText().length()?!=?0?&&?textField_2.getText().length()?!=?0)?{
if(textField_1.getText().trim().equals(textField_2.getText().trim())){
sql?=?“update?登陸?set?密碼=‘“?+?textField_1.getText()?+?“‘where?用戶名=‘“?+?name?+?“‘“;
}
else{
JOptionPane.showMessageDialog(null?“兩次密碼不一樣!!“?“警告“?JOptionPane.ERROR_MESSAGE);
return?;
}
}?else?{
JOptionPane.showMessageDialog(null?“密碼不能為空!“?“警告“?JOptionPane.ERROR_MESSAGE);
return?;
}
PreparedStatement?pstmt;
try?{
pstmt?=?(PreparedStatement)?conn.prepareStatement(sql);
i?=?pstmt.executeUpdate();
pstmt.close();
//?conn.close();
}?catch?(SQLException?e3)?{
e3.printStackTrace();
}
frame.dispose();
JOptionPane.showMessageDialog(null?“密碼修改成功!“?“提示“?JOptionPane.PLAIN_MESSAGE);
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件????????412??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\.classpath
?????文件????????395??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\.project
?????文件????????598??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\.settings\org.eclipse.jdt.core.prefs
?????文件??????33990??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\1.jpg
?????文件????1889334??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\11.bmp
?????文件?????321991??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\11.png
?????文件?????320323??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\22.png
?????文件???????3961??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\ChangePassword.class
?????文件???????7631??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\CommodityInfo.class
?????文件???????1290??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\ConnectionDB.class
?????文件???????4566??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\InventoryAndStorage.class
?????文件???????8388??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\InventoryInfo.class
?????文件????????949??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\LogIn$1.class
?????文件???????6145??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\LogIn.class
?????文件??????27167??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\LogIn.jpg
?????文件???????1265??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\Main.class
?????文件???????4567??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\MainShow.class
?????文件???????5419??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\MyEvent.class
?????文件???????1630??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\MyMenuPanel.class
?????文件???????2597??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\MyStatement.class
?????文件???????9111??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\PutInStorage.class
?????文件???????8619??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\PutOutStorage.class
?????文件???????2222??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\ShowTableData.class
?????文件???????2530??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\Statistics.class
?????文件???????3941??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\Statistics_commodity_info.class
?????文件???????4049??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\Statistics_in_storage.class
?????文件???????4052??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\Statistics_out_storage.class
?????文件???????6537??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\StoreInfo.class
?????文件???????7170??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\Supplier.class
?????文件???????7288??2015-10-10?11:52??商品庫存管理系統(tǒng)\InventoryManagement\bin\UserManagement.class
............此處省略39個文件信息
評論
共有 條評論