?? chaxunframe.java
字號:
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class ChaXunFrame extends Frame implements ActionListener,ItemListener
{
TextField text1;
Label tiaojian_label,l1,l2;
CheckboxGroup cg;
Checkbox bian_hao,shu_ming,zuo_zhe,chu_ban_she;
Button que_ding_button,qu_xiao_button;
Connection conn;
Statement stmt;
ResultSet rs;
String strurl;
int n;
String SQL;
Label label1 = new Label("圖書編號");
Label label2 = new Label("書名");
Label label3 = new Label("作者");
Label label4 = new Label("出版社");
Label label5 = new Label("數量");
Label label6 = new Label("價格");
Label label7 =new Label();
TextField textField2 = new TextField();
TextField textField3 = new TextField();
TextField textField4 = new TextField();
TextField textField1 = new TextField();
TextField textField5 = new TextField();
TextField textField6 = new TextField();
Button button1 = new Button("上一個");
Button button2 = new Button("下一個");
public ChaXunFrame() throws Exception
{
super("圖書查詢窗口");
setSize(450,400);
setLayout(null);
this.setLocation(200,200);
setBackground(new Color(110,200,150));
addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent e){
dispose();
setVisible(false);
}
});
n=1;
button2.setBounds(219, 228, 89, 25);
button1.addActionListener(this);
button1.setBounds(68, 226, 83, 23);
button2.addActionListener(this);
textField6.setBounds(271, 169, 76, 20);
textField5.setBounds(271, 126, 76, 20);
textField1.setBounds(105, 86, 76, 20);
textField4.setBounds(271, 86, 76, 20);
textField3.setBounds(105, 170, 76, 20);
textField2.setBounds(105, 126, 76, 20);
label1.setBounds(45, 86, 57, 19);
label2.setBounds(45, 126, 57, 19);
label3.setBounds(45, 170, 57, 19);
label4.setBounds(210, 86, 53, 19);
label5.setBounds(210, 126, 57, 19);
label6.setBounds(210, 170, 57, 19);
label7.setBounds(68,250,83,40);
add(button1);
add(button2);
add(label1);
add(label2);
add(label7);
add(label3);
add(textField3);
add(textField2);
add(textField1);
add(label4);
add(label5);
add(label6);
add(textField6);
add(textField5);
add(textField4);
tiaojian_label=new Label("圖書編號");
tiaojian_label.setBounds(220,300,60,20);
l1=new Label("請選擇查詢條件");
l1.setBounds(50,270,80,20);
l2=new Label("請輸入查詢內容");
l2.setBounds(220,270,100,20);
text1=new TextField(10);
text1.setBounds(300,300,60,20);
que_ding_button=new Button("查詢");
que_ding_button.setBounds(220,350,60,20);
que_ding_button.addActionListener(this);
qu_xiao_button=new Button("刪除");
qu_xiao_button.setBounds(320,350,60,20);
qu_xiao_button.addActionListener(this);
cg=new CheckboxGroup();
bian_hao=new Checkbox("圖書編號",cg,true);
bian_hao.setBounds(50,300,60,20);
bian_hao.addItemListener(this);
shu_ming=new Checkbox("書名",cg,false);
shu_ming.setBounds(150,300,40,20);
shu_ming.addItemListener(this);
zuo_zhe=new Checkbox("作者",cg,false);
zuo_zhe.setBounds(50,350,40,20);
zuo_zhe.addItemListener(this);
chu_ban_she=new Checkbox("出版社",cg,false);
chu_ban_she.setBounds(150,350,60,20);
chu_ban_she.addItemListener(this);
add(bian_hao);add(shu_ming);
add(zuo_zhe);add(chu_ban_she);
add(label1);add(label2);
add(tiaojian_label);add(text1);
add(qu_xiao_button);
add(que_ding_button);
strurl ="jdbc:odbc:Library";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(strurl);
stmt = conn.createStatement();
setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
String str=e.getActionCommand();
if (str.equals("查詢"))
{
if(n==1){
if(text1.equals("")){
JOptionPane.showMessageDialog(null, "請至少輸入一個條件", "警告",
JOptionPane.WARNING_MESSAGE);
}
else{
try
{
rs = stmt.executeQuery("SELECT * FROM TSB where 圖書編號='"+text1.getText()+"'");
if(rs.next())
{
textField1.setText(rs.getString("圖書編號"));
textField2.setText(rs.getString("書名"));
textField3.setText(rs.getString("作者"));
textField4.setText(rs.getString("出版社"));
textField5.setText(rs.getString("數量"));
textField6.setText(rs.getString("價格"));
}
else{
JOptionPane.showMessageDialog(null, "記錄不存在", "警告",
JOptionPane.WARNING_MESSAGE);
}
}
catch (Exception eg) {
eg.printStackTrace();
}
}
}
if (n==2){
if(text1.equals("")){
JOptionPane.showMessageDialog(null, "請至少輸入一個條件", "警告",
JOptionPane.WARNING_MESSAGE);
}
else{
try
{
rs = stmt.executeQuery("SELECT * FROM TSB where 書名='"+text1.getText()+"'");
if(rs.next())
{
textField1.setText(rs.getString("圖書編號"));
textField2.setText(rs.getString("書名"));
textField3.setText(rs.getString("作者"));
textField4.setText(rs.getString("出版社"));
textField5.setText(rs.getString("數量"));
textField6.setText(rs.getString("價格"));
}
else{
JOptionPane.showMessageDialog(null, "記錄不存在", "警告",
JOptionPane.WARNING_MESSAGE);
}
}
catch (Exception eg) {
eg.printStackTrace();
}
}
}
if(n==3){
if(text1.equals("")){
JOptionPane.showMessageDialog(null, "請至少輸入一個條件", "警告",
JOptionPane.WARNING_MESSAGE);
}
else{
try
{
rs = stmt.executeQuery("SELECT * FROM TSB where 作者='"+text1.getText()+"'"); if(rs.next())
if(rs.next())
{
textField1.setText(rs.getString("圖書編號"));
textField2.setText(rs.getString("書名"));
textField3.setText(rs.getString("作者"));
textField4.setText(rs.getString("出版社"));
textField5.setText(rs.getString("數量"));
textField6.setText(rs.getString("價格"));
}
else{
JOptionPane.showMessageDialog(null, "記錄不存在", "警告",
JOptionPane.WARNING_MESSAGE);
}
}
catch (Exception eg) {
eg.printStackTrace();
}
}
}
if(n==4){
if(text1.equals("")){
JOptionPane.showMessageDialog(null, "請至少輸入一個條件", "警告",
JOptionPane.WARNING_MESSAGE);
}
else{
try
{
rs = stmt.executeQuery("SELECT * FROM TSB where 出版社='"+text1.getText()+"'");
if(rs.next())
{
textField1.setText(rs.getString("圖書編號"));
textField2.setText(rs.getString("書名"));
textField3.setText(rs.getString("作者"));
textField4.setText(rs.getString("出版社"));
textField5.setText(rs.getString("數量"));
textField6.setText(rs.getString("價格"));
}
else{
JOptionPane.showMessageDialog(null, "記錄不存在", "警告",
JOptionPane.WARNING_MESSAGE);
}
}
catch (Exception eg) {
eg.printStackTrace();
}
}
}
text1.setText("");
}
if(str.equals("下一個"))
{
try{
if(rs.next()){
textField1.setText(rs.getString("圖書編號"));
textField2.setText(rs.getString("書名"));
textField3.setText(rs.getString("作者"));
textField4.setText(rs.getString("出版社"));
textField5.setText(rs.getString("數量"));
textField6.setText(rs.getString("價格"));
}
}
catch (Exception eg) {
JOptionPane.showMessageDialog(null, "記錄不存在", "警告",
JOptionPane.WARNING_MESSAGE);
eg.printStackTrace();
}
}
if(str.equals("上一個"))
{
try{
if(rs.prior()){
textField1.setText(rs.getString("圖書編號"));
textField2.setText(rs.getString("書名"));
textField3.setText(rs.getString("作者"));
textField4.setText(rs.getString("出版社"));
textField5.setText(rs.getString("數量"));
textField6.setText(rs.getString("價格"));
}
}
catch (Exception eg) {
JOptionPane.showMessageDialog(null, "記錄不存在", "警告",
JOptionPane.WARNING_MESSAGE);
eg.printStackTrace();
}
}
if(str.equals("刪除"))
{
if(textField1.getText().equals("")){
JOptionPane.showMessageDialog(null, "記錄不存在", "警告",
JOptionPane.WARNING_MESSAGE);}
else{
try{
stmt.execute("DELETE * from TSB where 圖書編號='" + textField1.getText()+ "'");
JOptionPane.showMessageDialog(null, "刪除成功", "警告",
JOptionPane.WARNING_MESSAGE);
textField1.setText("");
textField2.setText("");
textField5.setText("");
textField6.setText("");
textField3.setText("");
textField4.setText("");
}
catch (Exception eg) {
JOptionPane.showMessageDialog(null, "記錄不存在", "警告",
JOptionPane.WARNING_MESSAGE);
eg.printStackTrace();
}
}
}
}
public void itemStateChanged(ItemEvent e)
{
if(e.getItemSelectable()==bian_hao)
{
tiaojian_label.setText("圖書編號");
n=1;
}
if(e.getItemSelectable()==shu_ming)
{
tiaojian_label.setText("書名");
n=2;
}
if(e.getItemSelectable()==zuo_zhe)
{
tiaojian_label.setText("作者");
n=3;
}
if(e.getItemSelectable()==chu_ban_she)
{
tiaojian_label.setText("出版社");
n=4;
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -