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