DBUtil 增删改 （3）
来源：互联网 发布：龙之信条女性捏脸数据 编辑：程序博客网 时间：2024/06/05 17:48
package day20;import org.apache.commons.dbutils.DbUtils;import org.apache.commons.dbutils.QueryRunner;import com.mysql.jdbc.Connection;public class TestDML {public static void main(String[] args) throws Exception {//testInsert();//testUpdate();testDelete();}public static void testDelete() throws Exception{DBManager dbManager=new DBManager(); //获取连接 Connection conn=dbManager.getConnection();String sql="delete from students where id =?";//设置参数Object[] params=new Object[]{2};QueryRunner query=new QueryRunner();Object obj=query.update(conn, sql,params);System.out.println("obj=== "+obj);DbUtils.close(conn);}public static void testUpdate() throws Exception {DBManager dbManager=new DBManager(); //获取连接 Connection conn=dbManager.getConnection();String sql="update students set 姓名=?,专业=? where id =?";//设置参数Object[] params=new Object[]{"上官","计算机",2};QueryRunner query=new QueryRunner();Object obj=query.update(conn, sql,params);System.out.println("obj=== "+obj);DbUtils.close(conn);}public static void testInsert() throws Exception {//插入数据到PersonDBManager dbManager=new DBManager(); //获取连接 Connection conn=dbManager.getConnection();String sql="insert into students(姓名,专业,id,sex,email) values (?,?,?,?,?)";//设置参数Object[] params=new Object[]{"屌丝","计算机",8,"男","Hello@163.com"};QueryRunner query=new QueryRunner();Object obj=query.update(conn, sql,params);System.out.println("obj=== "+obj);DbUtils.close(conn);}}
