JDBC Demo
/*
create database day13;
use day13;
create table user(
id int primary key auto_increment,
name varchar(20),
password varchar(30)
);
insert into user values(null, 'zs','123');
insert into user values(null, 'lisi','456');
*
*/
public class JdbcDemo {
@Test
public void test1(){
// 加载 驱动: 导包 .
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null ;
try {
conn = JdbcUtils.getConnection();
stmt = conn.prepareStatement("select * from user");
rs = stmt.executeQuery();
while(rs.next()){
String name = rs.getString("name");
String password = rs.getString("password");
System.out.println( " name : " + name +", password : " + password);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
JdbcUtils.release(rs, stmt, conn);
}
}
}