用Servlset + JSP + JDBC 实现增删改查
先看看结构
entity是一个学生类,repository是一个与数据库交互的类,servlet与用户交互
关于idea里面连接数据库遇到的时区问题
好了进入正题
先看一下效果
准备一个学生类(展示少量代码)
public class Student {
private Integer id;
private String username;
public Student(Integer id, String username) {
this.id = id;
this.username = username;
}
准备一个工具类DBUtil用来快捷处理数据库连接
public class DBUtil {
//静态方法更方便
static Connection connection;
static String url = "jdbc:mysql://localhost:3306/student?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai";
static String user = "root";
static String password = "123456";
static{
try {
Class.forName("com.mysql.cj.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection(){
try {
connection = DriverMan