ex1.java

软件架构课程：JDBC与JAVA数据库程序设计

/*以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:TEST";
    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 namebook ( "
					  + "name char(8),"
					  + "gender char(4),"
					  + "age integer"
					  + ")";
	s.executeUpdate(query);  //执行SQL命令
	s.executeUpdate("insert into namebook(name,gender,age)" + "values('ken','m',22)");
	s.executeUpdate("insert into namebook(name,gender,age)" + "values('sky','m',23)");
	ResultSet rs=s.executeQuery("select * from namebook");
	while(rs.next())
	{
	  System.out.println(rs.getString(1)+rs.getString(2)+rs.getString(3));
	}
	s.executeUpdate("drop table namebook");
      //rs.close();
      s.close();
      con.close();
    }
   catch(SQLException e) 
    {
      System.out.println("SQLException: " +e.getMessage( ));
    }
  }
}