?? findborrowerdialog.java
字號:
package newLibrary;
import java.awt.Color;
import java.awt.Font;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextArea;
import javax.swing.JTextField;
public class FindBorrowerDialog extends JFrame
{
/**************聲明變量************/
String strurl;
Connection conn;
Statement stmt;
ResultSet rs;
private JPanel ContentPane;
private JLabel jlabNum = new JLabel();//學號
private JLabel jlabName = new JLabel();//姓名
private JLabel jlabChoice = new JLabel();
private JTextField jtextfieldNum = new JTextField();
private JTextField jtextfieldName = new JTextField();
private JButton jsure = new JButton();
private JLabel jlab1 = new JLabel();//學號
private JLabel jlab2 = new JLabel();//姓名
private JLabel jlab3 = new JLabel();//性別
private JLabel jlab4 = new JLabel();//出生日期
private JLabel jlab5 = new JLabel();//政治面貌
private JLabel jlab6 = new JLabel();//籍貫
private JLabel jlab7 = new JLabel();//系別
private JLabel jlab8 = new JLabel();//專業
private JLabel jlab9 = new JLabel();//備注
private JTextField jtextfield1 = new JTextField();//學號
private JTextField jtextfield2 = new JTextField();//姓名
private JTextField jtextfield3 = new JTextField();//出生日期
private JTextField jtextfield4 = new JTextField();//籍貫
private JTextField jtextfield5 = new JTextField();//專業
private JComboBox jcombobox1 = new JComboBox();//性別
private JComboBox jcombobox2 = new JComboBox();//政治面貌
private JComboBox jcombobox3 = new JComboBox();//系別
private JTextArea jtextarea = new JTextArea();//備注
//private JButton jnext2 = new JButton();
/***************聲明方法***************/
public FindBorrowerDialog()
{
ContentPane = (JPanel)this.getContentPane();
ContentPane.setLayout(null);
this.setTitle("讀者信息查詢");
this.setBounds(320,160,400,350);
ContentPane.setBackground(Color.LIGHT_GRAY);
/*設置查詢界面的第一步*/
jlabNum.setText("學號");
jlabNum.setVisible(true);
jlabNum.setBounds(new Rectangle(124, 86, 28, 16));
jlabNum.setForeground(Color.black);
jlabName.setText("姓名");
jlabName.setVisible(true);
jlabName.setBounds(new Rectangle(124, 130, 28, 16));
jlabName.setForeground(Color.black);
jlabChoice.setText("請你選擇查詢條件");
jlabChoice.setFont(new Font("Dialog", 1, 20));
jlabChoice.setForeground(Color.black);
jlabChoice.setVisible(true);
jlabChoice.setBounds(new Rectangle(115, 36, 200, 30));
jtextfieldNum.setText("");
jtextfieldNum.setBounds(new Rectangle(177, 83, 83, 22));
jtextfieldNum.setVisible(true);
jtextfieldName.setText("");
jtextfieldName.setBounds(new Rectangle(178, 127, 83, 22));
jtextfieldName.setVisible(true);
jsure.setText("確定");
jsure.setVisible(true);
jsure.setBounds(new Rectangle(177, 177, 73, 22));
jsure.addActionListener(new button_actionPerformed());
/*顯示學生詳細信息的界面*/
jlab1.setText("學號");
jlab1.setVisible(false);
jlab1.setBounds(new Rectangle(30, 11, 51, 33));
jlab1.setForeground(Color.white);
jlab2.setText("姓名");
jlab2.setVisible(false);
jlab2.setBounds(new Rectangle(162, 11, 28, 33));
jlab2.setForeground(Color.white);
jlab3.setText("性別");
jlab3.setVisible(false);
jlab3.setBounds(new Rectangle(241, 11, 28, 33));
jlab3.setForeground(Color.white);
jlab4.setText("出生日期");
jlab4.setVisible(false);
jlab4.setBounds(new Rectangle(31, 53, 55, 33));
jlab4.setForeground(Color.white);
jlab5.setText("政治面貌");
jlab5.setVisible(false);
jlab5.setBounds(new Rectangle(241, 53, 55, 33));
jlab5.setForeground(Color.white);
jlab6.setText("籍貫");
jlab6.setVisible(false);
jlab6.setBounds(new Rectangle(163, 53, 26, 33));
jlab6.setForeground(Color.white);
jlab7.setText("系 別");
jlab7.setVisible(false);
jlab7.setBounds(new Rectangle(30, 94, 50, 33));
jlab7.setForeground(Color.white);
jlab8.setText("專業");
jlab8.setVisible(false);
jlab8.setBounds(new Rectangle(163, 94, 66, 33));
jlab8.setForeground(Color.white);
jlab9.setText("備 注");
jlab9.setVisible(false);
jlab9.setBounds(new Rectangle(27, 132, 50, 33));
jlab9.setForeground(Color.white);
jtextfield1.setText("");//學號
jtextfield1.setVisible(false);
jtextfield1.setBounds(new Rectangle(86, 16, 74, 22));
jtextfield2.setText("");//姓名
jtextfield2.setVisible(false);
jtextfield2.setBounds(new Rectangle(192, 16, 44, 22));
jtextfield3.setText("");//出生日期
jtextfield3.setVisible(false);
jtextfield3.setBounds(new Rectangle(86, 58, 74, 22));
jtextfield4.setText("");//籍貫
jtextfield4.setVisible(false);
jtextfield4.setBounds(new Rectangle(191, 58, 44, 22));
jtextfield5.setText("");//專業
jtextfield5.setVisible(false);
jtextfield5.setBounds(new Rectangle(210, 99, 158, 22));
/********************添加下拉菜單的選象**********************/
jcombobox1.setBounds(new Rectangle(275, 15, 50, 25));
jcombobox1.setVisible(false);
jcombobox1.addItem("男");
jcombobox1.addItem("女");
jcombobox1.setForeground(Color.black);
jcombobox1.setBackground(Color.white);
/***************添加下拉菜單的選象***************/
jcombobox2.setBounds(new Rectangle(296, 57, 72, 25));
jcombobox2.setVisible(false);
jcombobox2.addItem("黨員");
jcombobox2.addItem("團員");
jcombobox2.addItem("其他");
jcombobox2.setForeground(Color.black);
jcombobox2.setBackground(Color.white);
/************添加下拉菜單的選象******************/
jcombobox3.setBounds(new Rectangle(86, 98, 75, 25));
jcombobox3.setVisible(false);
jcombobox3.addItem("計算機");
jcombobox3.addItem("經濟系");
jcombobox3.addItem("機電系");
jcombobox3.addItem("管理系");
jcombobox3.addItem("信息系");
jcombobox3.addItem("外語系");
jcombobox3.setForeground(Color.black);
jcombobox3.setBackground(Color.white);
jtextarea.setText("");
jtextarea.setVisible(false);
jtextarea.setBounds(new Rectangle(84, 139, 285, 92));
/***********將控件添加到面板中去********/
ContentPane.add(jlabNum);
ContentPane.add(jlabName);
ContentPane.add(jlabChoice);
ContentPane.add(jtextfieldNum);
ContentPane.add(jtextfieldName);
ContentPane.add(jsure);
/**************把各個控件加到面板中去************/
ContentPane.add(jlab1);
ContentPane.add(jlab2);
ContentPane.add(jlab3);
ContentPane.add(jlab4);
ContentPane.add(jlab5);
ContentPane.add(jlab6);
ContentPane.add(jlab7);
ContentPane.add(jlab8);
ContentPane.add(jlab9);
/**************將文本框加到面板中去***********/
ContentPane.add(jtextfield1);
ContentPane.add(jtextfield2);
ContentPane.add(jtextfield3);
ContentPane.add(jtextfield4);
ContentPane.add(jtextfield5);
/************將下拉框添加到面板中***********/
ContentPane.add(jcombobox1);
ContentPane.add(jcombobox2);
ContentPane.add(jcombobox3);
/**************將文本區域和命令按鈕添加************/
ContentPane.add(jtextarea);
//ContentPane.add(jnext2);
this.setVisible(true);
}
/****************設置動作按鈕的監聽**********/
class button_actionPerformed implements ActionListener
{
public void actionPerformed(ActionEvent e)
{
try
{
/****************連接數據庫(JDBC)******************/
String strurl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=student.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(strurl);
Statement stmt = conn.createStatement();
/**********對命令按鈕進行判斷*********/
if(e.getSource()==jsure)
{
/********對文本框中的值進行判斷******/
if(jtextfieldNum.getText().trim().equals("")||jtextfieldName.getText().trim().equals(""))
{
/*************按照或查詢**********8*/
rs = stmt.executeQuery("select * from StuInfo2 where 學號='"+jtextfieldNum.getText()+"' or 姓名='"+jtextfieldName.getText()+"'");
}
else if(jtextfieldNum.getText().trim().equals("")&&jtextfieldName.getText().trim().equals(""))
{
/***********按照與查詢***********/
JOptionPane.showMessageDialog(null, "請至少輸入一個條件", "警告",JOptionPane.WARNING_MESSAGE);
}
else
rs = stmt.executeQuery("select * from StuInfo2 where 學號='"+jtextfieldNum.getText()+"' and 姓名='"+jtextfieldName.getText()+"'");
/***********如果記錄集中存在***********/
if(rs.next())
{
/******設置各個標簽的可見性*****/
jlabNum.setVisible(false);
jlabName.setVisible(false);
jsure.setVisible(false);
jlabChoice.setVisible(false);
jtextfieldNum.setVisible(false);
jtextfieldName.setVisible(false);
jlab1.setVisible(true);//學號
jlab2.setVisible(true);//姓名
jlab3.setVisible(true);//性別
jlab4.setVisible(true);//出生日期
jlab5.setVisible(true);//政治面貌
jlab6.setVisible(true);//籍貫
jlab7.setVisible(true);//系別
jlab8.setVisible(true);//專業
jlab9.setVisible(true);//備注
/*****各個標簽中得到查詢的相應結果*****/
jtextfield1.setVisible(true);//學號
jtextfield1.setText(rs.getString("學號"));
jtextfield1.enable(false);
jtextfield2.setVisible(true);//姓名
jtextfield2.setText(rs.getString("姓名"));
jtextfield3.setVisible(true);//出生日期
jtextfield3.setText((rs.getString("出生日期")).substring(0,10));
jtextfield4.setVisible(true);//籍貫
jtextfield4.setText(rs.getString("籍貫"));
jtextfield5.setVisible(true);//專業
jtextfield5.setText(rs.getString("專業"));
/**************下拉列表框的相關設置*********/
//下拉列表框中無法顯示從數據庫中讀出的數據
jcombobox1.setVisible(true);//性別
String sex1=rs.getString("性別");
jcombobox1.setSelectedItem(sex1);
jcombobox2.setVisible(true);//政治面貌
String zhengzhimianmao=rs.getString("政治面貌");
jcombobox2.setSelectedItem(zhengzhimianmao);
jcombobox3.setVisible(true);//系別
String xibie=rs.getString("系別");
jcombobox3.setSelectedItem(xibie);
// jcombobox3.enable(false);
jtextarea.setVisible(true);
jtextarea.setText(rs.getString("備注"));
// jtextarea.enable(false);
}
else
JOptionPane.showMessageDialog(null, "無此條件對應信息", "警告",
JOptionPane.WARNING_MESSAGE);
}
}
catch (Exception ee)
{
ee.printStackTrace();
}
}
}
/*public static void main(String args[])
{
new FindBorrowerDialog();
}*/
}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -