//增加数据
public int zengjia(User user){
   QueryRunner rq=new QueryRunner(MyDBCUtils.getDataSource());
   String sql="insert into user(pname,pwd) values(?,?)";
   int row=qr.update(sql,user.getPname,user.getPwd);
   return row;
}
//删除数据
public int shanchu(User user){
    QueryRunner qr=new QueryRunner(MyDBUtils.getDataSource());
    String sql="delete from sort where sid=?";
    int row=qr.update(sql,user.getSid);
    return row;
}
//查询数据常用的四种
//查询一行
public Sort chaxun1(int sid){
QueryRunner qr=new QueryRunner（MyDBCUtils.getDataSource()）;
String sql="select * from user where sid=?";
Sort sort=qr.query(sql,new BeanHandler<Sort>(Sort.class),sid);
return sort;
}
//将结果集中每一条记录封装到指定的javaBean中，将这些javaBean在封装到List集合中
public List<Sort> chaxun2(){
QueryRunner qr=new QueryRunner(MyDBCUtils.getDataSource());
String sql="select * from user";
List<Sort> list=qr.query(sql,new BeanListHandler<Sort>(Sort.class));
return list;
}
//查询一列，封装到集合中
public List<Sort> chaxun3(){
QueryRunner qr=new QueryRunner(MyDBCUtils.getDataSource());
String sql="select sname from user";
List<Sort> list=qr.query(sql,new ColumListHandler<Sort>());
return list;
}
//查询count（*）
public int chaxun4(){
QueryRunner qr=new QueryRunner(MyDBUtils.getDataSource());
String sql="select count(*) from user";
Long rs=qr.query(sql,new ScalarHandler<Long>());
int row=rs.intValue();
return row;

}