📄 bookmanage.java
字号:
import javax.swing.SwingUtilities;
import java.awt.BorderLayout;
import javax.swing.JPanel;
import java.awt.GraphicsConfiguration;
import java.awt.HeadlessException;
import javax.swing.JFrame;
import java.awt.Dimension;
import javax.swing.JTabbedPane;
import java.awt.Rectangle;
import java.awt.GridBagLayout;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JTextField;
import javax.swing.JTextArea;
import java.awt.event.*;
public class BookManage extends JFrame {
private static final long serialVersionUID = 1L;
private JPanel jContentPane = null;
private JTabbedPane jTabbedPane = null;
private JPanel jPanel = null;
private JPanel jPanel1 = null;
private JPanel jPanel2 = null;
private JTextArea jTextArea = null;
private JButton jButton = null;
private JTextField jTextField = null;
private JTextField jTextField1 = null;
private JTextField jTextField2 = null;
private JTextField jTextField3 = null;
private JTextField jTextField4 = null;
private JButton jButton6 = null;
private JButton jButton7 = null;
private JTextArea jTextArea1 = null;
private JLabel jLabel = null;
private JTextField jTextField5 = null;
private JButton jButton8 = null;
private JLabel jLabel1 = null;
private JLabel jLabel2 = null;
private JLabel jLabel3 = null;
private JLabel jLabel4 = null;
private JLabel jLabel5 = null;
private JButton jButton1 = null;
private JPanel jPanel3 = null;
private JLabel jLabel6 = null;
private JTextField jTextField6 = null;
private JButton jButton2 = null;
private JTextArea jTextArea2 = null;
private JLabel jLabel7 = null;
private JTextField jTextField7 = null;
private JLabel jLabel8 = null;
private JTextField jTextField8 = null;
private JLabel jLabel9 = null;
private JTextField jTextField9 = null;
private JLabel jLabel10 = null;
private JTextField jTextField10 = null;
private JButton jButton3 = null;
private JButton jButton4 = null;
public BookManage() throws HeadlessException {
// TODO Auto-generated constructor stub
super();
initialize();
}
public BookManage(GraphicsConfiguration arg0) {
super(arg0);
// TODO Auto-generated constructor stub
initialize();
}
public BookManage(String arg0) throws HeadlessException {
super(arg0);
// TODO Auto-generated constructor stub
initialize();
}
public BookManage(String arg0, GraphicsConfiguration arg1) {
super(arg0, arg1);
// TODO Auto-generated constructor stub
initialize();
}
/**
* This method initializes jTabbedPane
*
* @return javax.swing.JTabbedPane
*/
private JTabbedPane getJTabbedPane() {
if (jTabbedPane == null) {
jTabbedPane = new JTabbedPane();
jTabbedPane.setBounds(new Rectangle(-2, -1, 726, 299));
jTabbedPane.addTab("图书信息", null, getJPanel(), null);
jTabbedPane.addTab("添加", null, getJPanel1(), null);
jTabbedPane.addTab("删除", null, getJPanel2(), null);
jTabbedPane.addTab("修改", null, getJPanel3(), null);
}
return jTabbedPane;
}
/**
* This method initializes jPanel
*
* @return javax.swing.JPanel
*/
private JPanel getJPanel() {
if (jPanel == null) {
jPanel = new JPanel();
jPanel.setLayout(null);
jPanel.add(getJTextArea(), null);
jPanel.add(getJButton(), null);
}
return jPanel;
}
/**
* This method initializes jPanel1
*
* @return javax.swing.JPanel
*/
private JPanel getJPanel1() {
if (jPanel1 == null) {
jLabel5 = new JLabel();
jLabel5.setBounds(new Rectangle(43, 139, 103, 27));
jLabel5.setText("作者：");
jLabel4 = new JLabel();
jLabel4.setBounds(new Rectangle(376, 81, 103, 27));
jLabel4.setText("出版社：");
jLabel3 = new JLabel();
jLabel3.setBounds(new Rectangle(43, 81, 103, 27));
jLabel3.setText("类型：");
jLabel2 = new JLabel();
jLabel2.setBounds(new Rectangle(376, 25, 103, 27));
jLabel2.setText("图书名称：");
jLabel1 = new JLabel();
jLabel1.setBounds(new Rectangle(43, 26, 103, 27));
jLabel1.setText("图书编号：");
jPanel1 = new JPanel();
jPanel1.setLayout(null);
jPanel1.add(getJTextField(), null);
jPanel1.add(getJTextField1(), null);
jPanel1.add(getJTextField2(), null);
jPanel1.add(getJTextField3(), null);
jPanel1.add(getJTextField4(), null);
jPanel1.add(getJButton6(), null);
jPanel1.add(jLabel1, null);
jPanel1.add(jLabel2, null);
jPanel1.add(jLabel3, null);
jPanel1.add(jLabel4, null);
jPanel1.add(jLabel5, null);
jPanel1.add(getJButton1(), null);
}
return jPanel1;
}
/**
* This method initializes jPanel2
*
* @return javax.swing.JPanel
*/
private JPanel getJPanel2() {
if (jPanel2 == null) {
jLabel = new JLabel();
jLabel.setBounds(new Rectangle(102, 230, 107, 27));
jLabel.setText("删除的书号：");
jPanel2 = new JPanel();
jPanel2.setLayout(null);
jPanel2.add(getJButton7(), null);
jPanel2.add(getJTextArea1(), null);
jPanel2.add(jLabel, null);
jPanel2.add(getJTextField5(), null);
jPanel2.add(getJButton8(), null);
}
return jPanel2;
}
/**
* This method initializes jTextArea
*
* @return javax.swing.JTextArea
*/
private JTextArea getJTextArea() {
if (jTextArea == null) {
jTextArea = new JTextArea();
jTextArea.setBounds(new Rectangle(38, 21, 655, 204));
}
return jTextArea;
}
/**
* This method initializes jButton
*
* @return javax.swing.JButton
*/
private JButton getJButton() {
if (jButton == null) {
jButton = new JButton();
jButton.setBounds(new Rectangle(272, 237, 143, 28));
jButton.setText("显示所有图书信息");
jButton.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce)
{
System.out.println("ClassNotFoundException:"+ce.getMessage());
}
try
{
Connection con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("SELECT * from bookInfo");
jTextArea.setText("图书编号"+"\t"+"书名"+"\t"+"类型"+"\t"+"出版社"+"\t"+"作者"+"\t"+"是否被借"+"\t"+"借阅者编号");
while(rs.next())
{
jTextArea.append("\n"+rs.getString(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3)+"\t"+rs.getString(4)+"\t"+rs.getString(5)+"\t"+rs.getString(6));
}
rs.close();
stmt.close();
}
catch(SQLException ce)
{
System.out.println("SQLException"+ce.getMessage());
}
}
});
}
return jButton;
}
/**
* This method initializes jTextField
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField() {
if (jTextField == null) {
jTextField = new JTextField();
jTextField.setBounds(new Rectangle(156, 25, 141, 28));
}
return jTextField;
}
/**
* This method initializes jTextField1
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField1() {
if (jTextField1 == null) {
jTextField1 = new JTextField();
jTextField1.setBounds(new Rectangle(483, 26, 135, 27));
}
return jTextField1;
}
/**
* This method initializes jTextField2
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField2() {
if (jTextField2 == null) {
jTextField2 = new JTextField();
jTextField2.setBounds(new Rectangle(156, 80, 141, 28));
}
return jTextField2;
}
/**
* This method initializes jTextField3
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField3() {
if (jTextField3 == null) {
jTextField3 = new JTextField();
jTextField3.setBounds(new Rectangle(483, 81, 135, 27));
}
return jTextField3;
}
/**
* This method initializes jTextField4
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField4() {
if (jTextField4 == null) {
jTextField4 = new JTextField();
jTextField4.setBounds(new Rectangle(156, 138, 141, 28));
}
return jTextField4;
}
/**
* This method initializes jButton6
*
* @return javax.swing.JButton
*/
private JButton getJButton6() {
if (jButton6 == null) {
jButton6 = new JButton();
jButton6.setBounds(new Rectangle(95, 220, 113, 28));
jButton6.setText("添加");
jButton6.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
Button_tj(e);
}
});
}
return jButton6;
}
public void Button_tj(ActionEvent e)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce)
{
System.out.println("ClassNotFoundException:"+ce.getMessage());
}
try
{
Connection con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from bookInfo where code='"+jTextField.getText()+"'");
if(!rs.next())
{
String sqlstr = "insert into bookInfo values('"+jTextField.getText()+"','"+jTextField1.getText()+"','"+jTextField2.getText()+"','"+jTextField3.getText()+"','"+jTextField4.getText()+"',false,null)";
stmt.executeUpdate(sqlstr);
JOptionPane.showMessageDialog(this,"添加成功！","提示",JOptionPane.ERROR_MESSAGE);
}
else
JOptionPane.showMessageDialog(this,"此书已经存在！","提示",JOptionPane.ERROR_MESSAGE);
}
catch(SQLException ce)
{
System.out.println("SQLException"+ce.getMessage());
}
}
/**
* This method initializes jButton7
*
* @return javax.swing.JButton
*/
private JButton getJButton7() {
if (jButton7 == null) {
jButton7 = new JButton();
jButton7.setBounds(new Rectangle(219, 10, 187, 24));
jButton7.setText("显示所有图书信息");
jButton7.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent e) {
//System.out.println("actionPerformed()"); // TODO Auto-generated Event stub actionPerformed()
try
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -