以用户密码表为例
一共分7个步骤:
1.获取驱动
Class.forName(“com.mysql.jdbc.Driver”);
- 创建连接
conn = DriverManager.getConnection(“jdbc:mysql://localhost:3306/java3?useSSL=true&characterEncoding=utf-8&user=root&password=123456”);
3.编写sql语句
String sql = “select * from user”;
4.获取对象
PrepareStatement pstm = conn.prepareStatement(“select * from user”);
5.执行并返回结果
ResultSet rs = pstm.executeQuery();
6.处理结果集
while (rs.next()){
System.out.println(“用户id为:”+rs.getInt(1));//该行结果的第一个参数
System.out.println(“用户名为:”+rs.getString(2));
System.out.println(“用户密码为:”+rs.getString(3));
}
7.关闭资源
rs.close();
pstm.close();
conn.close();