Java编写的简单图书管理系统word文档良心出品.docx
- 文档编号:11601507
- 上传时间:2023-03-20
- 格式:DOCX
- 页数:24
- 大小:305.06KB
Java编写的简单图书管理系统word文档良心出品.docx
《Java编写的简单图书管理系统word文档良心出品.docx》由会员分享,可在线阅读,更多相关《Java编写的简单图书管理系统word文档良心出品.docx(24页珍藏版)》请在冰豆网上搜索。
Java编写的简单图书管理系统word文档良心出品
Java编写的简单图书管理系统
主界面
代码实现
packageLibrary;
importjava.awt.BorderLayout;
importjava.awt.Color;
importjava.awt.Container;
importjava.awt.event.ActionEvent;
importjava.awt.event.ActionListener;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
importjavax.swing.ImageIcon;
importjavax.swing.JButton;
importjavax.swing.JFrame;
importjavax.swing.JLabel;
importjavax.swing.JOptionPane;
importjavax.swing.JPanel;
importjavax.swing.JPasswordField;
importjavax.swing.JTextField;
publicclassLoginextendsJFrame{
privatestaticfinallongserialVersionUID=1L;
privateJLabeljlUsername;
privateJLabeljlPwd;
privateJTextFieldtxtUsername;//用户名
privateJTextFieldtxtPassword;//密码
privateJButtonjbOk;
privateJButtonjbCancel;
publicJLabelgetJlUsername(){
if(jlUsername==null)
{
jlUsername=newJLabel("账号");
jlUsername.setForeground(Color.BLACK);
jlUsername.setBounds(118,40,85,30);
}
returnjlUsername;
}
publicJLabelgetJlPwd(){
if(jlPwd==null)
{
jlPwd=newJLabel("密码");
jlPwd.setForeground(Color.BLACK);
jlPwd.setBounds(118,100,85,30);
}
returnjlPwd;
}
publicJTextFieldgetTxtUsername(){
if(txtUsername==null)
{
txtUsername=newJTextField(20);
txtUsername.setBounds(180,40,200,30);
}
returntxtUsername;
}
publicJTextFieldgetTxtPassword(){
if(txtPassword==null)
{
txtPassword=newJPasswordField(20);
txtPassword.setBounds(180,100,200,30);
}
returntxtPassword;
}
publicJButtongetJbOk(){
if(jbOk==null)
{
jbOk=newJButton("登陆");
jbOk.setBounds(150,180,90,30);
//jbOk.addActionListener(this);
}
returnjbOk;
}
publicJButtongetJbCancel(){
if(jbCancel==null)
{
jbCancel=newJButton("取消");
jbCancel.setBounds(300,180,90,30);
}
returnjbCancel;
}
publicLogin(Stringtitle)
{
super(title);
//JFrameframe=newJFrame();
Containercantainer=this.getContentPane();
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
ImageIconimg=newImageIcon("F:
\\Java\\传习\\src\\Library\\ZF`XY`H48I_}U)C4~}M2~C4.jpg");//这是背景图片
JLabelimgLabel=newJLabel(img);//将背景图放在标签里。
this.getLayeredPane().add(imgLabel,newInteger(Integer.MIN_VALUE));//注意这里是关键,将背景标签添加到jfram的LayeredPane面板里。
imgLabel.setBounds(0,0,img.getIconWidth(),img.getIconHeight());//设置背景标签的位置
cantainer.setLayout(newBorderLayout());
imgLabel.setLayout(null);
imgLabel.add(getJlUsername());
imgLabel.add(getTxtUsername());
imgLabel.add(getJlPwd());
imgLabel.add(getTxtPassword());
imgLabel.add(getJbOk());
imgLabel.add(getJbCancel());
cantainer.add(imgLabel,BorderLayout.NORTH);
((JPanel)cantainer).setOpaque(false);//注意这里,将内容面板设为透明。
这样LayeredPane面板中的背景才能显示出来。
this.setSize(img.getIconWidth(),img.getIconHeight());
myEvent();
this.setVisible(true);
this.setResizable(true);
}
privatevoidmyEvent(){
jbCancel.addActionListener(newActionListener()
{
publicvoidactionPerformed(ActionEvente)
{
Login.this.dispose();
}
});
jbOk.addActionListener(newActionListener()
{
publicvoidactionPerformed(ActionEvente)
{
Connectionconn=null;
Statementstm=null;
ResultSetst=null;
try
{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection("jdbc:
mysql:
//localhost:
3306/library","sa","123456");
stm=conn.createStatement();
Stringsql="select*fromuser";
//Stringsql1="selectpswfromuser";
st=stm.executeQuery(sql);
//st1=stm.executeQuery(sql1);
if(st.next())
{
if(txtUsername.getText().equals(st.getString("id"))&&txtPassword.getText().equals(st.getString("psw")))
{
Login.this.setVisible(false);
newBook("管理界面");
}
else
{
JOptionPane.showMessageDialog(null,"您输入的账号或密码不正确");
getTxtUsername().setText("");
getTxtPassword().setText("");
}
}
else
{
JOptionPane.showMessageDialog(null,"用户名不存在,请重新输入,错误!
");
getTxtUsername().setText("");
getTxtPassword().setText("");
}
}
catch(ClassNotFoundExceptione1)
{
e1.printStackTrace();
}catch(SQLExceptione2){
//TODOAuto-generatedcatchblock
e2.printStackTrace();
}finally{
try{
stm.close();
}catch(Exceptione3){}
//关闭Connection
try{conn.close();}catch(Exceptione4){}
}
}
});
}
publicstaticvoidmain(String[]args)
{
newLogin("图书管理登陆界面");
}
}
管理界面
实现代码
packageLibrary;
importjava.awt.BorderLayout;
importjava.awt.Container;
importjava.awt.event.ActionEvent;
importjava.awt.event.ActionListener;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjava.sql.SQLException;
importjava.sql.Statement;
importjavax.swing.ImageIcon;
importjavax.swing.JButton;
importjavax.swing.JFrame;
importjavax.swing.JLabel;
importjavax.swing.JPanel;
importjavax.swing.JTable;
importjavax.swing.JTextField;
publicclassBookextendsJFrame{
privatestaticfinallongserialVersionUID=1L;
privateJLabellblId;
privateJLabellblBname;
privateJLabellblWname;
privateJLabellblCbs;
privateJLabellblnum1;
privateJLabellblnum2;
privateJTextFieldbId;//图书编号
privateJTextFieldbname;//书名
privateJTextFieldwname;//作者名
privateJTextFieldcbs;//出版社
privateJTextFieldnum1;//现存量
privateJTextFieldnum2;//库存量
privateJButtonjbDel;
privateJTextFieldjDel;
privateJButtonjbAdd;
privateJButtonjbSearch;
privateJButtonjbUpdate;
privateJTabletable;
privateJLabeljabel;//输入要查找的书号
publicJLabelgetJabel(){
if(jabel==null)
{
jabel=newJLabel("查删学号");
jabel.setBounds(50,350,50,30);
}
returnjabel;
}
publicJButtongetJbDel(){
if(jbDel==null)
{
jbDel=newJButton("删除");
jbDel.setBounds(180,400,60,30);
}
returnjbDel;
}
publicJTextFieldgetjDel(){
if(jDel==null)
{
jDel=newJTextField(20);
jDel.setBounds(100,350,150,30);
}
returnjDel;
}
publicJButtongetJbAdd(){
if(jbAdd==null)
{
jbAdd=newJButton("添加");
jbAdd.setBounds(100,400,60,30);
}
returnjbAdd;
}
publicJButtongetJbSearch(){
if(jbSearch==null)
{
jbSearch=newJButton("查找");
jbSearch.setBounds(100,450,60,30);
}
returnjbSearch;
}
publicJButtongetJbUpdate(){
if(jbUpdate==null)
{
jbUpdate=newJButton("修改");
jbUpdate.setBounds(180,450,60,30);
}
returnjbUpdate;
}
publicJTablegetTable(){
if(table==null)
{
table=newJTable(100,6);
table.setBounds(270,50,500,600);
}
returntable;
}
publicJLabelgetLblId(){
if(lblId==null)
{
lblId=newJLabel("编号");
lblId.setBounds(50,50,50,30);
}
returnlblId;
}
publicJLabelgetLblBname(){
if(lblBname==null)
{
lblBname=newJLabel("书名");
lblBname.setBounds(50,100,50,30);
}
returnlblBname;
}
publicJLabelgetLblWname(){
if(lblWname==null)
{
lblWname=newJLabel("作者");
lblWname.setBounds(50,150,50,30);
}
returnlblWname;
}
publicJLabelgetLblnum1(){
if(lblnum1==null)
{
lblnum1=newJLabel("现存量");
lblnum1.setBounds(50,200,50,30);
}
returnlblnum1;
}
publicJLabelgetLblnum2(){
if(lblnum2==null)
{
lblnum2=newJLabel("库存量");
lblnum2.setBounds(50,250,50,30);
}
returnlblnum2;
}
publicJTextFieldgetbId(){
if(bId==null)
{
bId=newJTextField(20);
bId.setBounds(100,50,150,30);
}
returnbId;
}
publicJTextFieldgetBname(){
if(bname==null)
{
bname=newJTextField(20);
bname.setBounds(100,100,150,30);
}
returnbname;
}
publicJTextFieldgetWname(){
if(wname==null)
{
wname=newJTextField(20);
wname.setBounds(100,150,150,30);
}
returnwname;
}
publicJTextFieldgetNum1(){
if(num1==null)
{
num1=newJTextField(20);
num1.setBounds(100,200,150,30);
}
returnnum1;
}
publicJTextFieldgetNum2(){
if(num2==null)
{
num2=newJTextField(20);
num2.setBounds(100,250,150,30);
}
returnnum2;
}
publicJLabelgetLblCbs(){
if(lblCbs==null)
{
lblCbs=newJLabel("出版社");
lblCbs.setBounds(50,300,50,30);
}
returnlblCbs;
}
publicJTextFieldgetCbs(){
if(cbs==null)
{
cbs=newJTextField(20);
cbs.setBounds(100,300,150,30);
}
returncbs;
}
publicBook(Stringtitle)
{
super(title);
//JFrameframe=newJFrame();
Containercantainer=this.getContentPane();
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
ImageIconimg=newImageIcon("F:
\\Java\\传习\\src\\Library\\d50735fae6cd7b8961e8eafd0f2442a7d8330ecc[1].jpg");//这是背景图片
JLabelimgLabel=newJLabel(img);//将背景图放在标签里。
this.getLayeredPane().add(imgLabel,newInteger(Integer.MIN_VALUE));//注意这里是关键,将背景标签添加到jfram的LayeredPane面板里。
imgLabel.setBounds(0,0,img.getIconWidth(),img.getIconHeight());//设置背景标签的位置
cantainer.setLayout(newBorderLayout());
imgLabel.setLayout(null);
imgLabel.add(getLblId());
imgLabel.add(getbId());
imgLabel.add(getLblBname());
imgLabel.add(getBname());
imgLabel.add(getLblWname());
imgLabel.add(getWname());
imgLabel.add(getLblnum1());
imgLabel.add(getNum1());
imgLabel.add(getLblnum2());
imgLabel.add(getNum2());
imgLabel.add(getLblCbs());
imgLabel.add(getCbs());
imgLabel.add(getTable());
imgLabel.add(getJbDel());
imgLabel.add(getjDel());
imgLabel.add(getJbA
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Java 编写 简单 图书 管理 系统 word 文档 良心 出品