/**
* 查询最大工龄的员工姓名
* @return 员工姓名
*/publicStringqueryMax(){// 请补全sql语句String sql ="select * from account order by sage desc limit 1";Account a =JDBCUtil.getSingleResult(sql,Account.class);return a.getName();}
/**
* 更新所有人的年龄,男人加2,女人加1
*/publicvoidupdateAge(){// 请补全sql语句String sql ="update info set age=case when sex='男' then age+2 else age+1 end";JDBCUtil.executeSql(sql);}