testjdbc_1b.java

黑魔方JSP基础教程源代码(耿祥义编著)是这里有课件和jsp源代码

//TestJDBC_1.java
import java.sql.*;
public class TestJDBC_1b{ 
public static void main(String[] args) {
String  jdbcDriver="sun.jdbc.odbc.JdbcOdbcDriver";  	// 数据库驱动
String  jdbcURL="jdbc:odbc:cjb2"; 	 // 数据源
try{
Class.forName(jdbcDriver);  //注册驱动程序 
Connection con = DriverManager.getConnection(jdbcURL);  
Statement stmt = con.createStatement();
ResultSet  rs  =  stmt.executeQuery("select * from cjb2");
System.out.println("-------------------------------------------------");
while(rs.next()){
System.out.print("  学号：" + rs.getString(1));
System.out.print("  姓名：" + rs.getString(2)+ "\t");
System.out.print("  数学成绩：" + rs.getString(3));
System.out.print("  英语成绩：" + rs.getInt(4));
System.out.println();
}
rs.close();
stmt.close();
con.close();
System.out.println("-------------------------------------------------");
System.out.print("Test OK!");
} catch(ClassNotFoundException e){
System.out.println("未找到要加载的驱动类");
} catch(SQLException e) {
System.out.println("SQL错误提示：" + e);
}
}	
}