原来代码
package com.fan;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class SelectTest {
public static void main(String[] args) throws Exception {
// 加载驱动
Class.forName("com.mysql.jdbc.Driver");
// 获取连接
String url = "jdbc:mysql://localhost:3306/jdbc_jiaguwen";
String name = "root";
String password = "";
Connection conn = DriverManager.getConnection(url, name, password);
System.out.println("数据库连接成功");
// 创建声明
Statement s = conn.createStatement();
String sql = "SELECT * FROM 学生";
System.out.println("打印sql: " + sql);
ResultSet resultSet = s.executeQuery(sql);
System.out.println("执行sql语句");
// 遍历结果集
while (resultSet.next()) {
String id = resultSet.getString("学生_id");
String names = resultSet.getString("姓名