test.java

来自「java通过连接池访问数据库.提供的数据库MYSQL,ACCESS,SQL」· Java 代码 · 共 36 行

import java.sql.*;
import java.util.*;

public class test{
	public static void main(String[] args) {
		
		//Connection con=null;
		DBConnManager ma= new DBConnManager();
		Connection con = ma.getConnection("mysql");
		try{
			
			Statement stmt = con.createStatement();
			ResultSet rs=stmt.executeQuery("select * from student_course");
			while(rs.next())
			{
				System.out.println(rs.getString("no"));
			}
		}catch(Exception e){
			System.out.println(e.toString());
		}
/*		DBConnManager ma= new DBConnManager();
		con = ma.getConnection("access");
		try{
			Statement stmt = con.createStatement();
			ResultSet rs=stmt.executeQuery("select * from Users");
			while(rs.next())
			{
				System.out.println(rs.getString("UserID"));
			}
		}catch(Exception e){
			System.out.println(e.toString());
		}*/
	}
}