test.java

来自「数据库 学生综合管理系统 实现了学生课程教师管理 及学生选课」· Java 代码 · 共 38 行

package test;
//导入Java SQL包，连接数据库必需； 
import java.sql.*; 

public class Test{ 
public static void main(String[] args) throws SQLException { 

String dbURL="jdbc:odbc:student"; 
String query="select * from student";
Statement stmt = null;
ResultSet rs = null;


String userName = "sa"; 
String userPwd = ""; 
Connection con;

try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 

con = DriverManager.getConnection(dbURL, userName, userPwd); 
System.out.println("Connection Successful!"); 
stmt = con.createStatement();
rs=stmt.executeQuery(query);
} 
catch(Exception e) { 
e.printStackTrace(); 
} while(rs.next()){
	System.out.println(rs.getString(1));
	System.out.println(rs.getString(2));
	
	
	
}

} 
}