📄 readermanage.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.awt.event.ActionEvent;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JOptionPane;
import javax.swing.JTextArea;
import javax.swing.JButton;
import javax.swing.JTextField;
import javax.swing.JLabel;
public class ReaderManage 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 JLabel jLabel = null;
private JLabel jLabel1 = null;
private JLabel jLabel2 = null;
private JTextField jTextField2 = null;
private JLabel jLabel3 = null;
private JTextField jTextField3 = null;
private JLabel jLabel4 = null;
private JLabel jLabel5 = null;
private JLabel jLabel6 = null;
private JTextField jTextField4 = null;
private JTextField jTextField5 = null;
private JTextField jTextField6 = null;
private JButton jButton1 = null;
private JButton jButton2 = null;
private JTextArea jTextArea1 = null;
private JLabel jLabel7 = null;
private JTextField jTextField7 = null;
private JButton jButton3 = null;
private JButton jButton4 = null;
private JPanel jPanel3 = null;
private JLabel jLabel8 = null;
private JTextField jTextField8 = null;
private JButton jButton5 = null;
private JTextArea jTextArea2 = null;
private JLabel jLabel9 = null;
private JTextField jTextField9 = null;
private JLabel jLabel10 = null;
private JTextField jTextField10 = null;
private JLabel jLabel11 = null;
private JTextField jTextField11 = null;
private JLabel jLabel12 = null;
private JTextField jTextField12 = null;
private JLabel jLabel13 = null;
private JTextField jTextField13 = null;
private JLabel jLabel14 = null;
private JTextField jTextField14 = null;
private JButton jButton6 = null;
private JButton jButton7 = null;
public ReaderManage() throws HeadlessException {
// TODO Auto-generated constructor stub
super();
initialize();
}
public ReaderManage(GraphicsConfiguration gc) {
super(gc);
// TODO Auto-generated constructor stub
initialize();
}
public ReaderManage(String title) throws HeadlessException {
super(title);
// TODO Auto-generated constructor stub
initialize();
}
public ReaderManage(String title, GraphicsConfiguration gc) {
super(title, gc);
// 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(0, 0, 747, 311));
jTabbedPane.setName("");
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) {
jLabel6 = new JLabel();
jLabel6.setBounds(new Rectangle(34, 184, 99, 30));
jLabel6.setText("联系地址：");
jLabel5 = new JLabel();
jLabel5.setBounds(new Rectangle(387, 127, 99, 30));
jLabel5.setText("部门：");
jLabel4 = new JLabel();
jLabel4.setBounds(new Rectangle(34, 134, 99, 30));
jLabel4.setText("联系电话：");
jLabel3 = new JLabel();
jLabel3.setBounds(new Rectangle(387, 78, 99, 30));
jLabel3.setText("职业：");
jLabel2 = new JLabel();
jLabel2.setBounds(new Rectangle(34, 73, 99, 30));
jLabel2.setText("性别：");
jLabel1 = new JLabel();
jLabel1.setBounds(new Rectangle(387, 20, 99, 30));
jLabel1.setText("读者姓名：");
jLabel = new JLabel();
jLabel.setBounds(new Rectangle(34, 17, 99, 30));
jLabel.setText("读者编号：");
jPanel1 = new JPanel();
jPanel1.setLayout(null);
jPanel1.add(getJTextField(), null);
jPanel1.add(getJTextField1(), null);
jPanel1.add(jLabel, null);
jPanel1.add(jLabel1, null);
jPanel1.add(jLabel2, null);
jPanel1.add(getJTextField2(), null);
jPanel1.add(jLabel3, null);
jPanel1.add(getJTextField3(), null);
jPanel1.add(jLabel4, null);
jPanel1.add(jLabel5, null);
jPanel1.add(jLabel6, null);
jPanel1.add(getJTextField4(), null);
jPanel1.add(getJTextField5(), null);
jPanel1.add(getJTextField6(), null);
jPanel1.add(getJButton1(), null);
jPanel1.add(getJButton4(), null);
}
return jPanel1;
}
/**
* This method initializes jPanel2
*
* @return javax.swing.JPanel
*/
private JPanel getJPanel2() {
if (jPanel2 == null) {
jLabel7 = new JLabel();
jLabel7.setBounds(new Rectangle(110, 241, 123, 28));
jLabel7.setText("删除的读者编号：");
jPanel2 = new JPanel();
jPanel2.setLayout(null);
jPanel2.add(getJButton2(), null);
jPanel2.add(getJTextArea1(), null);
jPanel2.add(jLabel7, null);
jPanel2.add(getJTextField7(), null);
jPanel2.add(getJButton3(), null);
}
return jPanel2;
}
/**
* This method initializes jTextArea
*
* @return javax.swing.JTextArea
*/
private JTextArea getJTextArea() {
if (jTextArea == null) {
jTextArea = new JTextArea();
jTextArea.setBounds(new Rectangle(20, 36, 700, 178));
}
return jTextArea;
}
/**
* This method initializes jButton
*
* @return javax.swing.JButton
*/
private JButton getJButton() {
if (jButton == null) {
jButton = new JButton();
jButton.setBounds(new Rectangle(234, 230, 207, 30));
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 readerInfo");
jTextArea.setText("读者编号"+"\t"+"姓名"+"\t"+"性别"+"\t"+"职业"+"\t"+"联系电话"+"\t"+"部门"+"\t"+"联系地址"+"\t"+"brief");
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)+"\t"+rs.getString(7));
//rs=stmt.executeQuery("SELECT * from bookInfo where Code ='"+jTextField.getText()+"' and isBorrow=false");
}
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(164, 17, 156, 30));
}
return jTextField;
}
/**
* This method initializes jTextField1
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField1() {
if (jTextField1 == null) {
jTextField1 = new JTextField();
jTextField1.setBounds(new Rectangle(505, 20, 156, 30));
}
return jTextField1;
}
/**
* This method initializes jTextField2
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField2() {
if (jTextField2 == null) {
jTextField2 = new JTextField();
jTextField2.setBounds(new Rectangle(164, 73, 156, 30));
}
return jTextField2;
}
/**
* This method initializes jTextField3
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField3() {
if (jTextField3 == null) {
jTextField3 = new JTextField();
jTextField3.setBounds(new Rectangle(505, 78, 156, 30));
}
return jTextField3;
}
/**
* This method initializes jTextField4
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField4() {
if (jTextField4 == null) {
jTextField4 = new JTextField();
jTextField4.setBounds(new Rectangle(164, 132, 156, 30));
}
return jTextField4;
}
/**
* This method initializes jTextField5
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField5() {
if (jTextField5 == null) {
jTextField5 = new JTextField();
jTextField5.setBounds(new Rectangle(505, 130, 156, 30));
}
return jTextField5;
}
/**
* This method initializes jTextField6
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField6() {
if (jTextField6 == null) {
jTextField6 = new JTextField();
jTextField6.setBounds(new Rectangle(164, 180, 156, 30));
}
return jTextField6;
}
/**
* This method initializes jButton1
*
* @return javax.swing.JButton
*/
private JButton getJButton1() {
if (jButton1 == null) {
jButton1 = new JButton();
jButton1.setBounds(new Rectangle(149, 239, 121, 30));
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_tj(e);
}
});
}
return jButton1;
}
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 readerInfo where code='"+jTextField.getText()+"'");
if(!rs.next())
{
String sqlstr ="insert into readerInfo values('"+jTextField.getText()+"','"+jTextField1.getText()+"','"+jTextField2.getText()+"','"+jTextField3.getText()+"','"+jTextField4.getText()+"','"+jTextField5.getText()+"','"+jTextField6.getText()+"',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 jButton2
*
* @return javax.swing.JButton
*/
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -