Java swing2圖書管理系統(tǒng)無注釋美化皮膚包版:含SQL部分和效果圖


package denglu;
import java.awt.Color;
import java.awt.Font;
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.BorderFactory;
import javax.swing.ButtonGroup;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JRadioButton;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.JTree;
import javax.swing.UIManager;
import javax.swing.event.TreeSelectionEvent;
import javax.swing.event.TreeSelectionListener;
import javax.swing.table.DefaultTableModel;
import javax.swing.tree.DefaultMutableTreeNode;
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("管理員用戶登錄后的主界面");
this.setLayout(null);
this.setSize(700, 700);
this.setLocationRelativeTo(null);
JPanel_mianBan_top = new JPanel(null);
JButton1 = new JButton("切換用戶", 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("個人信息管理", 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("用戶管理");
DefaultMutableTreeNode dmtn_tuShu = new DefaultMutableTreeNode("圖書管理");
DefaultMutableTreeNode dmtn_tuShuLeiXing = new DefaultMutableTreeNode(
"圖書類型管理");
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("個人信息修改");
lb_title.setFont(new Font("微軟雅黑", Font.BOLD, 30));
lb_title.setBounds(120, 40, 200, 30);
lb_uname = new JLabel("用戶名:");
lb_pwd = new JLabel("密碼:");
lb_name = new JLabel("真實姓名:");
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("圖書名稱");
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, "個人信息更新成功");
return;
} else {
JOptionPane.showMessageDialog(null, "出現(xiàn)了未知的錯誤,請重試");
}
}
}
@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("用戶管理")) {
new yonghuguanli();
} else if (str.toString().equals("圖書管理")) {
new tuShuGuanLi();
} else if (str.toString().equals("圖書類型管理")) {
new tuShuLeiXingGuanLi();
} else if (str.toString().equals("借閱管理")) {
new jieyue();
}
}
}



package denglu;
public class gongjvClass {
public static String uname = " ";
}
