📄 bookmanage.java
字号:
{
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");
jTextArea1.setText("图书编号"+"\t"+"书名"+"\t"+"类型"+"\t"+"出版社"+"\t"+"作者"+"\t"+"是否被借"+"\t"+"借阅者编号");
while(rs.next())
{
jTextArea1.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 jButton7;
}
/**
* This method initializes jTextArea1
*
* @return javax.swing.JTextArea
*/
private JTextArea getJTextArea1() {
if (jTextArea1 == null) {
jTextArea1 = new JTextArea();
jTextArea1.setBounds(new Rectangle(16, 44, 694, 176));
}
return jTextArea1;
}
/**
* This method initializes jTextField5
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField5() {
if (jTextField5 == null) {
jTextField5 = new JTextField();
jTextField5.setBounds(new Rectangle(221, 230, 132, 27));
}
return jTextField5;
}
/**
* This method initializes jButton8
*
* @return javax.swing.JButton
*/
private JButton getJButton8() {
if (jButton8 == null) {
jButton8 = new JButton();
jButton8.setBounds(new Rectangle(381, 230, 100, 27));
jButton8.setText("删除");
jButton8.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_shch(e);
}
});
}
return jButton8;
}
public void Button_shch(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();
String sql = "delete from bookInfo where code='"+jTextField5.getText()+"'";
stmt.executeUpdate(sql);
stmt.close();
JOptionPane.showMessageDialog(this,"删除成功！","提示",JOptionPane.ERROR_MESSAGE);
}
catch(SQLException ce)
{
System.out.println("SQLException"+ce.getMessage());
}
}
/**
* This method initializes jButton1
*
* @return javax.swing.JButton
*/
private JButton getJButton1() {
if (jButton1 == null) {
jButton1 = new JButton();
jButton1.setBounds(new Rectangle(371, 220, 125, 28));
jButton1.setText("退出");
jButton1.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_tch(e);
}
});
}
return jButton1;
}
public void Button_tch(ActionEvent e)
{
this.hide();
}
/**
* This method initializes jPanel3
*
* @return javax.swing.JPanel
*/
private JPanel getJPanel3() {
if (jPanel3 == null) {
jLabel10 = new JLabel();
jLabel10.setBounds(new Rectangle(351, 180, 125, 30));
jLabel10.setText("作者：");
jLabel9 = new JLabel();
jLabel9.setBounds(new Rectangle(22, 180, 125, 30));
jLabel9.setText("出版社：");
jLabel8 = new JLabel();
jLabel8.setBounds(new Rectangle(351, 132, 125, 30));
jLabel8.setText("类型：");
jLabel7 = new JLabel();
jLabel7.setBounds(new Rectangle(22, 132, 125, 30));
jLabel7.setText("书名：");
jLabel6 = new JLabel();
jLabel6.setBounds(new Rectangle(21, 16, 125, 27));
jLabel6.setText("修改的书号：");
jPanel3 = new JPanel();
jPanel3.setLayout(null);
jPanel3.add(jLabel6, null);
jPanel3.add(getJTextField6(), null);
jPanel3.add(getJButton2(), null);
jPanel3.add(getJTextArea2(), null);
jPanel3.add(jLabel7, null);
jPanel3.add(getJTextField7(), null);
jPanel3.add(jLabel8, null);
jPanel3.add(getJTextField8(), null);
jPanel3.add(jLabel9, null);
jPanel3.add(getJTextField9(), null);
jPanel3.add(jLabel10, null);
jPanel3.add(getJTextField10(), null);
jPanel3.add(getJButton3(), null);
jPanel3.add(getJButton4(), null);
}
return jPanel3;
}
/**
* This method initializes jTextField6
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField6() {
if (jTextField6 == null) {
jTextField6 = new JTextField();
jTextField6.setBounds(new Rectangle(167, 16, 130, 27));
}
return jTextField6;
}
/**
* This method initializes jButton2
*
* @return javax.swing.JButton
*/
private JButton getJButton2() {
if (jButton2 == null) {
jButton2 = new JButton();
jButton2.setBounds(new Rectangle(322, 16, 66, 27));
jButton2.setText("查找");
jButton2.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 where code='"+jTextField6.getText()+"'");
if(rs.next())
{
jTextArea2.setText("图书编号"+"\t"+"书名"+"\t"+"类型"+"\t"+"出版社"+"\t"+"作者"+"\t"+"是否被借"+"\t"+"借阅者编号");
jTextArea2.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();
else
jTextArea2.setText("你要修改的书不存在！");
}
catch(SQLException ce)
{
System.out.println("SQLException"+ce.getMessage());
}
}
});
}
return jButton2;
}
/**
* This method initializes jTextArea2
*
* @return javax.swing.JTextArea
*/
private JTextArea getJTextArea2() {
if (jTextArea2 == null) {
jTextArea2 = new JTextArea();
jTextArea2.setBounds(new Rectangle(21, 57, 688, 56));
}
return jTextArea2;
}
/**
* This method initializes jTextField7
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField7() {
if (jTextField7 == null) {
jTextField7 = new JTextField();
jTextField7.setBounds(new Rectangle(167, 132, 129, 30));
}
return jTextField7;
}
/**
* This method initializes jTextField8
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField8() {
if (jTextField8 == null) {
jTextField8 = new JTextField();
jTextField8.setBounds(new Rectangle(502, 132, 136, 30));
}
return jTextField8;
}
/**
* This method initializes jTextField9
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField9() {
if (jTextField9 == null) {
jTextField9 = new JTextField();
jTextField9.setBounds(new Rectangle(166, 180, 131, 30));
}
return jTextField9;
}
/**
* This method initializes jTextField10
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField10() {
if (jTextField10 == null) {
jTextField10 = new JTextField();
jTextField10.setBounds(new Rectangle(504, 180, 130, 30));
}
return jTextField10;
}
/**
* This method initializes jButton3
*
* @return javax.swing.JButton
*/
private JButton getJButton3() {
if (jButton3 == null) {
jButton3 = new JButton();
jButton3.setBounds(new Rectangle(144, 229, 127, 28));
jButton3.setText("修改");
jButton3.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_xg(e);
}
});
}
return jButton3;
}
public void Button_xg(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='"+jTextField6.getText()+"'");
if(rs.next())
{
String sql="update bookInfo set name='"+jTextField7.getText()+"',type='"+jTextField8.getText()+"',press='"+jTextField9.getText()+"',writer='"+jTextField10.getText()+"'" + "where code='"+jTextField6.getText()+"'";
stmt.executeUpdate(sql);
JOptionPane.showMessageDialog(this,"修改成功！","提示",JOptionPane.ERROR_MESSAGE);
}
//rs.close();
//stmt.close();
else
JOptionPane.showMessageDialog(this,"你要修改的书不存在！","提示",JOptionPane.ERROR_MESSAGE);
}
catch(SQLException ce)
{
System.out.println("SQLException"+ce.getMessage());
}
}
/**
* This method initializes jButton4
*
* @return javax.swing.JButton
*/
private JButton getJButton4() {
if (jButton4 == null) {
jButton4 = new JButton();
jButton4.setBounds(new Rectangle(348, 229, 127, 28));
jButton4.setText("返回");
jButton4.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_fh(e);
}
});
}
return jButton4;
}
public void Button_fh(ActionEvent e)
{
this.hide();
}
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
SwingUtilities.invokeLater(new Runnable() {
public void run() {
BookManage thisClass = new BookManage();
thisClass.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
thisClass.setVisible(true);
}
});
}
/**
* This method initializes this
*
* @return void
*/
private void initialize() {
this.setSize(730, 331);
this.setContentPane(getJContentPane());
this.setTitle("书库管理");
this.setVisible(true);
}
/**
* This method initializes jContentPane
*
* @return javax.swing.JPanel
*/
private JPanel getJContentPane() {
if (jContentPane == null) {
jContentPane = new JPanel();
jContentPane.setLayout(null);
jContentPane.add(getJTabbedPane(), null);
}
return jContentPane;
}
} // @jve:decl-index=0:visual-constraint="10,10"
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -