jsp+servlet+maven实现简单的学生信息增删改查

1.使用eclipse创建maven项目，引入依赖包

<dependencies>
		<dependency>
			<groupId>junit</groupId>
			<artifactId>junit</artifactId>
			<version>4.12</version>
			<scope>test</scope>
		</dependency>
		<!--mysql驱动包 -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>8.0.11</version>
		</dependency>
		<!-- 添加jstl依赖 Can not find the tag library descriptor for "http://java.sun.com/jsp/jstl/core" -->
		<dependency>
			<groupId>javax.servlet.jsp.jstl</groupId>
			<artifactId>javax.servlet.jsp.jstl-api</artifactId>
			<version>1.2.1</version>
		</dependency>
		<dependency>
			<groupId>org.apache.taglibs</groupId>
			<artifactId>taglibs-standard-impl</artifactId>
			<version>1.2.5</version>
		</dependency>

	</dependencies>
	<build>
		<finalName>epoint03</finalName>
		<defaultGoal>compile</defaultGoal>
	</build>
	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<maven.compiler.encoding>UTF-8</maven.compiler.encoding>
		<java.version>1.8</java.version>
		<maven.compiler.source>1.8</maven.compiler.source>
		<maven.compiler.target>1.8</maven.compiler.target>
	</properties>

 2.定义实体类：

//学生实体类
public class Student {
	private int sid;
	private String sname;
	private int sage;
	private String stel;
	private String sadrres;
	public Student() {
		super();
	}
	public Student(int sid, String sname, int sage, String stel, String sadrres) {
		super();
		this.sid = sid;
		this.sname = sname;
		this.sage = sage;
		this.stel = stel;
		this.sadrres = sadrres;
	}
	public int getSid() {
		return sid;
	}
	public void setSid(int sid) {
		this.sid = sid;
	}
	public String getSname() {
		return sname;
	}
	public void setSname(String sname) {
		this.sname = sname;
	}
	public int getSage() {
		return sage;
	}
	public void setSage(int sage) {
		this.sage = sage;
	}
	public String getStel() {
		return stel;
	}
	public void setStel(String stel) {
		this.stel = stel;
	}
	public String getSadrres() {
		return sadrres;
	}
	public void setSadrres(String sadrres) {
		this.sadrres = sadrres;
	}
	@Override
	public String toString() {
		return "Student [sid=" + sid + ", sname=" + sname + ", sage=" + sage + ", stel=" + stel + ", sadrres=" + sadrres
				+ "]";
	}
	
	
	

}

 

 3，封装一个连接数据库的jdbcutils工具类

//用于连接数据库的方法类
public class JDBCUtil {

 
	// 连接数据库
	public static Connection conData(Connection connection) {
		try {
			Class.forName("com.mysql.cj.jdbc.Driver");
		 	String url = "jdbc:mysql://localhost:3306/epoint01?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false";
			String user = "root";
			String password = "1234";
			connection = DriverManager.getConnection(url, user, password);

		} catch (ClassNotFoundException e) {

			e.printStackTrace();
		} catch (SQLException e) {

			e.printStackTrace();
		} finally {
			return connection;
		}
	}

//关闭方法
	public static void closeRes(Connection connection, PreparedStatement pst, ResultSet rs) {
		try {
			if (rs != null)
				rs.close();
			if (pst != null)
				pst.close();
			if (connection != null)
				connection.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

}

 

 4，写dao接口方法实现：

public interface StuDao {
	// 查找所有学生
	public List<Student> Findall();

	// 根据学生姓名跟电话查找学生
	public Student Findone(Student stu);

	// 增加学生
	public int Addone(Student stu);

	// 删除指定id的学生
	public int Delbyid(int sid);

	// 修改指定id的学生信息
	public int Updatebyid(Student stu);
   //根据id查找学生
	public Student Findbyid(int sid);
}
 
//方法实现类，用于连接数据库操作数据
public class StuDaoImp implements StuDao {
	Connection connection = null;
	PreparedStatement pst = null;
	ResultSet rs = null;

	// 查找所有学生
	public List<Student> Findall() {
		List<Student> l