example10_1.java

书中的例题

import java.sql.*;  //引入java.sql包
public class Example10_1
{
 public static void main(String[ ] args)
  {
     //声明JDBC驱动程序对象
	String JDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; 
     //定义JDBC的URL对象,TestDB为数据源
	String conURL="jdbc:odbc:TestDB";
    try {
		//加载JDBC-ODBC桥驱动程序
      Class.forName(JDriver);  
    }
   catch(java.lang.ClassNotFoundException e) {
      System.out.println("ForName :" + e.getMessage( ));
    }
   try {
        //连接数据库URL
	  Connection con=DriverManager.getConnection(conURL);  
        //建立Statement类对象
	  Statement s=con.createStatement( );  
        //创建一个含有三个字段的学生表student
	  String query = "create table student ( " 
                      + "id char(10)," 
                      + "name char(15)," 
                      + "score integer"
                      + ")";  
      s.executeUpdate(query);  //执行SQL命令
        //释放Statement所连接的数据库及JDBC资源
	  s.close( );  
      //关闭与数据库的连线
	  con.close( );  
    }
   catch(SQLException e){
	  System.out.println("SQLException:"+e.getMessage( ));
	}
  }
}