完成实体类 Student
public class Student {
private String name;//学生姓名
private String pwd;//学生密码
public Student(String name, String pwd) {
this.name = name;
this.pwd = pwd;
}
public Student() {
}
//已经提供Student类的属性,补充完成该类的有参(两个参数)及无参构造方法
完成工具类 DateUtil
/**
* 使用全局变量: sdf,将字符串转换为java.util.Date类型并返回
* 注意,不能声明任何形式的异常抛出,否则测试用例无法通过
* @param stringDate
* @return
*/
public static Date convertFromStringToDate(String stringDate) {
// 补全代码:
Date date = null;
try {
date = sdf.parse(stringDate);
} catch (ParseException e) {
e.printStackTrace();
}
return date;
}
/**
* 使用全局变量: sdf,将日期转换成字符串
* @param date 需要被转换的日期
* @return 转换之后的字符串形式的日期
*/
public static String convertFromDateToString(Date date) {
// 补全或替换代码
return sdf.format(date);
}
}
select * from book where name=?
select * from book where price=(select max(price) from book)
delete from student where name=?
select * from student where name=? and pwd=?
update student set pwd=? where name=?
insert into sb(sname,bname,begintime) values(?,?,?)
update book set num=num-1 where name=?
select * from sb where sname=? and bname=? and begintime=? and endtime is null
update sb set endtime=? where sname=? and bname=? and begintime=?
update book set num=num+1 where name=?