📄 readermanage.java
字号:
private JButton getJButton2() {
if (jButton2 == null) {
jButton2 = new JButton();
jButton2.setBounds(new Rectangle(235, 13, 176, 26));
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 readerInfo");
jTextArea1.setText("读者编号"+"\t"+"姓名"+"\t"+"性别"+"\t"+"职业"+"\t"+"联系电话"+"\t"+"部门"+"\t"+"联系地址"+"\t"+"brief");
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)+"\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 jButton2;
}
/**
* This method initializes jTextArea1
*
* @return javax.swing.JTextArea
*/
private JTextArea getJTextArea1() {
if (jTextArea1 == null) {
jTextArea1 = new JTextArea();
jTextArea1.setBounds(new Rectangle(19, 50, 703, 168));
}
return jTextArea1;
}
/**
* This method initializes jTextField7
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField7() {
if (jTextField7 == null) {
jTextField7 = new JTextField();
jTextField7.setBounds(new Rectangle(252, 241, 145, 28));
}
return jTextField7;
}
/**
* This method initializes jButton3
*
* @return javax.swing.JButton
*/
private JButton getJButton3() {
if (jButton3 == null) {
jButton3 = new JButton();
jButton3.setBounds(new Rectangle(424, 241, 90, 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_shch(e);
}
});
}
return jButton3;
}
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 readerInfo where code='"+jTextField7.getText()+"'";
stmt.executeUpdate(sql);
stmt.close();
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(362, 239, 121, 30));
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_tch(e);
}
});
}
return jButton4;
}
public void Button_tch(ActionEvent e)
{
this.hide();
}
/**
* This method initializes jPanel3
*
* @return javax.swing.JPanel
*/
private JPanel getJPanel3() {
if (jPanel3 == null) {
jLabel14 = new JLabel();
jLabel14.setBounds(new Rectangle(361, 199, 110, 26));
jLabel14.setText("联系地址：");
jLabel13 = new JLabel();
jLabel13.setBounds(new Rectangle(22, 199, 110, 26));
jLabel13.setText("部门：");
jLabel12 = new JLabel();
jLabel12.setBounds(new Rectangle(361, 166, 110, 26));
jLabel12.setText("联系电话：");
jLabel11 = new JLabel();
jLabel11.setBounds(new Rectangle(22, 166, 110, 26));
jLabel11.setText("职业：");
jLabel10 = new JLabel();
jLabel10.setBounds(new Rectangle(361, 134, 110, 26));
jLabel10.setText("性别：");
jLabel9 = new JLabel();
jLabel9.setBounds(new Rectangle(22, 134, 110, 26));
jLabel9.setText("姓名：");
jLabel8 = new JLabel();
jLabel8.setBounds(new Rectangle(22, 17, 129, 28));
jLabel8.setText("要修改的读者编号：");
jPanel3 = new JPanel();
jPanel3.setLayout(null);
jPanel3.add(jLabel8, null);
jPanel3.add(getJTextField8(), null);
jPanel3.add(getJButton5(), null);
jPanel3.add(getJTextArea2(), null);
jPanel3.add(jLabel9, null);
jPanel3.add(getJTextField9(), null);
jPanel3.add(jLabel10, null);
jPanel3.add(getJTextField10(), null);
jPanel3.add(jLabel11, null);
jPanel3.add(getJTextField11(), null);
jPanel3.add(jLabel12, null);
jPanel3.add(getJTextField12(), null);
jPanel3.add(jLabel13, null);
jPanel3.add(getJTextField13(), null);
jPanel3.add(jLabel14, null);
jPanel3.add(getJTextField14(), null);
jPanel3.add(getJButton6(), null);
jPanel3.add(getJButton7(), null);
}
return jPanel3;
}
/**
* This method initializes jTextField8
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField8() {
if (jTextField8 == null) {
jTextField8 = new JTextField();
jTextField8.setBounds(new Rectangle(161, 17, 131, 28));
}
return jTextField8;
}
/**
* This method initializes jButton5
*
* @return javax.swing.JButton
*/
private JButton getJButton5() {
if (jButton5 == null) {
jButton5 = new JButton();
jButton5.setBounds(new Rectangle(310, 17, 101, 28));
jButton5.setText("查找");
jButton5.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 where code='"+jTextField8.getText()+"'");
if(rs.next())
{
jTextArea2.setText("读者编号"+"\t"+"姓名"+"\t"+"性别"+"\t"+"职业"+"\t"+"联系电话"+"\t"+"部门"+"\t"+"联系地址"+"\t"+"brief");
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)+"\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 jButton5;
}
/**
* This method initializes jTextArea2
*
* @return javax.swing.JTextArea
*/
private JTextArea getJTextArea2() {
if (jTextArea2 == null) {
jTextArea2 = new JTextArea();
jTextArea2.setBounds(new Rectangle(22, 59, 704, 70));
}
return jTextArea2;
}
/**
* This method initializes jTextField9
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField9() {
if (jTextField9 == null) {
jTextField9 = new JTextField();
jTextField9.setBounds(new Rectangle(155, 134, 170, 26));
}
return jTextField9;
}
/**
* This method initializes jTextField10
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField10() {
if (jTextField10 == null) {
jTextField10 = new JTextField();
jTextField10.setBounds(new Rectangle(501, 134, 170, 26));
}
return jTextField10;
}
/**
* This method initializes jTextField11
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField11() {
if (jTextField11 == null) {
jTextField11 = new JTextField();
jTextField11.setBounds(new Rectangle(155, 166, 170, 26));
}
return jTextField11;
}
/**
* This method initializes jTextField12
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField12() {
if (jTextField12 == null) {
jTextField12 = new JTextField();
jTextField12.setBounds(new Rectangle(501, 166, 170, 26));
}
return jTextField12;
}
/**
* This method initializes jTextField13
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField13() {
if (jTextField13 == null) {
jTextField13 = new JTextField();
jTextField13.setBounds(new Rectangle(155, 199, 170, 26));
}
return jTextField13;
}
/**
* This method initializes jTextField14
*
* @return javax.swing.JTextField
*/
private JTextField getJTextField14() {
if (jTextField14 == null) {
jTextField14 = new JTextField();
jTextField14.setBounds(new Rectangle(501, 199, 170, 26));
}
return jTextField14;
}
/**
* This method initializes jButton6
*
* @return javax.swing.JButton
*/
private JButton getJButton6() {
if (jButton6 == null) {
jButton6 = new JButton();
jButton6.setBounds(new Rectangle(181, 245, 87, 30));
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_xg(e);
}
});
}
return jButton6;
}
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 readerInfo where code='"+jTextField8.getText()+"'");
if(rs.next())
{
String sql="update readerInfo set name='"+jTextField9.getText()+"',sex='"+jTextField10.getText()+"',type='"+jTextField11.getText()+"',phone='"+jTextField12.getText()+"',dept='"+jTextField13.getText()+"',address='"+jTextField14.getText()+"'" + "where code='"+jTextField8.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 jButton7
*
* @return javax.swing.JButton
*/
private JButton getJButton7() {
if (jButton7 == null) {
jButton7 = new JButton();
jButton7.setBounds(new Rectangle(352, 245, 87, 30));
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()
Button_fh(e);
}
});
}
return jButton7;
}
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() {
ReaderManage thisClass = new ReaderManage();
thisClass.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
thisClass.setVisible(true);
}
});
}
/**
* This method initializes this
*
* @return void
*/
private void initialize() {
this.setSize(754, 343);
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 + -