IDEA+Java+JSP+Mysql+Tomcat实现Web学生信息管理系统
二、系统展示
=====================================================================
1.登录系统
2.主页面
3.增加学生信息
4.修改学生信息
5.查询学生信息
三、代码实现
=====================================================================
AdminDao
package com.sjsq.dao;
import com.sjsq.vo.Admin;
/**
@author shuijianshiqing
@date 2021/5/1 9:46
*/
public interface AdminDao {
/**
用户登录
@param admin
@return
*/
public Admin login(Admin admin);
}
AdminDaoImpl
package com.sjsq.dao.impl;
import com.sjsq.dao.AdminDao;
import com.sjsq.utils.DBUtil;
import com.sjsq.vo.Admin;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
@author shuijianshiqing
@date 2021/5/1 9:49
*/
public class AdminDaoImpl implements AdminDao {
/**
用户登录
@param admin
@return
*/
@Override
public Admin login(Admin admin) {
Connection con = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
// 1.获取数据库连接
con = DBUtil.getConnection();
// 2.写sql
String sql = “select * from admin where username = ? and password = ?”;
// 3.预编译
ps = con.prepareStatement(sql);
// 4.设置值
ps.setObject(1,admin.getUsername());
ps.setObject(2,admin.getPassword());
rs = ps.executeQuery();
Admin adminLogin = null;
if(rs.next()){
adminLogin = new Admin();
// 从数据库中获取值到实体类的setter方法中
adminLogin.setUsername(rs.getString(“username”));
adminLogin.setPassword(rs.getString(“password”));
// 返回的是你查询出来的完整的对象
return adminLogin;
}
} catch (ClassNotFoundException e) {
e.p
