createstudent.java

来自「基于数据库的基本应用问题」· Java 代码 · 共 24 行

import java.sql.*;
public class CreateStudent{
  public static void main(String args[]){
    String url="jdbc:odbc:mydata";
    String sql="create table student2(name VARCHAR(20),sex CHAR(2),birthday Date,leave BIT,stnumber INTEGER)";
    try{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }catch(java.lang.ClassNotFoundException e){
       System.err.println(e.getMessage());
    }
    try{
      Connection con=DriverManager.getConnection(url,"",null);
      Statement stmt=con.createStatement();
      try{
        stmt.executeUpdate(sql);
        System.out.println("student table created!");
      }catch(Exception ex){}
      stmt.close();
      con.close();
    }catch(SQLException ex){
       System.out.println("Message:"+ex.getMessage());
    }    
  }
}