package com.sjsq.service.impl;
import com.sjsq.dao.AdminDao;
import com.sjsq.dao.impl.AdminDaoImpl;
import com.sjsq.service.AdminService;
import com.sjsq.vo.Admin;
/**
-
@author shuijianshiqing
-
@date 2021/5/1 11:13
*/
public class AdminServiceImpl implements AdminService {
private AdminDao adminDao = new AdminDaoImpl();
@Override
public Admin login(Admin admin) {
return adminDao.login(admin);
}
}
package com.sjsq.service;
import com.sjsq.vo.Student;
import java.util.List;
/**
-
@author shuijianshiqing
-
@date 2021/5/1 8:26
*/
public interface StudentService {
/**
-
查询学生信息
-
@param student
-
@return
*/
public List selectAll(Student student);
/**
-
根据学号进行查询
-
@param id
-
@return
*/
public Student selectStudent(Integer id);
/**
-
新增学生信息
-
@param student
-
@return
*/
public boolean addStudent(Student student);
/**
-
修改学生信息
-
@param student
-
@return
*/
public boolean updateStudent(Student student);
/**
-
删除学生信息
-
@param id
-
@return
*/
public boolean deleteStudent(Integer id);
}
package com.sjsq.service.impl;
import com.sjsq.dao.StudentDao;
import com.sjsq.dao.impl.StudentDaoImpl;
import com.sjsq.service.StudentService;
import com.sjsq.vo.Student;
import java.util.ArrayList;
import java.util.List;
/**
-
@author shuijianshiqing
-
@date 2021/5/1 8:26
*/
public class StudentServiceImpl implements StudentService {
private StudentDao studentDao = new StudentDaoImpl();
@Override
public List selectAll(Student student) {
StringBuffer sql = new StringBuffer("select * from student where 1 = 1 ");
List list = new ArrayList();
if(student != null){
// 根据id来查找对应的学生信息
if(student.getId() != null && student.getId() != 0){
sql.append(" and id = ?");
list.add(student.getId());
}
}
return studentDao.selectAll(sql.toString(),list.toArray());
}
@Override
public Student selectStudent(Integer id) {
return studentDao.selectStudent(id);
}
@Override
public boolean addStudent(Student student) {
return studentDao.addStudent(student);
}
@Override
public boolean updateStudent(Student student) {
return studentDao.updateStudent(student);
}
@Override
public boolean deleteStudent(Integer id) {
return studentDao.deleteStudent(id);
}
}
<%@ page contentType=“text/html;charset=UTF-8” language=“java” pageEncoding=“UTF-8” %>
<%
// 获取绝对路径路径 ,开发项目一定要使用绝对路径,不然肯定出错
String path = request.getContextPath();
String basePath = request.getScheme() + “😕/” + request.getServerName() + “:”
- request.getServerPort() + path + “/”;
%>
用户登录
<%@ page contentType=“text/html;charset=UTF-8” language=“java” pageEncoding=“UTF-8” %>
<%@ page import=“com.sjsq.service.AdminService”%>
<%@ page import=“com.sjsq.service.impl.AdminServiceImpl”%>
<%@ page import=“com.sjsq.vo.Admin”%>
<%
// 获取绝对路径路径 ,开发项目一定要使用绝对路径,不然肯定出错
String path = request.getContextPath();
String basePath = request.getScheme() + “😕/” + request.getServerName() + “:”
- request.getServerPort() + path + “/”;
%>
用户登录
<%
// 设置接收的编码为UTF-8
request.setCharacterEncoding(“utf-8”);
// 获取前端传过来的字符串
String username = request.getParameter(“username”);
String password=request.getParameter(“password”);
// 定义接受的对象
Admin admin = new Admin();
admin.setUsername(username);
admin.setPassword(password);
// 把数据库里面的Admin获取出来
AdminService adminService = new AdminServiceImpl();
// 注意数据的admin账号密码不能重复
Admin adminLogin = adminService.login(admin);
System.out.println(“显示登录用户信息:”);
System.out.println(adminLogin);
// 设置session
session.setAttribute(“admin”,adminLogin);
// 判断adminLogin是否为空
if(!(adminLogin==null)){
// 成功之后重定向到主页面
response.sendRedirect(“main.jsp”);
} else{
// 失败之后重定向到失败页面
response.sendRedirect(“fail.jsp”);
}
%>
<%@ page contentType=“text/html;charset=UTF-8” language=“java” pageEncoding=“UTF-8” %>
<%
// 会话失效
session.invalidate();
response.sendRedirect(“login.jsp”);
%>
<%@ page contentType=“text/html;charset=UTF-8” language=“java” pageEncoding=“UTF-8” %>
<%@ page import=“com.sjsq.service.StudentService” %>
<%@ page import=“com.sjsq.service.impl.StudentServiceImpl” %>
<%@ page import=“com.sjsq.vo.Student” %>
<%@ page import=“java.util.List” %>
<%-- 头部 --%>
<jsp:include page=“top.jsp”/>
<%
// 设置获取注册时的编码为UTF-8
request.setCharacterEncoding(“UTF-8”);
StudentService studentService = new StudentServiceImpl();
// 定义一个学生类
Student student = new Student();
// 获取上一个页面传过来的值
if(request.getParameter(“id”)!=null && request.getParameter(“id”)!=“”){
Integer id = Integer.parseInt(request.getParameter(“id”));
student.setId(id);
}
// 获取所有学生
List studentList = studentService.selectAll(student);
%>
学生列表
请输入姓名:
<%
for (int i = 0;i<studentList.size();i++){
Student s =studentList.get(i);
%>
<%=s.getId()%> <%=s.getName()%> <%=s.getAge()%> <%=s.getSex()%> <%=s.getNation()%> <%=s.getPlace()%> <%=s.getMajor()%> <%=s.getClasses()%><%
}
%>
<%-- 底部 --%>
<jsp:include page=“bottom.jsp”/>
<%@ page contentType=“text/html;charset=UTF-8” language=“java” %>
<%-- 头部 --%>
<jsp:include page=“top.jsp”/>
新增学生
返回上一级
添加
重置
<%-- 底部 --%>
<jsp:include page=“bottom.jsp”/>
<%@ page import=“com.sjsq.service.StudentService” %>
<%@ page import=“com.sjsq.service.impl.StudentServiceImpl” %>
<%@ page import=“com.sjsq.vo.Student” %>
<%@ page contentType=“text/html;charset=UTF-8” language=“java” %>
<%-- 头部 --%>
<jsp:include page=“top.jsp”/>
新增学生
<%
//获取admin.jsp页面的bookid
Integer id=Integer.parseInt(request.getParameter(“id”));
StudentService studentService = new StudentServiceImpl();
Student student = new Student();
student = studentService.selectStudent(id);
%>
返回上一级
修改
重置
<%-- 底部 --%>
<jsp:include page=“bottom.jsp”/>
===================================================================
JavaWeb系统系列实现
Java+Springboot+Mybatis+Bootstrap实现网上商城系统
JavaSwing系统系列实现
最后
作为过来人,小编是整理了很多进阶架构视频资料、面试文档以及PDF的学习资料,针对上面一套系统大纲小编也有对应的相关进阶架构视频资料
=“reset”>重置
<%-- 底部 --%>
<jsp:include page=“bottom.jsp”/>
===================================================================
JavaWeb系统系列实现
Java+Springboot+Mybatis+Bootstrap实现网上商城系统
JavaSwing系统系列实现
最后
作为过来人,小编是整理了很多进阶架构视频资料、面试文档以及PDF的学习资料,针对上面一套系统大纲小编也有对应的相关进阶架构视频资料
[外链图片转存中…(img-Jpe80mCT-1718731506324)]
[外链图片转存中…(img-pyNrov9z-1718731506324)]