?? frame_card_add.java~11~
字號:
package student_computer;import javax.swing.*;import java.awt.*;import java.awt.event.*;import java.sql.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2006</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class Frame_card_add extends JFrame { JLabel jLabel1 = new JLabel(); JPanel jPanel1 = new JPanel(); JLabel jLabel3 = new JLabel(); JTextField jstudent_num = new JTextField(); JLabel jLabel4 = new JLabel(); JTextField jstuent_name = new JTextField(); JLabel jLabel5 = new JLabel(); JComboBox jComboBox1 = new JComboBox(); JLabel jLabel6 = new JLabel(); JTextField jstudent_class = new JTextField(); JLabel jLabel7 = new JLabel(); JTextField jstudent_tel = new JTextField(); JButton jButton1 = new JButton(); JButton jButton2 = new JButton(); JLabel jLabel8 = new JLabel(); JTextField jmonney = new JTextField(); JLabel jLabel9 = new JLabel(); JTextField jcard = new JTextField(); JButton jButton3 = new JButton(); JLabel jLabel2 = new JLabel(); JTextField jdate = new JTextField(); public Frame_card_add() { try { jbInit(); } catch(Exception e) { e.printStackTrace(); } } private void jbInit() throws Exception { jLabel1.setFont(new java.awt.Font("Dialog", 0, 32)); jLabel1.setText("注冊卡號"); jLabel1.setBounds(new Rectangle(181, 20, 157, 57)); this.getContentPane().setLayout(null); jPanel1.setBorder(BorderFactory.createEtchedBorder()); jPanel1.setBounds(new Rectangle(40, 77, 447, 271)); jPanel1.setLayout(null); jLabel3.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel3.setBounds(new Rectangle(19, 24, 77, 28)); jstudent_num.setText(""); jstudent_num.setBounds(new Rectangle(99, 25, 110, 27)); jLabel4.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel4.setText("姓名："); jLabel4.setBounds(new Rectangle(229, 22, 54, 33)); jstuent_name.setText(""); jstuent_name.setBounds(new Rectangle(307, 25, 111, 26)); jLabel5.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel5.setText("性別："); jLabel5.setBounds(new Rectangle(19, 74, 58, 31)); jComboBox1.setBounds(new Rectangle(99, 77, 97, 24)); jLabel6.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel6.setText("班級："); jLabel6.setBounds(new Rectangle(229, 72, 78, 34)); jstudent_class.setText(""); jstudent_class.setBounds(new Rectangle(307, 75, 112, 28)); jLabel7.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel7.setText("聯系方式："); jLabel7.setBounds(new Rectangle(19, 131, 80, 28)); jstudent_tel.setText(""); jstudent_tel.setBounds(new Rectangle(99, 133, 111, 25)); jButton1.setBounds(new Rectangle(112, 363, 106, 35)); jButton1.setFont(new java.awt.Font("Dialog", 0, 16)); jButton1.setText("確定"); jButton1.addActionListener(new Frame_card_add_jButton1_actionAdapter(this)); jButton2.setBounds(new Rectangle(325, 365, 106, 35)); jButton2.setFont(new java.awt.Font("Dialog", 0, 16)); jButton2.setText("取消"); jButton2.addActionListener(new Frame_card_add_jButton2_actionAdapter(this)); jLabel8.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel8.setText("金額："); jLabel8.setBounds(new Rectangle(229, 128, 66, 34)); jmonney.setText(""); jmonney.setBounds(new Rectangle(307, 131, 111, 29)); jLabel9.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel9.setText("分配卡號："); jLabel9.setBounds(new Rectangle(19, 181, 89, 29)); jcard.setForeground(Color.black); jcard.setText(""); jcard.setBounds(new Rectangle(99, 183, 109, 25)); jButton3.setBounds(new Rectangle(236, 183, 80, 25)); jButton3.setText("自動生成"); jButton3.addActionListener(new Frame_card_add_jButton3_actionAdapter(this)); jLabel2.setFont(new java.awt.Font("Dialog", 0, 16)); jLabel2.setText("注冊日期: "); jLabel2.setBounds(new Rectangle(20, 229, 92, 28)); jdate.setText("2006-10-07"); jdate.setBounds(new Rectangle(100, 229, 110, 27)); jPanel1.add(jstudent_num, null); jPanel1.add(jLabel3, null); jPanel1.add(jLabel4, null); jPanel1.add(jstuent_name, null); jPanel1.add(jComboBox1, null); jPanel1.add(jLabel5, null); jPanel1.add(jLabel6, null); jPanel1.add(jstudent_class, null); jPanel1.add(jstudent_tel, null); jPanel1.add(jLabel7, null); jPanel1.add(jLabel8, null); jPanel1.add(jmonney, null); jPanel1.add(jcard, null); jPanel1.add(jLabel9, null); jPanel1.add(jButton3, null); jPanel1.add(jLabel2, null); jPanel1.add(jdate, null); this.getContentPane().add(jButton1, null); this.getContentPane().add(jButton2, null); this.getContentPane().add(jLabel1, null); this.getContentPane().add(jPanel1, null); this.setSize(540,430); this.setLocation(220,190); jComboBox1.addItem("男"); jComboBox1.addItem("女"); this.setTitle("卡號注冊"); }/////////////////添加學生和卡信息 void jButton1_actionPerformed(ActionEvent e) { String student_num=jstudent_num.getText().trim(); String student_name=jstuent_name.getText(); String student_sex=(String) jComboBox1.getSelectedItem(); String student_class=jstudent_class.getText(); String student_tel=jstudent_tel.getText(); String monney=jmonney.getText(); String card_num=jcard.getText(); String date=jdate.getText().trim(); if(student_num.equals("")||student_name.equals("")||student_sex.equals("")||student_class.equals("")||monney.equals("")||card_num.equals("")||date.equals("")) { JOptionPane.showMessageDialog(this,"信息填寫不完整!!!","提示",JOptionPane.PLAIN_MESSAGE); return; } try{ String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; String dbURL = "jdbc:microsoft:sqlserver://210.30.104.11:1433; DatabaseName=student_computer"; String userName = "xueli"; String userPwd = "gejingguo"; Class.forName(driverName); Connection con = DriverManager.getConnection(dbURL, userName, userPwd); //System.out.println(apartid+dom_id+date); PreparedStatement stmt=con.prepareStatement("insert into student values(?,?,?,?,?)"); //ResultSet rs=stmt.executeQuery(); stmt.setString(1,student_num); stmt.setString(2,student_name); stmt.setString(3,student_sex); stmt.setString(4,student_class); stmt.setString(5,student_tel); PreparedStatement stmt1=con.prepareStatement("insert into card values(?,?,?,?,?)"); //ResultSet rs=stmt.executeQuery(); stmt1.setString(1,card_num); stmt1.setString(2,student_num); float m=Float.parseFloat(monney); stmt1.setFloat(3,m); stmt1.setString(4,date); stmt1.setString(5,"正常"); int a=stmt.executeUpdate(); int b=stmt.executeUpdate(); if(a!=0&&b!=0) { JOptionPane.showMessageDialog(this,"注冊成功!!!","提示",JOptionPane.PLAIN_MESSAGE); return; } // stmt.setInt(1,apartid); }catch(Exception e1){e1.printStackTrace();} }///////////////自動分配卡號 void jButton3_actionPerformed(ActionEvent e) { try{ String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; String dbURL = "jdbc:microsoft:sqlserver://210.30.104.11:1433; DatabaseName=student_computer"; String userName = "xueli"; String userPwd = "gejingguo"; Class.forName(driverName); Connection con = DriverManager.getConnection(dbURL, userName, userPwd); //System.out.println(apartid+dom_id+date); Statement stmt=con.createStatement(); ResultSet rs=stmt.executeQuery("select max(Card_number) from card"); String cardid="0"; int id=0; while(rs.next()) { // cardid=rs.getString("Card_number").trim(); cardid=rs.getString(1); //System.out.print(cardid); id=Integer.parseInt(cardid)+1; } jcard.setText(new Integer(id).toString()); }catch(Exception e2){e2.printStackTrace();} }/////////////退出 void jButton2_actionPerformed(ActionEvent e) { this.show(false); }}class Frame_card_add_jButton1_actionAdapter implements java.awt.event.ActionListener { Frame_card_add adaptee; Frame_card_add_jButton1_actionAdapter(Frame_card_add adaptee) { this.adaptee = adaptee; } public void actionPerformed(ActionEvent e) { adaptee.jButton1_actionPerformed(e); }}class Frame_card_add_jButton3_actionAdapter implements java.awt.event.ActionListener { Frame_card_add adaptee; Frame_card_add_jButton3_actionAdapter(Frame_card_add adaptee) { this.adaptee = adaptee; } public void actionPerformed(ActionEvent e) { adaptee.jButton3_actionPerformed(e); }}class Frame_card_add_jButton2_actionAdapter implements java.awt.event.ActionListener { Frame_card_add adaptee; Frame_card_add_jButton2_actionAdapter(Frame_card_add adaptee) { this.adaptee = adaptee; } public void actionPerformed(ActionEvent e) { adaptee.jButton2_actionPerformed(e); }}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -