为什么jav用jdbc连接数据库找不到列。

Question

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class JdbeTest {
public static void main(String[] args) throws SQLException{
//1.注册驱动

    DriverManager.registerDriver(new com.mysql.jdbc.Driver());
    //2.获取连接
    Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/Mysql", "root", "362324FJF");
    //3.得到代表sql语句的对象
    Statement stat = conn.createStatement();
    //4.执行语句
    ResultSet rs = stat.executeQuery("select * from user");
    while(rs.next()){
        System.out.println(rs.getObject("id"));
        System.out.println(rs.getObject("salary"));
        System.out.println(rs.getObject("age"));
    }
    rs.close();
    stat.close();
    conn.close();

}

}

 我的数据库有创建user表
 select * from user;出来的结果是
 id salary age 
 1    2       3 
 4     8      6

Answer 1

把.注册驱动改成 ** Class.forName("com.mysql.jdbc.Driver");** 试试