import java.sql.*;
//我的第一个jdbc程序
public class jdbc01demo {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//加载驱动
Class.forName("com.mysql.jdbc.Driver"); //固定写法
//连接信息
String url = "jdbc:mysql://localhost:3306/jdbcstudy?useUnicode=true&characterEncoding=utf8&useSSL=true";
String username = "root";
String password = "198337";
//连接成功 Connection 代表数据库
Connection connection = DriverManager.getConnection(url, username, password);
//执行sql的对象
Statement statement = connection.createStatement();
//执行sql
String sql = "SELECT * FROM users";
ResultSet resultSet = statement.executeQuery(sql); //返回的结果 结果集中封装了全部的查询结果
while (resultSet.next()){
System.out.println("id="+resultSet.getObject("id"));
System.out.println("name="+resultSet.getObject("NAME"));
System.out.println("password="+resultSet.getObject("PASSWORD"));
System.out.println("email="+resultSet.getObject("email"));
System.out.println("birth="+resultSet.getObject("birthday"));
}
//释放连接
resultSet.close();
statement.cancel();
connection.close();
}
}