JDBC Demo

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);
		}
		
	}
}