笔记如下
1.引入第三方类库
2018-02-23_115807.png
2.实现步骤
2018-02-23_115838.png
public class JdbcQuickStart {
@Test
public void test1() {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
//第一步:注册驱动
DriverManager.registerDriver(new Driver());
//建立连接
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/day15_jdbc","root","123456");
//第三步:获得可以发送sql语句的statement对象
stmt = conn.createStatement();
//第四步:执行sql语句,拿到结果集
rs = stmt.executeQuery("select * from users");
//第五步:解析结果集的数据
while(rs.next()) {
int id = rs.getInt("id");
String username = rs.getString("username");
String password = rs.getString("password");
String nickname = rs.getString("nickname");
System.out.println("id: "+id+",username: "+username+",nickname: "+nickname);
}
} catch (SQLException e) {
//第六步:释放资源,都会在finally释放
try {
conn.close();
stmt.close();
rs.close();
} catch (Exception e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
}
}
