圖書(shū)管理系統(tǒng)完整修改版（簡(jiǎn)易僅參考非個(gè)人中最好版）
SQL部分：
select ts_shuliang,jnum from tushu t join jieyue j on t.ts_id=j.ts_id where j.ts_id='1'
j.ts_id='1'和j.ts_id=1等價(jià)
select * from jieyue a inner join yonghu b on a.yh_id=b.yh_id inner join tushu c on a.ts_id=c.ts_id where yh_uname='1';
select ts_shuliang,jnum from tushu t join jieyue j on t.ts_id=j.ts_id where j.ts_id='1'
j.ts_id='1'和j.ts_id=1等價(jià)
select *from yonghu
drop table yonghu
create table yonghu(
? yh_ID int primary key identity(1,1),
? yh_Uname varchar(30) not null,
? yh_Pwd varchar(30) not null,
? yh_Name varchar(30) not null,
? yh_Age int,
? yh_Sex varchar(20),
? yh_Phone varchar(100),
? yh_Address varchar(200),
? yh_jieshao varchar(500),
? ?yh_Q varchar(500),
? ? yh_A varchar(500),
yh_type nvarchar(20) check(yh_type='普通用戶(hù)' or yh_type='管理員用戶(hù)'),
);
select * from yh_type
drop table yh_type
create table yh_Type(
yh_typeid int primary key identity(1,1),
yh_typename varchar(100) not null
);
insert into? yh_Type values('普通用戶(hù)');
insert into? yh_Type values('管理員用戶(hù)');
insert into yonghu values('1','11','詩(shī)書(shū)畫(huà)唱1',21,'男','19999999999','江西','陽(yáng)光帥氣的男孩子','你愛(ài)好多嗎？','多','普通用戶(hù)');
insert into yonghu values('2','22','詩(shī)書(shū)畫(huà)唱2',22,'男','29999999999','北京','陽(yáng)光帥氣的男孩子','你看過(guò)的書(shū)多嗎？','多','普通用戶(hù)');
insert into yonghu values('3','33','詩(shī)書(shū)畫(huà)唱3',23,'男','39999999999','上海','陽(yáng)光帥氣的男孩子','你會(huì)的技能多嗎？','多','普通用戶(hù)');
insert into yonghu values('4','44','詩(shī)書(shū)畫(huà)唱4',24,'男','49999999999','湖南','陽(yáng)光帥氣的男孩子','你喜歡的動(dòng)漫嗎？','多','普通用戶(hù)');
insert into yonghu values('5','55','詩(shī)書(shū)畫(huà)唱5',25,'男','59999999999','浙江','陽(yáng)光帥氣的男孩子','你喜歡的歌曲多嗎？','多','管理員用戶(hù)');
drop table ts_Type
create table ts_Type(
ts_leixingid int primary key identity(1,1),
ts_leixing varchar(100) not null
);
insert into ts_Type values('奇幻');
insert into ts_Type values('愛(ài)情');
insert into ts_Type values('日常');
insert into ts_Type values('科普');
drop table tushu
create table tushu(
? ts_ID int primary key identity(1,1),
? ts_Name varchar(100) not null,
? ts_shuliang? int,
--ts_leixing varchar(100) not null,
? ts_chubanshe varchar(300),
? ts_leixingid int
);
--insert into tushu values('《奧秘》',12,'奇幻','人民出版社',1);
--insert into tushu values('《愛(ài)你》',2,'愛(ài)情','人民出版社',2);
--insert into tushu values('《詩(shī)書(shū)》',4,'日常','人民出版社',3);
--insert into tushu values('《科普》',3,'科普','人民出版社',4);
insert into tushu values('《奧秘》',12,'人民出版社',1);
insert into tushu values('《愛(ài)你》',2,'人民出版社',2);
insert into tushu values('《詩(shī)書(shū)》',4,'人民出版社',3);
insert into tushu values('《科普》',3,'人民出版社',4);
drop table yonghu, tushu,dingdanxiangqing,ts_Type
drop table tushu
select * from yonghu
select * from yonghu where yh_name='1' and yh_pwd='1' and yh_type='管理員用戶(hù)'
select * from tushu
select * from ts_Type
select * from dingdan,dingdanxiangqing
select * from dingdanxiangqing
drop table dingdan
create table dingdan(
? dingdan_ID int primary key identity(1,1),
? yh_ID int,
? dingdanxiangqing_ID int
)
insert into dingdan values(1,1);
insert into dingdan values(1,2);
insert into dingdan values(1,3);
insert into dingdan values(2,4);
insert into dingdan values(2,5);
insert into dingdan values(2,6);
insert into dingdan values(3,7);
create table dingdanxiangqing(
? dingdanxiangqing_ID int primary key identity(1,1),
? sp_ID int,
? sp_num int
)
insert into dingdanxiangqing values(1,3);
insert into dingdanxiangqing values(2,4);
insert into dingdanxiangqing values(1,5);
insert into dingdanxiangqing values(3,5);
insert into dingdanxiangqing values(4,2);
insert into dingdanxiangqing values(5,1);
insert into dingdanxiangqing values(3,3);
insert into dingdanxiangqing values(4,3);
select * from yonghu;
select * from shangpin;
select * from sp_Type;
drop table jieyue
create table jieyue(
jid int primary key identity(1,1),
jnum int,
jday int,
yh_id int,
ts_id int
--ALTER TABLE 表名1 add constraint 自己取的約束名 foreign key（字段) references 表名2（字段）?
)
insert into jieyue values(3,3,1,1)
insert into jieyue values(2,2,2,2)
insert into jieyue values(4,5,3,3)
insert into jieyue values(5,1,1,4)
--alter table tushu add constraint tushuAndts_type foreign key(yh_leixing) references typetushu (ts_leixing)
--alter table jieyue add constraint jieyueAndyonghu foreign key (yh_id) references users(yh_id)
--alter table jieyue add constraint jieyueAndtushu foreign key(tid) references tushu
select * from tushu a inner join ts_type b on a.ts_leixingid=b.ts_leixingid
select * from ts_type
select * from jieyue a inner join yonghu b on a.yh_id=b.yh_id inner join tushu c on a.ts_id=c.ts_id
select * from jieyue a inner join yonghu b on a.yh_id=b.yh_id inner join tushu c on a.ts_id=c.ts_id
update? yonghu set yh_type='管理員用戶(hù)' where yh_id<4
Java部分：
package denglu;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPasswordField;
public class chongzhimimajiemian extends JFrame {
static JButton JButton_QuRen = null;
static JLabel JLabel1, JLabel2 = null;
static JPasswordField JPasswordField_qslmm1, JPasswordField_qslmm2 = null;
public chongzhimimajiemian() {
this.setLayout(null);
this.setTitle("重置密碼頁(yè)面");
this.setSize(500, 500);
this.setLocationRelativeTo(null);
this.setVisible(true);
JLabel1 = new JLabel("請(qǐng)輸入密碼");
JLabel2 = new JLabel("請(qǐng)?jiān)俅屋斎朊艽a");
JLabel1.setBounds(100, 100, 100, 30);
this.add(JLabel1);
JLabel2 = new JLabel("請(qǐng)?jiān)俅屋斎朊艽a");
JLabel2.setBounds(100, 140, 100, 30);
this.add(JLabel2);
JButton_QuRen = new JButton("確認(rèn)修改");
JButton_QuRen.setBounds(100, 290, 150, 30);
this.add(JButton_QuRen);
JButton_QuRen.addActionListener(new shijian_queRenXiuGai(this));
JPasswordField_qslmm1 = new JPasswordField();
JPasswordField_qslmm2 = new JPasswordField();
JPasswordField_qslmm1.setBounds(280, 100, 100, 30);
JPasswordField_qslmm2.setBounds(280, 140, 100, 30);
this.add(JPasswordField_qslmm1);
this.add(JPasswordField_qslmm2);
}
}
class shijian_queRenXiuGai implements ActionListener {
static chongzhimimajiemian chuangKou = null;
public shijian_queRenXiuGai(chongzhimimajiemian chuanzhi) {
this.chuangKou = chuanzhi;
}
@Override
public void actionPerformed(ActionEvent arg0) {
if (arg0.getActionCommand().equals("確認(rèn)修改")) {
JOptionPane.showMessageDialog(null, "點(diǎn)擊了修改密碼按鈕");
String pwd1 = chuangKou.JPasswordField_qslmm1.getText();
String pwd2 = chuangKou.JPasswordField_qslmm2.getText();
if (pwd1.equals(pwd2)) {
String uname = gongjvClass.uname;
String sql = "update yonghu set yh_pwd='" + pwd1
+ "' where yh_uname= '" + uname + "'";
if (DBUtils.ZSG(sql)) {
JOptionPane.showMessageDialog(null, "密碼重置成功");
} else {
JOptionPane.showMessageDialog(null, "出現(xiàn)了未知的錯(cuò)誤，請(qǐng)重試!");
}
} else {
JOptionPane.showMessageDialog(null, "兩次密碼輸入不一致");
return;
}
}
}
}
package denglu;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBUtils {
private static Connection con = null;
private static ResultSet res = null;
private static Statement sta = null;
static {
try {
Class.forName("com.microsoft.sqlserver." + "jdbc.SQLServerDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getCon() {
if (con == null) {
try {
con = DriverManager.getConnection(
"jdbc:sqlserver://DESKTOP-49FTFSP;"
+ "databaseName=yonghu", "sa", "1234abcd");
} catch (SQLException e) {
e.printStackTrace();
}
}
return con;
}
public static ResultSet Select(String sql) {
con = getCon();
try {
sta = con.createStatement();
res = sta.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return res;
}
public static boolean ZSG(String sql) {
boolean b = false;
con = getCon();
try {
sta = con.createStatement();
int num = sta.executeUpdate(sql);
if (num > 0) {
b = true;
}
} catch (SQLException e) {
e.printStackTrace();
}
return b;
}
}
package denglu;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.ImageIcon;
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.JPasswordField;
import javax.swing.JTextField;
public class denglu extends JFrame {
public static JButton JButton_dl, JButton_qx, JButton_zc,
JButton_zhmm, JButton_gly = null;
static JComboBox JComboBox_type = null;
public static JLabel JLabel_uname, JLabel_pwd, lb_img,
JLabel_yh_type = null;
public static JPasswordField JPasswordField_pwd1 = null;
public static JTextField JTextField_unametxt1 = null;
public JPanel JPanel1 = null;
public denglu() {
this.setLayout(null);
this.setSize(640, 400);
this.setLocationRelativeTo(null);
JLabel_uname = new JLabel("用戶(hù)名");
JLabel_pwd = new JLabel("密碼");
JLabel_yh_type = new JLabel("用戶(hù)類(lèi)型");
JComboBox_type = new JComboBox();
JComboBox_type.addItem("普通用戶(hù)");
JComboBox_type.addItem("管理員用戶(hù)");
JComboBox_type.setBounds(180, 180, 140, 30);
JLabel_yh_type.setBounds(110, 180, 70, 30);
this.add(JComboBox_type);
this.add(JLabel_yh_type);
JLabel_uname.setBounds(110, 100, 70, 30);
JLabel_pwd.setBounds(110, 140, 70, 30);
// 圖片
lb_img = new JLabel();
lb_img.setBounds(30, 0, 580, 100);
lb_img.setIcon(new ImageIcon("img//beijing.gif"));
JPanel1 = new JPanel();
JPanel1.setLayout(null);
JPanel1.setBounds(30, 0, 580, 100);
JPanel1.add(lb_img);
this.add(JPanel1);
this.add(JLabel_uname);
this.add(JLabel_pwd);
// JTextField_unametxt1 = new JTextField("1");//寫(xiě)死
JTextField_unametxt1 = new JTextField();// 沒(méi)寫(xiě)死
JPasswordField_pwd1 = new JPasswordField();
JTextField_unametxt1.setBounds(180, 100, 140, 30);
JPasswordField_pwd1.setBounds(180, 140, 140, 30);
this.add(JTextField_unametxt1);
this.add(JPasswordField_pwd1);
JButton_dl = new JButton("登錄");
JButton_dl.setBounds(60, 220, 100, 35);
JButton_dl.addActionListener(new shijian_denglu(this));
JButton_qx = new JButton("取消");
JButton_qx.setBounds(450, 220, 70, 35);
JButton_qx.addActionListener(new shijian_denglu(this));
JButton_zc = new JButton("普通用戶(hù)注冊(cè)");
JButton_zc.setBounds(190, 220, 120, 35);
JButton_zc.addActionListener(new shijian_denglu(this));
JButton_zhmm = new JButton("找回密碼");
JButton_zhmm.setBounds(330, 220, 90, 35);
JButton_zhmm.addActionListener(new shijian_denglu(this));
this.add(JButton_zc);
this.add(JButton_dl);
this.add(JButton_qx);
this.add(JButton_zhmm);
this.setVisible(true);
}
}
class shijian_denglu implements ActionListener {
public denglu d = null;
public shijian_denglu(denglu d) {
this.d = d;
}
@Override
public void actionPerformed(ActionEvent arg0) {
String uname = d.JTextField_unametxt1.getText().trim();
String pwd = d.JPasswordField_pwd1.getText().trim();// 獲取密碼
String type = d.JComboBox_type.getSelectedItem().toString();
if (arg0.getActionCommand().equals("登錄")) {
if (type.equals("管理員用戶(hù)")) {
String sql = "select * from yonghu where yh_uname='" + uname
+ "' and yh_pwd='" + pwd + "' and yh_type='" + type
+ "'";
System.out.println(sql);
ResultSet res = DBUtils.Select(sql);
try {
if (res.next()) {
new dengLuHouJieMian(uname);
d.setVisible(false);
} else {
JOptionPane.showMessageDialog(null,
"用戶(hù)名或密碼錯(cuò)誤或你不是管理員用戶(hù)或用戶(hù)類(lèi)型選擇錯(cuò)誤");
}
} catch (SQLException e) {
e.printStackTrace();
}
} else if (type.equals("普通用戶(hù)")) {
String sql = "select * from yonghu where yh_uname='" + uname
+ "' and yh_pwd='" + pwd + "' and yh_type='" + type
+ "'";
System.out.println(sql);
ResultSet res = DBUtils.Select(sql);
try {
if (res.next()) {
new ptjiemian(uname);
d.setVisible(false);
} else {
JOptionPane.showMessageDialog(null,
"用戶(hù)名或密碼錯(cuò)誤或你不是管理員用戶(hù)或用戶(hù)類(lèi)型選擇錯(cuò)誤");
}
} catch (SQLException e) {
e.printStackTrace();
}
}
} else if (arg0.getActionCommand().equals("普通用戶(hù)注冊(cè)")) {
new zhuCe();
} else if (arg0.getActionCommand().equals("找回密碼")) {
JOptionPane.showMessageDialog(null, "點(diǎn)擊了找回密碼按鈕");
new zhaoHuiMiMa();
}
}
}
package denglu;
import java.awt.*;
import java.sql.*;
import java.util.*;
import javax.swing.*;
public class dengLuHouJieMian extends JFrame {
public static JButton btn_xiugai, btn_quxiao = null;
public static DefaultTableModel dtm = null;
static JButton JButton1, JButton2, JButton3, JButton4 = null;
static JPanel JPanel_mianBan_top, JPanel_mianBan_left_bottom,
JPanel_mianBan_qieHuanYongHu, JPanel_mianBan_JYPHB,
JPanel_mianBan_GRXXXG, JPanel_mianBan_TCXT = null;
static JLabel lb_img, lb_title, lb_uname, lb_pwd, lb_name, lb_sex,
lb_phone = null;
static JRadioButton rb1, rb2 = null;
public static JTable tb1 = null;
static JTextField txt_uname, txt_pwd, txt_name, txt_phone = null;
JTree JTree1 = null;
public dengLuHouJieMian(String str) {
this.setTitle("普通用戶(hù)登錄后的主界面");
this.setLayout(null);
this.setSize(700, 700);
this.setLocationRelativeTo(null);
JPanel_mianBan_top = new JPanel(null);
JButton1 = new JButton("切換用戶(hù)", new ImageIcon("img//a.jpg"));
JButton1.setVerticalTextPosition(JButton.BOTTOM);
JButton1.setHorizontalTextPosition(JButton.CENTER);
JButton1.setBounds(100, 0, 120, 130);
JButton2 = new JButton("借閱排行榜", new ImageIcon("img//b.jpg"));
JButton2.setVerticalTextPosition(JButton.BOTTOM);
JButton2.setHorizontalTextPosition(JButton.CENTER);
JButton2.setBounds(250, 0, 120, 130);
JButton3 = new JButton("個(gè)人信息管理", new ImageIcon("img//c.jpg"));
JButton3.setVerticalTextPosition(JButton.BOTTOM);
JButton3.setHorizontalTextPosition(JButton.CENTER);
JButton3.setBounds(400, 0, 120, 130);
JButton4 = new JButton("退出系統(tǒng)", new ImageIcon("img//d.jpg"));
JButton4.setVerticalTextPosition(JButton.BOTTOM);
JButton4.setHorizontalTextPosition(JButton.CENTER);
JButton4.setBounds(550, 0, 120, 130);
JPanel_mianBan_top.add(JButton1);
JPanel_mianBan_top.add(JButton2);
JPanel_mianBan_top.add(JButton3);
JPanel_mianBan_top.add(JButton4);
JPanel_mianBan_left_bottom = new JPanel(null);
JPanel_mianBan_qieHuanYongHu = new JPanel(null);
JPanel_mianBan_JYPHB = new JPanel(null);
JPanel_mianBan_GRXXXG = new JPanel(null);
JPanel_mianBan_TCXT = new JPanel(null);
UIManager.put("Tree.collapsedIcon", new ImageIcon("img//1.png"));
UIManager.put("Tree.expandedIcon", new ImageIcon("img//2.png"));
UIManager.put("Tree.openIcon", new ImageIcon("img//3.png"));
UIManager.put("Tree.closedIcon", new ImageIcon("img//4.png"));
UIManager.put("Tree.leafIcon", new ImageIcon("img//5.png"));
DefaultMutableTreeNode dmtn1 = new DefaultMutableTreeNode("菜單列表");
DefaultMutableTreeNode dmtn_yonghu = new DefaultMutableTreeNode("用戶(hù)管理");
DefaultMutableTreeNode dmtn_tuShu = new DefaultMutableTreeNode("圖書(shū)管理");
DefaultMutableTreeNode dmtn_tuShuLeiXing = new DefaultMutableTreeNode(
"圖書(shū)類(lèi)型管理");
DefaultMutableTreeNode dmtn_jieyue = new DefaultMutableTreeNode("借閱管理");
dmtn1.add(dmtn_yonghu);
dmtn1.add(dmtn_tuShu);
dmtn1.add(dmtn_tuShuLeiXing);
dmtn1.add(dmtn_jieyue);
JTree1 = new JTree(dmtn1);
JTree1.addTreeSelectionListener(new glsj(this));
JTree1.setBounds(10, 10, 150, 300);
JPanel_mianBan_left_bottom.add(JTree1);
JButton1.addActionListener(new glsj(this));
JButton2.addActionListener(new glsj(this));
JButton3.addActionListener(new glsj(this));
JButton4.addActionListener(new glsj(this));
JPanel_mianBan_top.setBounds(0, 0, 700, 130);
JPanel_mianBan_left_bottom.setBounds(0, 130, 150, 600);
lb_title = new JLabel("個(gè)人信息修改");
lb_title.setFont(new Font("微軟雅黑", Font.BOLD, 30));
lb_title.setBounds(120, 40, 200, 30);
lb_uname = new JLabel("用戶(hù)名:");
lb_pwd = new JLabel("密碼:");
lb_name = new JLabel("真實(shí)姓名:");
lb_sex = new JLabel("性別:");
lb_phone = new JLabel("電話:");
lb_uname.setBounds(100, 90, 80, 30);
lb_pwd.setBounds(100, 130, 80, 30);
lb_name.setBounds(100, 170, 80, 30);
lb_sex.setBounds(100, 210, 80, 30);
lb_phone.setBounds(100, 250, 80, 30);
JPanel_mianBan_GRXXXG.add(lb_uname);
JPanel_mianBan_GRXXXG.add(lb_pwd);
JPanel_mianBan_GRXXXG.add(lb_name);
JPanel_mianBan_GRXXXG.add(lb_sex);
JPanel_mianBan_GRXXXG.add(lb_phone);
JPanel_mianBan_GRXXXG.add(lb_title);
txt_pwd = new JTextField();
txt_name = new JTextField();
txt_phone = new JTextField();
txt_uname = new JTextField();
txt_uname.setEditable(false);
btn_xiugai = new JButton("修改");
btn_xiugai.addActionListener(new glsj(this));
btn_quxiao = new JButton("取消");
btn_xiugai.setBounds(120, 290, 70, 30);
btn_quxiao.setBounds(240, 290, 70, 30);
txt_uname.setBounds(180, 90, 120, 30);
txt_pwd.setBounds(180, 130, 120, 30);
txt_name.setBounds(180, 170, 120, 30);
txt_phone.setBounds(180, 250, 120, 30);
rb1 = new JRadioButton("男", true);
rb2 = new JRadioButton("女", false);
ButtonGroup bg = new ButtonGroup();
bg.add(rb1);
bg.add(rb2);
rb1.setBounds(180, 210, 60, 30);
rb2.setBounds(250, 210, 60, 30);
JPanel_mianBan_GRXXXG.add(txt_uname);
JPanel_mianBan_GRXXXG.add(txt_pwd);
JPanel_mianBan_GRXXXG.add(txt_name);
JPanel_mianBan_GRXXXG.add(rb1);
JPanel_mianBan_GRXXXG.add(rb2);
JPanel_mianBan_GRXXXG.add(txt_phone);
JPanel_mianBan_GRXXXG.add(btn_quxiao);
JPanel_mianBan_GRXXXG.add(btn_xiugai);
lb_img = new JLabel();
lb_img.setBounds(0, 0, 532, 532);
lb_img.setIcon(new ImageIcon("img//圖片管理.png"));
JPanel_mianBan_qieHuanYongHu.add(lb_img);
JPanel_mianBan_qieHuanYongHu.setBounds(150, 130, 550, 600);
JPanel_mianBan_GRXXXG.setBounds(150, 130, 550, 600);
JPanel_mianBan_TCXT.setBounds(150, 130, 550, 600);
JPanel_mianBan_top.setBorder(BorderFactory.createLineBorder(Color.red));
JPanel_mianBan_left_bottom.setBorder(BorderFactory
.createLineBorder(Color.green));
JPanel_mianBan_qieHuanYongHu.setBorder(BorderFactory
.createLineBorder(Color.blue));
JPanel_mianBan_JYPHB.setBorder(BorderFactory
.createLineBorder(Color.red));
JPanel_mianBan_GRXXXG.setBorder(BorderFactory
.createLineBorder(Color.green));
JPanel_mianBan_TCXT.setBorder(BorderFactory
.createLineBorder(Color.blue));
if (JPanel_mianBan_JYPHB != null) {
this.remove(JPanel_mianBan_JYPHB);
}
Vector<Object> v_head = new Vector<Object>();
v_head.add("名次");
v_head.add("圖書(shū)名稱(chēng)");
v_head.add("借閱數(shù)量");
String sql = "select * from jieyue a inner join tushu b on"
+ " a.ts_id=b.ts_id order by a.jnum desc";
Vector<Vector<Object>> v_body = new Vector<Vector<Object>>();
ResultSet res = DBUtils.Select(sql);
int num = 1;
try {
while (res.next()) {
Vector<Object> v = new Vector<Object>();
v.add(num++);
v.add(res.getString("ts_name"));
v.add(res.getInt("jnum"));
v_body.add(v);
}
} catch (SQLException e) {
e.printStackTrace();
}
dtm = new DefaultTableModel(v_body, v_head);
dtm = new DefaultTableModel(v_body, v_head) {
@Override
public boolean isCellEditable(int a, int b) {
return false;
}
};
tb1 = new JTable(dtm);
JScrollPane jsp = new JScrollPane(tb1);
jsp.setBounds(0, 0, 500, 500);
JPanel_mianBan_JYPHB = new JPanel();
JPanel_mianBan_JYPHB.add(jsp);
JPanel_mianBan_JYPHB.setBorder(BorderFactory
.createLineBorder(Color.green));
JPanel_mianBan_JYPHB.setBounds(150, 130, 550, 600);
this.add(JPanel_mianBan_JYPHB);
this.add(JPanel_mianBan_top);
this.add(JPanel_mianBan_left_bottom);
this.add(JPanel_mianBan_qieHuanYongHu);
this.add(JPanel_mianBan_JYPHB);
this.add(JPanel_mianBan_GRXXXG);
this.add(JPanel_mianBan_TCXT);
String sql1 = "select * from yonghu where yh_uname='" + str + "'";
ResultSet res1 = DBUtils.Select(sql1);
try {
while (res1.next()) {
txt_uname.setText(res1.getString("yh_uname"));
txt_pwd.setText(res1.getString("yh_pwd"));
txt_phone.setText(res1.getString("yh_phone"));
txt_name.setText(res1.getString("yh_name"));
String sex = res1.getString("yh_sex");
if (sex.equals("男")) {
rb1.setSelected(true);
rb2.setSelected(false);
} else if (sex.equals("女")) {
rb2.setSelected(true);
rb1.setSelected(false);
}
}
} catch (SQLException e) {
e.printStackTrace();
}
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setVisible(true);
}
}
class glsj implements ActionListener, TreeSelectionListener, MouseListener {
public dengLuHouJieMian dd = null;
public glsj(dengLuHouJieMian dengLuHouJieMian) {
dd = dengLuHouJieMian;
}
@Override
public void actionPerformed(ActionEvent arg0) {
String str = arg0.getActionCommand();
if (arg0.getSource() == dd.JButton1) {
dd.JPanel_mianBan_qieHuanYongHu.setVisible(true);
new denglu();
} else if (str.equals("借閱排行榜")) {
dd.JPanel_mianBan_JYPHB.setVisible(true);
dd.JPanel_mianBan_qieHuanYongHu.setVisible(false);
dd.JPanel_mianBan_GRXXXG.setVisible(false);
dd.JPanel_mianBan_TCXT.setVisible(false);
} else if (arg0.getSource() == dd.JButton3) {
dd.JPanel_mianBan_GRXXXG.setVisible(true);
dd.JPanel_mianBan_JYPHB.setVisible(false);
dd.JPanel_mianBan_qieHuanYongHu.setVisible(false);
dd.JPanel_mianBan_TCXT.setVisible(false);
} else if (arg0.getSource() == dd.JButton4) {
System.exit(0);
} else if (arg0.getActionCommand().equals("修改")) {
String uname = dd.txt_uname.getText();
String phone = dd.txt_phone.getText();
String name = dd.txt_name.getText();
String pwd = dd.txt_pwd.getText();
String sex = "男";
if (dd.rb2.isSelected()) {
sex = "女";
}
String sql = "update yonghu set yh_pwd='" + pwd + "', yh_name='"
+ name + "' , yh_phone= ' " + phone + "' , yh_sex='" + sex
+ "' where yh_uname='" + uname + "'";
if (DBUtils.ZSG(sql)) {
JOptionPane.showMessageDialog(null, "個(gè)人信息更新成功");
return;
} else {
JOptionPane.showMessageDialog(null, "出現(xiàn)了未知的錯(cuò)誤，請(qǐng)重試");
}
}
}
@Override
public void mouseClicked(MouseEvent arg0) {
// TODO Auto-generated method stub
}
@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
}
@Override
public void valueChanged(TreeSelectionEvent arg0) {
DefaultMutableTreeNode str = (DefaultMutableTreeNode) dd.JTree1
.getLastSelectedPathComponent();
if (str.toString().equals("用戶(hù)管理")) {
new yonghuguanli();
} else if (str.toString().equals("圖書(shū)管理")) {
new tuShuGuanLi();
} else if (str.toString().equals("圖書(shū)類(lèi)型管理")) {
new tuShuLeiXingGuanLi();
} else if (str.toString().equals("借閱管理")) {
new jieyue();
}
}
}
