一、加载数据库驱动
//以mysql为例
Class.forName("com.mysql.jdbc.Driver");
二、获取数据库连接
private static final String UR L= "jdbc:mysql://localhost:8080/db_test";
private static final String USENAME = "root";
private static final String PASSWORD = "root";
Connection conn = DriverManager.getConnection(URL,USERNAME,PASSWORD);
三、建立statement
//查询id为1的用户名密码
int id = 1;
String sql = "SELECT username,password FROM user WHERE id=?";
PrepareStatement ps = conn.prepareStatement(sql);
ps.serObject(1,id);
四、执行sql语句
ResultSet rs = ps.executeQuery();
五、处理结果集
while(rs.next()){
String username = rs.getString(1);
String password = rs.getString(2);
System.out.println("用户名:" + username);
System.out.println("密码:" + password);
}
六、关闭数据库连接
//按照创建顺序相反顺序关闭
rs.close();
ps.close();
conn.close();