最美情侣中文字幕电影,在线麻豆精品传媒,在线网站高清黄,久久黄色视频

歡迎光臨散文網(wǎng) 會員登陸 & 注冊

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

2020-04-26 01:18 作者:詩書畫唱  | 我要投稿



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 = " ";

}



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

分享到微博請遵守國家法律
民丰县| 沅江市| 蓬安县| 措美县| 云梦县| 湘阴县| 金平| 贵南县| 南充市| 张家港市| 手机| 农安县| 白玉县| 安陆市| 明星| 衡南县| 左云县| 博爱县| 铁岭县| 铁岭市| 西宁市| 许昌市| 黔西县| 体育| 马关县| 任丘市| 龙岩市| 牟定县| 五寨县| 外汇| 桂阳县| 赤峰市| 大足县| 敖汉旗| 安宁市| 长沙县| 娄烦县| 东莞市| 武城县| 齐河县| 宝鸡市|