ex1.java

来自「软件架构课程：JDBC与JAVA数据库程序设计」· Java 代码 · 共 36 行

/*以JDBC-ODBC桥接的方式访问SQL SERVER 2000数据库*/
/*CNDDB是数据源*/
import java.sql.*;
public class Ex1
{  
  public static void main(String[ ] args)
   {
    String JDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
    String conURL="jdbc:odbc:CNDDB";
    try {
      Class.forName(JDriver);
    }
   catch(java.lang.ClassNotFoundException e) {
      System.out.println("ForName :" + e.getMessage( ));
    }
   try {
      Connection con=DriverManager.getConnection(conURL);
      Statement s=con.createStatement();
	  //创建一个含有三个字段的学生表student
	  String query = "create table stu1 ( "
					  + "id char(10),"
					  + "name char(15),"
					  + "score integer"
					  + ")";
	  s.executeUpdate(query);  //执行SQL命令
      s.close( );
      con.close( );
    }
   catch(SQLException e) 
    {
      System.out.println("SQLException: " +e.getMessage( ));
    }
  }
}