/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
import java.awt.*;
import java.awt.event.*;
import java.sql.*;/**
*
* @author wzhg
*/
public class Stu { /**
* @param args the command line arguments
*/
public static void main (String[] args) {
new Student( );
// TODO code application logic here
}}
class Student extends Frame{
Panel p1;
Label l1,l2,l3,l4,l5,l6,l7,l8,l9;
TextField t1,t2,t3,t4,t5,t6,t7,t8,t9;
Button b1,b2,b3,b4;
Connection cn;
PreparedStatement ps;
String insert;
Student (){
try{
DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
cn = DriverManager.getConnection("jdbc:odbc.:Student");
insert = "INSERT INTO Student VALUSE(?,?,?,?,?,?,?,?)";
ps = cn.prepareStatement(insert);
}catch(SQLException e){ }
l1 = new Label("瀛﹀彿" );
l2 = new Label("濮撳悕" );
l3 = new Label("鎬у埆");
l4 = new Label("鍑虹敓鏃ユ湡");
l5 = new Label("瀹跺涵鍦板潃");
l6 = new Label("瀵濆鍙?);
l7 = new Label("鍩虹偣");
l8 = new Label("鑾峰娆℃暟");
l9 = new Label("鑻辫鍥涚骇");
t1 = new TextField(10);
t2 = new TextField(10);
t3 = new TextField(10);
t4 = new TextField(10);
t5 = new TextField(10);
t6 = new TextField(10);
t7 = new TextField(10);
t8 = new TextField(10);
t9 = new TextField(10);
b1 = new Button("鏇存柊");
b2 = new Button("鍒犻櫎");
b3 = new Button("娓呯┖");
b4 = new Button("鎼滅储");
p1 =new Panel( );
p1.add(l1);p1.add(t1);
p1.add(l2);p1.add(t2);
p1.add(l3);p1.add(t3);
p1.add(l4);p1.add(t4);
p1.add(l5);p1.add(t5);
p1.add(l6);p1.add(t6);
p1.add(l7);p1.add(t7);
p1.add(l8);p1.add(t8);
p1.add(l9);p1.add(t9);
add(p1);
setLayout(new FlowLayout( ));
b1.addActionListener(new Bt1());
b2.addActionListener(new Bt2());
b3.addActionListener(new Bt3());
b4.addActionListener(new Bt4());
setSize(500,200);
setVisible(true);
addWindowListener(new WinClose());
}
}
class Bt1 implements ActionListener{
public void actionPerFormed(ActionEvent e){
try{
ps.setInt(1,Integer.parseInt(t1.getText());
ps.executeUpdate();
}catch(Exception l1){
t1.requestFocus( );
}
}
}
class Bt2 implements ActionListener{
public void actionPerFormed(ActionEvent e){
}
}
class Bt3 implements ActionListener{
public void actionPerFormed(ActionEvent e){
try{
t1.setText("");
t2.setText("");
t3.setText("");
t4.setText("");
t5.setText("");
t6.setText("");
t7.setText("");
t8.setText("");
t9.setText("");
}catch(Except e){
t1.requestfocus();
}
}
}
class Bt4 implements ActionListener{ //这一行有问题不知道怎么做了。
public void actionPerFormed(ActionEvent e){
}
}
class WinClose extends WindowAdapter{
public void windowClosing(WindowEvevt e){
try {
cn.commit();
cn.close();
}catch(SQLException e){ };
(e.getWindow()).dispose();
System.exit(0);
}
}
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
import java.awt.*;
import java.awt.event.*;
import java.sql.*;/**
*
* @author wzhg
*/
public class Stu { /**
* @param args the command line arguments
*/
public static void main (String[] args) {
new Student( );
// TODO code application logic here
}}
class Student extends Frame{
Panel p1;
Label l1,l2,l3,l4,l5,l6,l7,l8,l9;
TextField t1,t2,t3,t4,t5,t6,t7,t8,t9;
Button b1,b2,b3,b4;
Connection cn;
PreparedStatement ps;
String insert;
Student (){
try{
DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
cn = DriverManager.getConnection("jdbc:odbc.:Student");
insert = "INSERT INTO Student VALUSE(?,?,?,?,?,?,?,?)";
ps = cn.prepareStatement(insert);
}catch(SQLException e){ }
l1 = new Label("瀛﹀彿" );
l2 = new Label("濮撳悕" );
l3 = new Label("鎬у埆");
l4 = new Label("鍑虹敓鏃ユ湡");
l5 = new Label("瀹跺涵鍦板潃");
l6 = new Label("瀵濆鍙?);
l7 = new Label("鍩虹偣");
l8 = new Label("鑾峰娆℃暟");
l9 = new Label("鑻辫鍥涚骇");
t1 = new TextField(10);
t2 = new TextField(10);
t3 = new TextField(10);
t4 = new TextField(10);
t5 = new TextField(10);
t6 = new TextField(10);
t7 = new TextField(10);
t8 = new TextField(10);
t9 = new TextField(10);
b1 = new Button("鏇存柊");
b2 = new Button("鍒犻櫎");
b3 = new Button("娓呯┖");
b4 = new Button("鎼滅储");
p1 =new Panel( );
p1.add(l1);p1.add(t1);
p1.add(l2);p1.add(t2);
p1.add(l3);p1.add(t3);
p1.add(l4);p1.add(t4);
p1.add(l5);p1.add(t5);
p1.add(l6);p1.add(t6);
p1.add(l7);p1.add(t7);
p1.add(l8);p1.add(t8);
p1.add(l9);p1.add(t9);
add(p1);
setLayout(new FlowLayout( ));
b1.addActionListener(new Bt1());
b2.addActionListener(new Bt2());
b3.addActionListener(new Bt3());
b4.addActionListener(new Bt4());
setSize(500,200);
setVisible(true);
addWindowListener(new WinClose());
}
}
class Bt1 implements ActionListener{
public void actionPerFormed(ActionEvent e){
try{
ps.setInt(1,Integer.parseInt(t1.getText());
ps.executeUpdate();
}catch(Exception l1){
t1.requestFocus( );
}
}
}
class Bt2 implements ActionListener{
public void actionPerFormed(ActionEvent e){
}
}
class Bt3 implements ActionListener{
public void actionPerFormed(ActionEvent e){
try{
t1.setText("");
t2.setText("");
t3.setText("");
t4.setText("");
t5.setText("");
t6.setText("");
t7.setText("");
t8.setText("");
t9.setText("");
}catch(Except e){
t1.requestfocus();
}
}
}
class Bt4 implements ActionListener{ //这一行有问题不知道怎么做了。
public void actionPerFormed(ActionEvent e){
}
}
class WinClose extends WindowAdapter{
public void windowClosing(WindowEvevt e){
try {
cn.commit();
cn.close();
}catch(SQLException e){ };
(e.getWindow()).dispose();
System.exit(0);
}
}
(java awt.event.ActionEvent)