?? readeru.java
字號:
//讀者資料修改條件
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.event.*;
import java.sql.*;
import java.io.*;
import java.util.*;
public class ReaderU extends JFrame implements ActionListener
{ private JLabel MoneyLabel,ViewLabel;
private JTextField MoneyTextField;
private JComboBox jcb;
private JButton ModifyBtn,CancelBtn;
private JPanel panel;
private JFrame frame;
private Connection con;
private Statement stmt;
private String yesORno;
private ReaderAdd reader;
public ReaderU(ReaderAdd reader)
{ JFrame.setDefaultLookAndFeelDecorated(true);
frame=new JFrame("讀者資料修改");
Font font1=new Font("宋體",Font.PLAIN,13);
Container content=frame.getContentPane();
content.setLayout(null);
ImageIcon icon=new ImageIcon("images/home.gif");
frame.setIconImage(icon.getImage());
frame.setResizable(false);
this.reader=reader;
//--初始化各個組件--
MoneyLabel=new JLabel("請輸入信息:");
ViewLabel=new JLabel("請選擇條件:");
String tiaojian[]={"讀者姓名","讀者編號","條形碼"};
jcb=new JComboBox(tiaojian);
MoneyTextField=new JTextField();
ModifyBtn=new JButton("查 詢");
CancelBtn=new JButton("取 消");
//--設置各個組件的事件--
ModifyBtn.addActionListener(this);
CancelBtn.addActionListener(this);
jcb.addActionListener(this);
//--設置各個組件的大小和位置--
MoneyLabel.setBounds(10,15,100,25);
MoneyTextField.setBounds(110,15,150,25);
ViewLabel.setBounds(10,50,100,25);
jcb.setBounds(110,50,150,25);
ModifyBtn.setBounds(40,90,80,25);
CancelBtn.setBounds(160,90,80,25);
//--設置各個組件的字體--
MoneyLabel.setFont(font1);
MoneyTextField.setFont(font1);
ViewLabel.setFont(font1);
ModifyBtn.setFont(font1);
CancelBtn.setFont(font1);
//--添加各個組件--
panel=new JPanel();
panel.setLayout(null);
panel.setBorder(
BorderFactory.createCompoundBorder(
BorderFactory.createEtchedBorder(),
BorderFactory.createLoweredBevelBorder()));
panel.setBounds(10,10,280,130);
panel.add(MoneyLabel);
panel.add(MoneyTextField);
panel.add(ViewLabel);
panel.add(jcb);
panel.add( ModifyBtn);
panel.add(CancelBtn);
content.add(panel);
//--初始化窗體--
frame.pack();
frame.setLocationRelativeTo(null);
frame.setBounds(400,150,305,180);
frame.setVisible(true);
}
public void actionPerformed(ActionEvent e)
{ Object obj=e.getSource();
if(obj==CancelBtn)
{ int m=JOptionPane.showConfirmDialog(this, "您確定要放棄修改讀者信息嗎？", "確認對話框",JOptionPane.YES_NO_OPTION);
if(m==JOptionPane.YES_OPTION)
{frame.dispose();}
}
if(obj== ModifyBtn)
{ try{ Update1();}
catch(SQLException ed){}
}
}
public void Update1() throws SQLException
{ String fajin=MoneyTextField.getText().trim();
int j,k;
String strurl =
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch (ClassNotFoundException e) {}
con= DriverManager.getConnection(strurl);
Statement stmt = con.createStatement();
ResultSet rs1 = stmt.executeQuery("select * from 讀者資料 ");
while(rs1.next())
{ String bookname=rs1.getString(1);
String bianhao=rs1.getString(2);
String bookcode=rs1.getString(3);
String fenlei=rs1.getString(4);
String zuozhe=rs1.getString(5);
String type=rs1.getString(6);
String zjhm=rs1.getString(7);
String price=rs1.getString(8);
String press=rs1.getString(9);
String page=rs1.getString(10);
String sheefname=rs1.getString(11);
String chuban=rs1.getString(12);
String ruku=rs1.getString(13);
String stock=rs1.getString(14);
String zuicang=rs1.getString(15);
String borrow=rs1.getString(16);
String status=rs1.getString(17);
String oparator=rs1.getString(18);
if(jcb.getSelectedIndex()==0)
{if(bookname.equals(fajin))
{reader.jtfd1.setText(bookname);reader.jtfd2.setText(bianhao);reader.jtfd3.setText(bookcode);
reader.jtfd5.setText(zjhm);reader.jtfd6.setText(price);
reader.jtfd7.setText(press);reader.jtfd9.setText(page);
reader.jtfd11.setText(sheefname);reader.jtfd12.setText(chuban);
reader.jtfd13.setText(ruku);reader.jtfd14.setText(stock);
reader.jtfd15.setText(zuicang);reader.jtfd16.setText(status);reader.jta.setText(oparator);
for(j=0;j<=reader.jtfd8.getItemCount();j++)
{if(zuozhe.equals((String)reader.jtfd8.getItemAt(j)))
{reader.jtfd8.setSelectedIndex(j);}
j++;
}
for(k=0;k<=reader.jtfd10.getItemCount();k++)
{if(type.equals((String)reader.jtfd10.getItemAt(k)))
{reader.jtfd10.setSelectedIndex(k);}
k++;
}
reader.btn5.setVisible(true);
reader.btn6.setVisible(false);
}
}
if(jcb.getSelectedIndex()==1)
{ if(bianhao.equals(fajin))
{reader.jtfd1.setText(bookname);reader.jtfd2.setText(bianhao);reader.jtfd3.setText(bookcode);
reader.jtfd5.setText(zjhm);reader.jtfd6.setText(price);reader.jtfd7.setText(press);
reader.jtfd9.setText(page);reader.jtfd11.setText(sheefname);reader.jtfd12.setText(chuban);
reader.jtfd13.setText(ruku);reader.jtfd14.setText(stock);
reader.jtfd15.setText(zuicang);reader.jtfd16.setText(status);reader.jta.setText(oparator);
for(j=0;j<=reader.jtfd8.getItemCount();j++)
{if(zuozhe.equals((String)reader.jtfd8.getItemAt(j)))
{reader.jtfd8.setSelectedIndex(j);}
j++;
}
for(k=0;k<=reader.jtfd10.getItemCount();k++)
{if(type.equals((String)reader.jtfd10.getItemAt(k)))
{reader.jtfd10.setSelectedIndex(k);}
k++;
}
reader.btn5.setVisible(true);
reader.btn6.setVisible(false);
}
}
if(jcb.getSelectedIndex()==2)
{ if(bookcode.equals(fajin))
{reader.jtfd1.setText(bookname);reader.jtfd2.setText(bianhao);reader.jtfd3.setText(bookcode);
reader.jtfd5.setText(zjhm);reader.jtfd6.setText(price);reader.jtfd7.setText(press);
reader.jtfd9.setText(page);reader.jtfd11.setText(sheefname);reader.jtfd12.setText(chuban);
reader.jtfd13.setText(ruku);reader.jtfd14.setText(stock);
reader.jtfd15.setText(zuicang);reader.jtfd16.setText(status);reader.jta.setText(oparator);
for(j=0;j<=reader.jtfd8.getItemCount();j++)
{if(zuozhe.equals((String)reader.jtfd8.getItemAt(j)))
{reader.jtfd8.setSelectedIndex(j);}
j++;
}
for(k=0;k<=reader.jtfd10.getItemCount();k++)
{if(type.equals((String)reader.jtfd10.getItemAt(k)))
{reader.jtfd10.setSelectedIndex(k);}
k++;
}
reader.btn5.setVisible(true);
reader.btn6.setVisible(false);
}
}
}
}
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -