增删改查

一、插入数据
  @Test
  public void insert() throws SQLException{
    QueryRunner queryRunner = new QueryRunner(C3P0Utils.getDataSource());
    String sql ="INSERT INTO product VALUES(6,'米饭',0.2)";
    int insert = queryRunner.update(sql);
    System.out.println("成功插入"+ insert +"条");
  }二、查询
@Test
  public void select() throws SQLException{
    QueryRunner query = new QueryRunner(C3P0Utils.getDataSource());
    String sql= "select * from product";
    List<Product> dt =  query.query(sql,new BeanListHandler<Product>(Product.class));
    System.out.println(dt);
  }三、修改
@Test
  public void update4() throws SQLException{
    QueryRunner queryrunner = new QueryRunner(C3P0Utils.getDataSource());
    String sql = "update product set pname='老三',price=12232 where pid=4";
    int update = queryrunner.update(sql);
    System.out.println("成功修改"+update+"条");
  } 
四、删除
 
@Test
  public void delete() throws SQLException{
    QueryRunner run = new QueryRunner(C3P0Utils.getDataSource());
    String sql2 = "delete from  product where pid=? ";
    Object [] parmes = {2};
    int re = run.update(sql2,parmes);
    System.out.println(re);
  }@test：代替main方法