初学servlet——学生管理系统

  前端小项目，登录增删改查分页隔行变色

  记得需要导入一下jar包： jstl.jar

                                           mysql-connector-java-（版本号，我使用的是8.0.27）.jar

                                           standard.jar

  这三个包放在WEB-INF下的lib里面

数据库名：myschool，管理员表：admin，学生表：student，详细数据在最下方。

感谢收看

  JdbcUtil，工具类

package cn.bdqn.util;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;


public class JdbcUtil {

	private static String url;
	private static String user;
	private static String password;

	
	static {
		try {
			Class.forName("com.mysql.cj.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		initer();
	}
	
	public static void initer() {
		Properties properties = new Properties();
		InputStream is = JdbcUtil.class.getClassLoader().getResourceAsStream("JdbcUtil.properties");
		try {
			properties.load(is);
			url = properties.getProperty("url");
			user = properties.getProperty("user");
			password = properties.getProperty("password");
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
	
	public static Connection getconnection() {
		Connection conn = null;
		try {
			conn = DriverManager.getConnection(url, user, password);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return conn;
	}

	public static void closeconnection(Statement stmt,Connection conn) {
		if(stmt!=null) {
			try {
				stmt.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}			
		}
		if(conn!=null) {
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}			
		}
	}
}

JdbcUtil.properties

url = jdbc:mysql://localhost:3306/myschool?characterEncoding = utf8
user = root
password = root

Dao层

管理员Admin登录

package cn.bdqn.dao;

import cn.bdqn.entity.Admin;

public interface AdminDao {
Admin getAdmin(String username,String password);
}

BaseDao

package cn.bdqn.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import cn.bdqn.util.JdbcUtil;

public class BaseDao {
	public void update(String sql, Object[] paramas) {
		Connection conn = JdbcUtil.getconnection();
		PreparedStatement pstmt = null;

		try {
			pstmt = conn.prepareStatement(sql);
			for (int i = 0; i < paramas.length; i++) {
				pstmt.setObject(i + 1, paramas[i]);
			}
			pstmt.executeUpdate();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}

StudentDao

package cn.bdqn.dao;

import java.util.List;

import cn.bdqn.entity.Student;

public interface StudentDao {
List<Student> liststudents();

void addstudent(Student student);

Student getStudent(int id);

void updateStudent(Student student);

void deleteStudent(int id);

List<Student> listStudents(int pageIndex,int pageSize);

int listStudentsCount();
}

DaoImpl

AdminDaoImpl

package cn.bdqn.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import cn.bdqn.dao.AdminDao;
import cn.bdqn.dao.BaseDao;
import cn.bdqn.entity.Admin;
import cn.bdqn.util.JdbcUtil;

public class AdminDaoImpl extends BaseDao implements AdminDao {

	@Override
	public Admin getAdmin(String username, String password) {
		Connection conn = null;
		String sql = "select * from admin where username = ? and password = ?";
		PreparedStatement pstmt = null;
		Admin admin = null;
		try {
			conn = JdbcUtil.getconnection();
			pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, username);
			pstmt.setString(2, password);
			ResultSet rs = pstmt.executeQuery();
			while(rs.next()) {
				admin = new Admin();
				admin.setUsername(rs.getString("username"));
				admin.setPassword(rs.getString("password"));
			}
		} catch (SQLException e) {
			// TODO: handle exception
		}
		return admin;
	}

}

StudentDaoImpl

package cn.bdqn.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import cn.bdqn.dao.BaseDao;
import cn.bdqn.dao.StudentDao;
import cn.bdqn.entity.Student;
import cn.bdqn.util.JdbcUtil;

public class StudentDaoImpl extends BaseDao implements StudentDao {

	@Override
	public List<Student> liststudents() {
		Connection conn = null;
		String sql = "select * from student";
		PreparedStatement pstmt = null;
		List<Student> studentList = null;
		try {
			conn = JdbcUtil.getconnection();
			pstmt = conn.prepareStatement(sql);
			ResultSet rs = pstmt.executeQuery();
			studentList = new ArrayList<Student>();
			while (rs.next()) {
				Student stu = new Student();
				stu.setId(rs.getInt("id"));
				stu.setName(rs.getString("name"));
				stu.setAge(rs.getInt("age"));
				stu.se