Java swing（2）自己設計完善的獨特功能圖書管理系統(tǒng)，獲取下拉框等的文字內容等
總框架：
本篇所含框架：
package denglu;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;
public class puTongYongHuJieMian extends JFrame {
class shijian_table implements MouseListener, ActionListener {
public puTongYongHuJieMian HanDengLuHouJieMianNeiRong = null;
public shijian_table(puTongYongHuJieMian dengLuHouJieMianNeiRong) {
this.HanDengLuHouJieMianNeiRong = dengLuHouJieMianNeiRong;
}
// HanDengLuHouJieMianNeiRong（含登錄后界面內容）
// DengLuHouJieMianNeiRong（登錄后界面內容）
// 把窗體等內容都賦值傳給HanDengLuHouJieMianNeiRong是為了方便下面如
// HanDengLuHouJieMianNeiRong.txt_name.getText();的“點（.）式引用,由“.”
// 后面的精確后綴條件提示等引用精確內容”
@Override
public void actionPerformed(ActionEvent arg0) {
String name = HanDengLuHouJieMianNeiRong.wenBenKuang_name.getText();
String price = HanDengLuHouJieMianNeiRong.wenBenKuang_price
.getText();
String type = HanDengLuHouJieMianNeiRong.wenBenKuang_typeid
.getText();
String jieshao = HanDengLuHouJieMianNeiRong.wenBenKuang_spjieshao
.getText();
// ArrayList<String> jiHe = new ArrayList<String>();
// // jiHe集合
//
// if (HanDengLuHouJieMianNeiRong.address1.isSelected()) {
// jiHe.add(HanDengLuHouJieMianNeiRong.address1.getText());
// }
// if (HanDengLuHouJieMianNeiRong.address2.isSelected()) {
// jiHe.add(HanDengLuHouJieMianNeiRong.address2.getText());
// }
// if (HanDengLuHouJieMianNeiRong.address3.isSelected()) {
// jiHe.add(HanDengLuHouJieMianNeiRong.address3.getText());
// }
// String typeName = HanDengLuHouJieMianNeiRong.xiaLaKuang
// .getSelectedItem().toString();
String sql = "insert into tushu values('" + name + "'" + ","
+ price + "," + type + ",'" + jieshao + "')";
// String sql2 = "insert into ts_type(ts_typename) values('"
// + typeName + "')";
// if (DBUtils.ZSG(sql) && DBUtils.ZSG(sql2)) {
if (DBUtils.ZSG(sql)) {
JOptionPane.showMessageDialog(null, "增加成功");
HanDengLuHouJieMianNeiRong.chaxunchushihua();
} else {
JOptionPane.showMessageDialog(null, "出現了未知的錯誤，增加失敗");
}
}
@Override
public void mouseClicked(MouseEvent arg0) {
if (arg0.getClickCount() == 2) {
int row = HanDengLuHouJieMianNeiRong.biaoGe1.getSelectedRow();
String leixing = HanDengLuHouJieMianNeiRong.biaoGe1.getValueAt(
row, 4).toString();
HanDengLuHouJieMianNeiRong.wenBenKuang_Bianhao
.setText(HanDengLuHouJieMianNeiRong.biaoGe1.getValueAt(
row, 0).toString());
HanDengLuHouJieMianNeiRong.wenBenKuang_name
.setText(HanDengLuHouJieMianNeiRong.biaoGe1.getValueAt(
row, 1).toString());
HanDengLuHouJieMianNeiRong.wenBenKuang_price
.setText(HanDengLuHouJieMianNeiRong.biaoGe1.getValueAt(
row, 2).toString());
HanDengLuHouJieMianNeiRong.wenBenKuang_typeid
.setText(HanDengLuHouJieMianNeiRong.biaoGe1.getValueAt(
row, 3).toString());
HanDengLuHouJieMianNeiRong.wenBenKuang_spjieshao
.setText(HanDengLuHouJieMianNeiRong.biaoGe1.getValueAt(
row, 5).toString());
HanDengLuHouJieMianNeiRong.wenBenKuang_typename
.setText(leixing);
// 給下拉框內容賦值:
for (int i = 0; i < HanDengLuHouJieMianNeiRong.xiaLaKuang
.getItemCount(); i++) {
if (HanDengLuHouJieMianNeiRong.xiaLaKuang.getItemAt(i)
.toString().equals(leixing)) {
HanDengLuHouJieMianNeiRong.xiaLaKuang
.setSelectedItem(leixing);
}
}
}
if (arg0.isMetaDown()) {
int num = JOptionPane.showConfirmDialog(null, "是否確認刪除這條信息?");
if (num == 0) {
int row = HanDengLuHouJieMianNeiRong.biaoGe1
.getSelectedRow();
String sql = "delete tushu where ts_id="
+ HanDengLuHouJieMianNeiRong.biaoGe1.getValueAt(
row, 0) + "";
if (DBUtils.ZSG(sql)) {
JOptionPane.showMessageDialog(null, "冊除成功");
HanDengLuHouJieMianNeiRong.chaxunchushihua();
// 刪除成功再查詢一遍表格就可以實現表格的刷新，但是我們的查詢寫在了構造方法里,內容很多，
// 這里想要使用又要在寫一遍，很麻煩，那么現在我們寫一個方法 將查詢內容封裝進去，再想查詢的
// 時候只要調用查詢的方法即可
} else {
JOptionPane.showMessageDialog(null, "出現了未知的錯誤，請重試");
}
}
}
}
@Override
public void mouseEntered(MouseEvent arg0) {
// TODO Auto-generated method stub
}
@Override
public void mouseExited(MouseEvent arg0) {
// TODO Auto-generated method stub
}
@Override
public void mousePressed(MouseEvent arg0) {
// TODO Auto-generated method stub
}
@Override
public void mouseReleased(MouseEvent arg0) {
// TODO Auto-generated method stub
}
}
static JButton anNiu_zengJia = null;
// gunDongTiao（滾動條）
static JTable biaoGe1 = null;
// xiaLaKuang（下拉框）
static DefaultTableModel biaoGeMoXing1 = null;
// biaoGeMoXing1（表格模型1）
static JScrollPane gunDongTiao = null;
// 集合（jiHe），標題（biaoti）
static Vector<Vector<Object>> Vector_jiHe_biaoGeNeiRong = null;
// wenBenKuang（文本框）
static Vector<Object> Vector_jiHe_biaoti = null;
// 文字（wenZi）
static JTextField wenBenKuang_Bianhao, wenBenKuang_name, wenBenKuang_price,
wenBenKuang_typeid, wenBenKuang_spjieshao, wenBenKuang_typename;
// biaoGe1（表格1）
static JLabel wenZi_Bianhao, wenZi_name, wenZi_price, wenZi_typeid,
wenZi_tjtypeName_xiaLaKuang, wenZi_spjieshao, wenZi_tjtypeName;
// anNiu_zengJia按鈕_增加
public static JComboBox xiaLaKuang = null;
// biaoGeNeiRong（表格內容）
JPanel mianBan1, mianBan2 = null;
// mianBan（面板）
public puTongYongHuJieMian() {
this.setTitle("普通用戶登錄后的界面");
this.setSize(800, 600);
this.setLayout(null);
this.setLocationRelativeTo(null);
wenZi_Bianhao = new JLabel("添加或查找編號");
wenZi_name = new JLabel("添加或查找名稱");
wenZi_price = new JLabel("添加或查找價格");
wenZi_tjtypeName = new JLabel("添加或查找類型名稱");
wenZi_tjtypeName_xiaLaKuang = new JLabel("查找類型名稱");
wenZi_typeid = new JLabel("添加或查找類型ID");
wenZi_spjieshao = new JLabel("添加或查找介紹");
anNiu_zengJia = new JButton("添加數據");
anNiu_zengJia.setBounds(530, 390, 100, 30);
anNiu_zengJia.addActionListener(new shijian_table(this));
this.add(anNiu_zengJia);
wenZi_Bianhao.setBounds(510, 100, 100, 30);
wenZi_name.setBounds(510, 140, 100, 30);
wenZi_price.setBounds(510, 180, 100, 30);
wenZi_typeid.setBounds(510, 220, 130, 30);
wenZi_spjieshao.setBounds(510, 260, 100, 30);
wenZi_tjtypeName.setBounds(510, 300, 170, 30);
wenZi_tjtypeName_xiaLaKuang.setBounds(510, 340, 170, 30);
this.add(wenZi_Bianhao);
this.add(wenZi_name);
this.add(wenZi_price);
this.add(wenZi_typeid);
this.add(wenZi_spjieshao);
this.add(wenZi_tjtypeName_xiaLaKuang);
this.add(wenZi_tjtypeName);
wenBenKuang_Bianhao = new JTextField();// 畫框框的界面
wenBenKuang_Bianhao.setEditable(false);
wenBenKuang_name = new JTextField();
wenBenKuang_price = new JTextField();
wenBenKuang_typeid = new JTextField();
wenBenKuang_spjieshao = new JTextField();
wenBenKuang_typename = new JTextField();
wenBenKuang_Bianhao.setBounds(640, 100, 130, 30);
wenBenKuang_name.setBounds(640, 140, 130, 30);
wenBenKuang_price.setBounds(640, 180, 130, 30);
wenBenKuang_typeid.setBounds(640, 220, 130, 30);
wenBenKuang_spjieshao.setBounds(640, 260, 130, 30);
wenBenKuang_typename.setBounds(640, 300, 130, 30);
this.add(wenBenKuang_Bianhao);
this.add(wenBenKuang_name);
this.add(wenBenKuang_price);
this.add(wenBenKuang_typeid);
this.add(wenBenKuang_spjieshao);
this.add(wenBenKuang_typename);
Vector_jiHe_biaoti = new Vector<Object>();
Vector_jiHe_biaoti.add("編號");
Vector_jiHe_biaoti.add("名稱");
Vector_jiHe_biaoti.add("價格");
Vector_jiHe_biaoti.add("類型ID");
Vector_jiHe_biaoti.add("類型名稱");
Vector_jiHe_biaoti.add("介紹");
String sql = "select * from tushu as a inner join ts_Type as"
+ " b on(a.ts_TypeID=b.ts_TypeID)";
ResultSet res = DBUtils.Select(sql);
try {
Vector_jiHe_biaoGeNeiRong = new Vector<Vector<Object>>();
while (res.next()) {
Vector<Object> v = new Vector<Object>();
v.add(res.getInt("ts_ID"));
v.add(res.getString("ts_Name"));
v.add(res.getDouble("ts_price"));
v.add(res.getInt("ts_TypeID"));
v.add(res.getString("ts_TypeName"));
v.add(res.getString("ts_Jieshao"));
Vector_jiHe_biaoGeNeiRong.add(v);
biaoGeMoXing1 = new DefaultTableModel(
Vector_jiHe_biaoGeNeiRong, Vector_jiHe_biaoti);
}
biaoGeMoXing1 = new DefaultTableModel(Vector_jiHe_biaoGeNeiRong,
Vector_jiHe_biaoti) {
@Override
public boolean isCellEditable(int a, int b) {
return false;
}
};
biaoGe1 = new JTable(biaoGeMoXing1);
biaoGe1.addMouseListener(new shijian_table(this));
biaoGe1.setBounds(0, 0, 400, 500);
gunDongTiao = new JScrollPane(biaoGe1);
gunDongTiao.setBounds(0, 0, 450, 150);
mianBan1 = new JPanel();/*
* JPanel1 = new JPanel(); 不可在gundong = new
* JScrollPane(JTable1);上面
*/
mianBan1.add(gunDongTiao);
// 加this.add(gundong);刪mianBan1.add(gunDongTiao );會有直接的滾動條，但變只可刪一次
mianBan1.setBounds(0, 0, 450, 250);
this.add(mianBan1);
} catch (SQLException e) {
e.printStackTrace();
}
shangPinLeiXingXiaLaKuang();
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setVisible(true);
// 這里引用chaxunchushihua();沒作用
}
// public void XXX() 格式就是封裝查詢的方法，可調用，無加靜態(tài)屬性的單詞
public void chaxunchushihua() {
// 判斷JPanel是不是為空
if (this.mianBan1 != null) {
// 面板1不為空說明面板1中有內容，就把面板1內容用從this中用remove移除，下面再加新內容
this.remove(mianBan1);
}
Vector_jiHe_biaoti = new Vector<Object>();
Vector_jiHe_biaoti.add("編號");
Vector_jiHe_biaoti.add("名稱");
Vector_jiHe_biaoti.add("價格");
Vector_jiHe_biaoti.add("類型ID");
Vector_jiHe_biaoti.add("類型名稱");
Vector_jiHe_biaoti.add("介紹");
String sql = "select * from tushu as a inner join ts_Type as"
+ " b on(a.ts_TypeID=b.ts_TypeID)";
ResultSet res = DBUtils.Select(sql);
try {
Vector_jiHe_biaoGeNeiRong = new Vector<Vector<Object>>();
while (res.next()) {
Vector<Object> v = new Vector<Object>();
v.add(res.getInt("ts_ID"));
v.add(res.getString("ts_Name"));
v.add(res.getDouble("ts_price"));
v.add(res.getInt("ts_TypeID"));
v.add(res.getString("ts_TypeName"));
v.add(res.getString("ts_Jieshao"));
Vector_jiHe_biaoGeNeiRong.add(v);
biaoGeMoXing1 = new DefaultTableModel(
Vector_jiHe_biaoGeNeiRong, Vector_jiHe_biaoti);
}
biaoGeMoXing1 = new DefaultTableModel(Vector_jiHe_biaoGeNeiRong,
Vector_jiHe_biaoti) {
@Override
public boolean isCellEditable(int a, int b) {
return false;
}
};
biaoGe1 = new JTable(biaoGeMoXing1);
// XXX.addMouseListener(new XXX(this));為給表格添加鼠標點擊事件的格式，多總結和記錄格式等法
biaoGe1.addMouseListener(new shijian_table(this));
gunDongTiao = new JScrollPane(biaoGe1);
gunDongTiao.setBounds(0, 0, 450, 150);
mianBan1 = new JPanel();
mianBan1.add(gunDongTiao);
mianBan1.setBounds(0, 0, 450, 250);
this.add(mianBan1);
} catch (SQLException e) {
e.printStackTrace();
}
// 釋放資源:this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setVisible(true);
}
// shangPinLeiXingXiaLaKuang（商品類型下拉框）
public void shangPinLeiXingXiaLaKuang() {
String sql = "select * from ts_type";
ResultSet res = DBUtils.Select(sql);
xiaLaKuang = new JComboBox();
try {
while (res.next()) {
// com1. setSelectedIndex(Integer.parseInt(res. getObject(1).
// toString()));
xiaLaKuang.addItem(res.getObject(2).toString());
// xiaLaKuang.addItem(res.getObject(1).toString());
}
} catch (SQLException e) {
e.printStackTrace();
}
xiaLaKuang.setBounds(640, 340, 130, 30);
this.add(xiaLaKuang);
}
}
package denglu;
import java.awt.Color;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.FocusEvent;
import java.awt.event.FocusListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
class shijian_zhmm implements FocusListener, ActionListener {
public zhaoHuiMiMa shijian_zhaoHuiMiMa1 = null;
public shijian_zhmm(zhaoHuiMiMa shijian_zhaoHuiMiMa2) {
this.shijian_zhaoHuiMiMa1 = shijian_zhaoHuiMiMa2;
}
@Override
public void actionPerformed(ActionEvent arg0) {
String String_uname = shijian_zhaoHuiMiMa1.txt_uname.getText().trim();
String String_wenti = shijian_zhaoHuiMiMa1.txt_wenti.getText().trim();
String String_daan = shijian_zhaoHuiMiMa1.txt_daan.getText().trim();
String sql = "select * from yonghu where yh_Uname='" + String_uname
+ "'and yh_Q='" + String_wenti + "'and yh_A='" + String_daan
+ "'";
ResultSet res = DBUtils.Select(sql);
try {
if (res.next()) {
new chongzhimimajiemian();
gongjvClass.uname = String_uname;
} else {
// JOptionPane.showMessageDialog（null,"XXX"）是用來提示用戶答案輸入錯誤的格式
JOptionPane.showMessageDialog(null, "答案輸入錯誤");
shijian_zhaoHuiMiMa1.lb_daan1.setText("答案輸入錯誤");
shijian_zhaoHuiMiMa1.lb_daan1.setForeground(Color.red);
}
} catch (SQLException e) {
e.printStackTrace();
}
}
@Override
public void focusGained(FocusEvent arg0) {
// focusGained(FocusEvent arg0)是 失去焦點事件的格式
}
@Override
public void focusLost(FocusEvent arg0) {
String uname = shijian_zhaoHuiMiMa1.txt_uname.getText().trim();
String sql = "select * from yonghu where yh_uname='" + uname + "'";
ResultSet res = DBUtils.Select(sql);
try {
if (res.next()) {
String shiJian_wenti = res.getString("yh_Q");
shijian_zhaoHuiMiMa1.txt_wenti.setText(shiJian_wenti);
shijian_zhaoHuiMiMa1.lb_uname1.setText("");
} else {
shijian_zhaoHuiMiMa1.lb_uname1.setText("用戶名錯誤");
shijian_zhaoHuiMiMa1.lb_uname1.setForeground(Color.red);
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public class zhaoHuiMiMa extends JFrame {
static JButton btn_queren, btn_quxiao = null;
static JLabel lb_uname, lb_wenti, lb_daan = null;
static JLabel lb_uname1, lb_wenti1, lb_daan1 = null;
/*
* 找回密碼思路:1.寫一個文本框用來填用戶名，用戶名需要添加焦點獲取事件，如果失去焦點后去數據庫查詢用戶輸入
* 的用戶名是否存在，如果存在就將其問題查詢出來,添加到第二 個文本框上(第二個文本框是不能手動輸
* 入的),讓用戶輸入答案，輸入完畢后點擊確定按鈕時判斷用戶名，問題和答案是否一致， 如果一致說明 用戶輸入的答案是正確的， 之后跳到重置密碼界面
*/
static JTextField txt_uname, txt_wenti, txt_daan = null;
public zhaoHuiMiMa() {
// 基本必須的內容：布局方式、大小居中、釋放資源(找回密碼頁面不需要釋放資源)、顯示
// 布局方式
this.setTitle("找回密碼頁面");
this.setLayout(null);
// 大小居中
this.setSize(500, 500);
this.setLocationRelativeTo(null);
lb_uname = new JLabel("用戶名");
lb_wenti = new JLabel("問題");
lb_daan = new JLabel("答案");
lb_uname1 = new JLabel("請輸入用戶名");
lb_daan1 = new JLabel("請輸入答案");
txt_uname = new JTextField();
txt_wenti = new JTextField();
txt_daan = new JTextField();
txt_uname.addFocusListener(new shijian_zhmm(this));
lb_uname1.setForeground(Color.blue);
lb_daan1.setForeground(Color.blue);
lb_uname.setBounds(100, 100, 100, 30);
lb_wenti.setBounds(100, 140, 100, 30);
lb_daan.setBounds(100, 180, 100, 30);
lb_uname1.setBounds(310, 105, 100, 30);
lb_daan1.setBounds(310, 185, 100, 30);
this.add(lb_uname);
this.add(lb_wenti);
this.add(lb_daan);
this.add(lb_uname1);
this.add(lb_daan1);
txt_uname.setBounds(210, 100, 100, 30);
txt_wenti.setBounds(210, 140, 100, 30);
txt_wenti.setEditable(false);
txt_daan.setBounds(210, 180, 100, 30);
this.add(txt_uname);
this.add(txt_wenti);
this.add(txt_daan);
btn_queren = new JButton("確認且回答正確后跳轉重置密碼頁面");
btn_queren.addActionListener(new shijian_zhmm(this));
btn_quxiao = new JButton("取消");
btn_queren.setBounds(10, 230, 290, 30);
btn_quxiao.setBounds(340, 230, 70, 30);
this.add(btn_queren);
this.add(btn_quxiao);
// 顯示
this.setVisible(true);
}
}
