配置了数据源,在JDBC中怎么取到Connection,最好给我个代码例子

来源:百度知道 编辑:UC知道 时间:2024/06/30 10:18:05

看看这个符合你的要求不 记得改一些你的用户信息

import java.sql.*;
import java.sql.DriverManager;
import java.sql.SQLException;

public class TestJDBC {
public static void main(String args[]){
Connection con;
try {
System.out.println("正在连接数据库……");
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/fortest";
con = DriverManager.getConnection(url, "root", "root");
System.out.println("已连接到数据库");

Statement stmt = con.createStatement();

String query = "select id,name from student";
stmt.execute(query);
ResultSet rs = stmt.getResultSet();
while(rs.next()){
int i = rs.getInt(1);
String name = rs.getString(2);
System.out.println(Integer.toString(i)+" "+ name);

}
rs.close();
stmt.close();
co