接着上期JDBC基础(一)继续说
上期我们在db库中创建了一张user表
这期我们对表的数据进行操作(统一在JdbcBase类中操作)
一、插入数据操作
/**
* 执行插入数据操作
*/
@Test
public void insertDB() throws ClassNotFoundException, SQLException {
//1.加载驱动
Class.forName("com.mysql.jdbc.Driver");
//2.获取连接对象
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/db", "root", "950404");
//3.获取执行sql对象
Statement statement = connection.createStatement();
//4.编写sql
String sql = "insert into user values(null,18,'jeesoul')";
//5.执行sql语句(返回值为生效的行数)
int row = statement.executeUpdate(sql);
System.out.println(row);
}
二、查询操作
/**
* 查询操作
*/
@Test
public void selectDB() throws ClassNotFoundException, SQLException {
//1.加载驱动
Class.forName("com.mysql.jdbc.Driver");
//2.获取连接对象
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/db", "root", "950404");
//3.获取执行sql的对象
Statement statement = connection.createStatement();
//编写sql
String sql = "select * from user";
//执行sql(返回值为结果集)
ResultSet resultSet = statement.executeQuery(sql);
//读取结果集的内容
while (resultSet.next()){
int id = resultSet.getInt("id");
int age = resultSet.getInt("age");
String name = resultSet.getString("name");
System.out.println("id:"+id+","+"age:"+age+","+"name:"+name+"");
}
}
三、修改操作(将年龄修改为28岁)
/**
* 修改操作(将年龄修改成28岁)
*/
@Test
public void updateDB() throws ClassNotFoundException, SQLException {
//1.加载驱动
Class.forName("com.mysql.jdbc.Driver");
//2.获取连接对象
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/db", "root", "950404");
//3.获取执行sql的对象
Statement statement = connection.createStatement();
//4.编写sql
String sql = "update user set age=28 where age=18";
//5.执行sql语句(返回值为生效的行数)
int row = statement.executeUpdate(sql);
System.out.println(row);
}
四、删除数据的操作(同上修改操作)
小伙伴们,要不要自己动动手自己来一次(此处省略代码)