import java.sql.*;
public class sql1 {
public static void main(String[] args) {
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
String strTemp="";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e) {}
try {
con=DriverManager.getConnection("jdbc:odbc:student","","");
stmt=con.createStatement();
}catch(SQLException ee) {}
strTemp="CREATE TABLE student(id TEXT(20)PRIMARY KEY,name TEXT(20),gender TEXT(2),address TEXT(50),phone TEXT(20,major TEXT(30))";
try {
stmt.executeUpdate(strTemp);
}catch(SQLException e) {
e.printStackTrace();
}
strTemp="INSERT INTO student VALUES('2010001','张三','男','太原市迎泽西大街79号','13803511208','软件工程')";
try {
stmt.executeUpdate(strTemp);
}catch(SQLException e) {