insertstudent.java

基于数据库的基本应用问题

import java.sql.*;
public class InsertStudent{
  public static void main(String args[]){
    String url="jdbc:odbc:mydata";
    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();
      String sql="INSERT INTO student2 VALUES('John','M',DateValue('74/12/03'),True,20010845)";
      stmt.executeUpdate(sql);
      sql="INSERT INTO student2 VALUES('Mary','F',DateValue('77/03/05'),True,20040745)";
      stmt.executeUpdate(sql);
      sql="INSERT INTO student2 VALUES('Jack','M',DateValue('73/11/12'),True,20010846)";
      stmt.executeUpdate(sql);
      sql="INSERT INTO student2 VALUES('Rose','F',DateValue('78/09/26'),True,20040746)";
      stmt.executeUpdate(sql);
      System.out.println("4 Items have been inserted!");      
      stmt.close();
      con.close();
    }catch(SQLException ex){
       System.out.println("Message:"+ex.getMessage());
    }    
  }
}