?? addreaderinfo.java
字號:
package newLibrary;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.lang.*;
import java.sql.*;
public class AddReaderInfo extends JFrame
{
/**************聲明變量************/
private JPanel ContentPane;
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 sure = new JButton();
public AddReaderInfo()
{
this.setBounds(320,160,400,350);
this.setTitle("添加讀者信息");//窗體標題
ContentPane =(JPanel)this.getContentPane();//將容器轉化為JPanel
ContentPane.setLayout(null);//設置可更改性
ContentPane.setBackground(Color.LIGHT_GRAY);
/***************設置標簽的屬性*****************/
jlab1.setText("學號");
jlab1.setBounds(new Rectangle(30, 11, 51, 33));
jlab1.setForeground(Color.black);
jlab2.setText("姓名");
jlab2.setBounds(new Rectangle(162, 11, 28, 33));
jlab2.setForeground(Color.black);
jlab3.setText("性別");
jlab3.setBounds(new Rectangle(241, 11, 28, 33));
jlab3.setForeground(Color.black);
jlab4.setText("出生日期");
jlab4.setBounds(new Rectangle(31, 53, 55, 33));
jlab4.setForeground(Color.black);
jlab5.setText("政治面貌");
jlab5.setBounds(new Rectangle(241, 53, 55, 33));
jlab5.setForeground(Color.black);
jlab6.setText("籍貫");
jlab6.setBounds(new Rectangle(163, 53, 26, 33));
jlab6.setForeground(Color.black);
jlab7.setText("系別");
jlab7.setBounds(new Rectangle(30, 94, 50, 33));
jlab7.setForeground(Color.black);
jlab8.setText("專業");
jlab8.setBounds(new Rectangle(163, 94, 66, 33));
jlab8.setForeground(Color.black);
jlab9.setText("備 注");
jlab9.setBounds(new Rectangle(27, 132, 50, 33));
jlab9.setForeground(Color.black);
/****************設置文本框的屬性*****************/
jtextfield1.setText("");//學號
jtextfield1.setBounds(new Rectangle(86, 16, 74, 22));
jtextfield2.setText("");//姓名
jtextfield2.setBounds(new Rectangle(192, 16, 44, 22));
jtextfield3.setText("YY-MM-DD");//出生日期
jtextfield3.setBounds(new Rectangle(86, 58, 74, 22));
jtextfield4.setText("");//籍貫
jtextfield4.setBounds(new Rectangle(191, 58, 44, 22));
jtextfield5.setText("");//專業
jtextfield5.setBounds(new Rectangle(210, 99, 158, 22));
/********************添加下拉菜單的選象**********************/
jcombobox1.setBounds(new Rectangle(275, 15, 50, 25));
jcombobox1.addItem("男");
jcombobox1.addItem("女");
jcombobox1.setForeground(Color.black);
jcombobox1.setBackground(Color.white);
/***************添加下拉菜單的選象***************/
jcombobox2.setBounds(new Rectangle(296, 57, 72, 25));
jcombobox2.addItem("團員");
jcombobox2.addItem("黨員");
jcombobox2.addItem("群眾");
jcombobox2.setForeground(Color.black);
jcombobox2.setBackground(Color.white);
jcombobox3.setBounds(new Rectangle(86, 98, 75, 25));
/************添加下拉菜單的選象******************/
jcombobox3.addItem("計算機");
jcombobox3.addItem("經濟系");
jcombobox3.addItem("機電系");
jcombobox3.addItem("管理系");
jcombobox3.addItem("信息系");
jcombobox3.addItem("外語系");
jcombobox3.setForeground(Color.black);
jcombobox3.setBackground(Color.white);
jtextarea.setText("");
jtextarea.setBounds(new Rectangle(84, 139, 285, 92));
sure.setText("增加");//設置命令按鈕
sure.setBounds(new Rectangle(156, 244, 89, 22));
sure.addActionListener(new sure_actionperformed());//設置動作監聽
/**************把各個控件加到面板中去************/
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(sure);
this.setVisible(true);//設置可見性
}
class sure_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();
/***********建立記錄集并查詢輸入的學號和表中存在的記錄是不是一樣**************/
ResultSet rs = stmt.executeQuery("select * from StuInfo2 where 學號='"+ jtextfield1.getText() +"' ");
/*判斷指針并向下移動*/
if(rs.next())
{
//報告錯誤
JOptionPane.showMessageDialog(null, "此學號已經存在.", "警告",
JOptionPane.WARNING_MESSAGE);
return;
}
/***********將注冊信息寫到數據庫中去************/
stmt.executeUpdate("insert into StuInfo2(學號,系別,專業,姓名,性別,出生日期,籍貫,政治面貌,備注) values ('"+jtextfield1.getText()+"','"+jcombobox3.getSelectedItem()+"','"+jtextfield5.getText()+"','"+jtextfield2.getText()+"','"+jcombobox1.getSelectedItem()+"','"+jtextfield3.getText()+"','"+jtextfield4.getText()+"','"+jcombobox2.getSelectedItem()+"','"+jtextarea.getText()+"')");
/************注冊成功后并把信息清空*************/
jtextfield1.setText("");
jtextfield2.setText("");
jtextfield3.setText("");
jtextfield4.setText("");
jtextfield5.setText("");
jtextarea.setText("");
JOptionPane.showMessageDialog(null, "添加信息成功!");
BorrowerInfoWindow allinfo2 = new BorrowerInfoWindow();
}
catch (Exception ee)
{
JOptionPane.showMessageDialog(null, "請認真檢查各項(不能為空),\n日期格式要正確!然后重試.", "警告",
JOptionPane.WARNING_MESSAGE);
ee.printStackTrace();
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -