dbutil，mybatise以及正常数据库操作

正常处理数据库查到的数据

			conn = DaoFactory.GetgetDBConn().getConn();
			st = conn.createStatement();
			rs = st.executeQuery("select * from product");
			while (rs.next()) {   //rs.next()表示从查询到的数据中取一条
				Product product = new Product();
				product.setId(rs.getInt("id"));
				product.setName(rs.getString("name"));
				product.setIntroduce(rs.getString("introduce"));
				product.setNumber(rs.getInt("number"));
				product.setNewPrize(rs.getDouble("new_prize"));
				product.setBandType(rs.getString("band_type"));
				product.setOldPrize(rs.getDouble("old_prize"));
				product.setPicture(rs.getString("picture"));
				product.setPricetype(rs.getString("pricetype"));
				product.setSportType(rs.getString("sport_type"));
				product.setType(rs.getInt("type"));
				//user.setNumber(rs.getString("number"));
				//user.setXihuan(rs.getString("xihuan"));
				//user.setUserstate(rs.getString("userstate"));
				list.add(product);

dbutil处理数据

ResultSetHandler<List<Product>> resultHandler = new BeanListHandler<Product>(Product.class);
	    List<Product> list1 = new ArrayList();
		//获取数据库连接
		GetDBConn getDBConn = DaoFactory.GetgetDBConn();
		Connection conn = getDBConn.getConn();
		if(conn!=null) {
			QueryRunner runner = new QueryRunner();
			try {
				List<Product> productList = runner.query(conn, "SELECT * FROM product where name=?", resultHandler,uname);
				//System.out.println(productList);
				for(Product pro: productList ) {
		            //Display values
					Product product = new Product();
					product.setId(pro.getId());
					product.setName(pro.getName());
					product.setIntroduce(pro.getIntroduce());
					product.setNumber(pro.getNumber());
					product.setNewPrize(pro.getNewPrize());
					product.setBandType(pro.getBandType());
					product.setOldPrize(pro.getOldPrize());
					product.setPicture(pro.getPicture());
					product.setPricetype(pro.getPricetype());
					product.setSportType(pro.getSportType());
					product.setType(pro.getType());
					//System.out.println(product);
					list1.add(product);
		         } 
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
//			释放资源
			DbUtils.closeQuietly(conn);
		}
		System.out.println(list1);
		return list1;

写删除的sql语句时

int row = runner.update(conn, "delete from product where id=?",id);//注意delete后没有*，id后面有？和,id
				if(row>0){
					flag = true;
				}