jvav-web demo1
##mysql创建数据库代码
create database jdbctest;
use jdbctest;
create table user(
uid int primary key auto_increment,
username varchar(20),
password varchar(20),
name varchar(20)
);
insert into user values (null,'aaa','111','张三');
insert into user values (null,'bbb','222','李四');
insert into user values (null,'ccc','333','王五');
1 package com.imooc.jdbc.demo1; 2 3 import java.sql.Connection; 4 import java.sql.DriverManager; 5 import java.sql.ResultSet; 6 import java.sql.Statement; 7 8 import org.junit.Test; 9 10 public class JDBCDemo1 { 11 @Test 12 13 /** 14 * JDBCD入门程序 15 */ 16 public void demo1() { 17 18 try { 19 // 1.注册驱动 20 Class.forName("com.mysql.jdbc.Driver"); 21 22 // 2.获得链接 23 Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbctest", "root", "x5"); 24 25 // 3.创建执行SQL语句的对象,并执行SQL语句 26 // 3.1创建执行SQL语句的对象,并执行SQL语句 27 Statement stmt = conn.createStatement(); 28 29 String sql = "select * from user"; 30 31 // 3.2创建执行SQL语句 32 ResultSet rs = stmt.executeQuery(sql); 33 34 35 // 3.3遍历数据集 36 while(rs.next()){ 37 int uid = rs.getInt("uid"); 38 String username = rs.getString("username"); 39 String password = rs.getString("password"); 40 String name = rs.getString("name"); 41 42 System.out.println(uid+","+username+","+password+","+name); 43 } 44 45 // 4.释放资源 46 rs.close(); 47 stmt.close(); 48 conn.close(); 49 } catch (Exception e) { 50 // TODO Auto-generated catch block 51 e.printStackTrace(); 52 } 53 } 54 }
String password = rs.getString("password");
String name = rs.getString("name");
System.out.println(uid+","+username+","+password+","+name);
}
// 4.释放资源
rs.close();
stmt.close();
conn.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}