package com.java1234.servlet;
import java.io.IOException;
import java.sql.Connection;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import net.sf.json.JSONObject;
import com.java1234.dao.CourseDao;
import com.java1234.dao.StudentCourseDao;
import com.java1234.dao.StudentDao;
import com.java1234.model.Course;
import com.java1234.model.PageBean;
import com.java1234.model.Student;
import com.java1234.model.StudentCourse;
import com.java1234.model.User;
import com.java1234.util.DbUtil;
import com.java1234.util.PageUtil;
import com.java1234.util.ResponseUtil;
import com.java1234.util.StringUtil;
/**
* 学生Servlet类
* @author Administrator
*
*/
public class StudentServlet extends HttpServlet {
/**
*
*/
private static final long serialVersionUID = 1L;
private DbUtil dbUtil=new DbUtil();
private StudentDao studentDao=new StudentDao();
private StudentCourseDao studentCourseDao=new StudentCourseDao();
private CourseDao courseDao=new CourseDao();
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doPost(request, response);
}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
String action=request.getParameter("action");
if("list".equals(action)){
this.list(request, response);
}else if("preSave".equals(action)){
this.preSave(request, response);
}else if("save".equals(action)){
this.save(request, response);
}else if("delete".equals(action)){
this.delete(request, response);
}else if("courseList".equals(action)){
this.courseList(request, response);
}else if("showInfo".equals(action)){
this.showInfo(request,response);
}else if("showScore".equals(action)){
this.showScore(request,response);
}else if("preSelect".equals(action)){
this.preSelect(request,response);
}else if("selectCourse".equals(action)){
this.selectCourse(request,response);
}else if("unSelectCourse".equals(action)){
this.unSelectCourse(request, response);
}
}
/**
* 显示数据
* @param request
* @param response
* @throws ServletException
* @throws IOException
*/
private void list(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
HttpSession session=request.getSession();
String page=request.getParameter("page");
String s_userName=request.getParameter("s_userName");
Student s_student=new Student();
if(StringUtil.isEmpty(page)){
page="1";
s_student.setUserName(s_userName);
session.setAttribute("s_student", s_student);
}else{
s_student=(Student) session.getAttribute("s_student");
}
PageBean pageBean=new PageBean(Integer.parseInt(page),3);
Connection con=null;
try{
con=dbUtil.getCon();
List<Student> studentList=studentDao.studentList(con, pageBean, s_student);
int total=studentDao.studentCount(con, s_student);
String pageCode=PageUtil.getPagation(request.getContextPath()+"/WebContent/student?action=list", total, Integer.parseInt(page), 3);
request.setAttribute("pageCode", pageCode);
request.setAttribute("modeName", "学生信息管理");
request.setAttribute("studentList", studentList);
request.setAttribute("mainPage", "student/list.jsp");
request.getRequestDispatcher("main.jsp").forward(request, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
/**
* 添加修改预操作
* @param request
* @param response
* @throws ServletException
* @throws IOException
*/
private void preSave(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
String id=request.getParameter("id");
if(StringUtil.isNotEmpty(id)){
request.setAttribute("actionName", "学生信息修改");
Connection con=null;
try{
con=dbUtil.getCon();
Student student=studentDao.loadStudentById(con, id);
request.setAttribute("student", student);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}else{
request.setAttribute("actionName", "学生信息添加");
}
request.setAttribute("mainPage", "student/save.jsp");
request.setAttribute("modeName", "学生信息管理");
request.getRequestDispatcher("main.jsp").forward(request, response);
}
/**
* 添加修改操作
* @param request
* @param response
* @throws ServletException
* @throws IOException
*/
private void save(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
String id=request.getParameter("id");
String userName=request.getParameter("userName");
String password=request.getParameter("password");
String trueName=request.getParameter("trueName");
String stuNo=request.getParameter("stuNo");
String professional=request.getParameter("professional");
Student student=new Student(userName,password,trueName,stuNo,professional);
Connection con=null;
try{
con=dbUtil.getCon();
if(StringUtil.isNotEmpty(id)){ // 修改
student.setId(Integer.parseInt(id));
studentDao.studentUpdate(con, student);
}else{
studentDao.studentAdd(con, student);
}
response.sendRedirect("student?action=list");
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
/**
* 删除操作
* @param request
* @param response
* @throws ServletException
* @throws IOException
*/
private void delete(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
String id=request.getParameter("id");
Connection con=null;
try{
con=dbUtil.getCon();
JSONObject result = new JSONObject();
if(studentCourseDao.existStudentByStuId(con, id)){
result.put("success", false);
}else{
studentDao.studentDelete(con, id);
result.put("success", true);
}
ResponseUtil.write(result, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
/**
* 查询学生的课程
* @param request
* @param response
* @throws ServletException
* @throws IOException
*/
private void courseList(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
HttpSession session=request.getSession();
User currentUser=(User) session.getAttribute("currentUser");
Connection con=null;
try{
con=dbUtil.getCon();
List<StudentCourse> courseList=studentCourseDao.findCourseByStudentId(con, currentUser.getUserId());
request.setAttribute("courseList", courseList);
request.setAttribute("modeName", "查看课程信息");
request.setAttribute("mainPage", "student/courseList.jsp");
request.getRequestDispatcher("main.jsp").forward(request, response);
}catch(Exception e){
e.printStackTrace();
}finally{
try {
dbUtil.closeCon(con);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
/**
* 查看个人信息
* @param request
* @param response
* @throws ServletException
* @throws IOException
*/
private void showInfo(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
HttpSession session=request.getSession();
User currentUser=(User) session.getAttribute("currentUser");
Con
没有合适的资源?快使用搜索试试~ 我知道了~
温馨提示
本人十余年JAVA架构设计经验,擅长JAVA高可用、分布式、高并发系统架构设计。有志于做JAVA系统性的技术提升的同学可与我联系,交个朋友哦~ 本人十余年JAVA架构设计经验,擅长JAVA高可用、分布式、高并发系统架构设计。有志于做JAVA系统性的技术提升的同学可与我联系,交个朋友哦~ 本人十余年JAVA架构设计经验,擅长JAVA高可用、分布式、高并发系统架构设计。有志于做JAVA系统性的技术提升的同学可与我联系,交个朋友哦~
资源推荐
资源详情
资源评论
收起资源包目录
《毕业设计&代码复用》--—基于SpringBoot的校园服务小程序.zip (441个子文件)
last-build.bin 1B
StudentServlet.class 14KB
TeacherServlet.class 12KB
CourseServlet.class 8KB
StudentDao.class 7KB
User.class 6KB
TeacherDao.class 6KB
StudentCourseDao.class 6KB
CourseDao.class 5KB
UserServlet.class 4KB
TestUser.class 4KB
TestAdmin.class 3KB
Dept.class 3KB
EmployeeTest.class 3KB
Employee.class 3KB
User.class 2KB
Admin.class 2KB
$Proxy0.class 2KB
DeptTest.class 2KB
LoginFilter.class 2KB
PageUtil.class 2KB
StudentCourse.class 2KB
$Proxy1.class 2KB
Student.class 2KB
Address.class 2KB
ManagerDao.class 2KB
Agent.class 2KB
DbUtil.class 2KB
Teacher.class 2KB
Course.class 2KB
User.class 1KB
MaleSinger.class 1KB
Manager.class 1KB
Client.class 1KB
AdminMapper.class 979B
UserTest.class 956B
ResponseUtil.class 951B
HandShake.class 859B
PageBean.class 825B
UserMapper.class 771B
Test.class 730B
StringUtil.class 679B
CarFactory.class 668B
Bike.class 517B
Benz.class 505B
BMW.class 502B
EmployeeMapper.class 466B
BenzFactory.class 421B
BikeFactory.class 421B
BMWFactory.class 417B
ManagerServlet.class 387B
DeptMapper.class 295B
Singer.class 179B
IUserDao.class 162B
Factory.class 142B
Car.class 117B
.classpath 853B
mvnw.cmd 6KB
mvnw.cmd 6KB
org.eclipse.wst.common.component 432B
org.eclipse.wst.jsdt.ui.superType.container 49B
bootstrap.css 134KB
bootstrap.min.css 111KB
bootstrap-theme.css 22KB
bootstrap-theme.min.css 19KB
xsxk.css 184B
Thumbs.db 18KB
glyphicons-halflings-regular.eot 20KB
.gitignore 395B
.gitignore 395B
.gitignore 222B
.gitignore 221B
.gitignore 219B
.gitignore 219B
.gitignore 213B
.gitignore 205B
Xsxk.iml 2KB
maven.iml 2KB
Reflection.iml 793B
Spring-study.iml 80B
maven-test.iml 80B
mybatis-study.iml 80B
druid-1.1.18.jar 2.65MB
mysql-connector-java-8.0.23.jar 2.3MB
aspectjweaver-1.9.2.jar 1.96MB
mybatis-3.5.6.jar 1.66MB
lombok-1.18.8.jar 1.65MB
protobuf-java-3.11.4.jar 1.58MB
spring-core-5.2.12.RELEASE.jar 1.38MB
spring-context-5.2.12.RELEASE.jar 1.17MB
spring-beans-5.2.12.RELEASE.jar 672KB
spring-test-5.2.12.RELEASE.jar 669KB
commons-collections-3.1.jar 546KB
mysql-connector-java-3.1.12-bin.jar 436KB
spring-jdbc-5.2.12.RELEASE.jar 399KB
standard.jar 384KB
spring-aop-5.2.12.RELEASE.jar 364KB
log4j-1.2.12.jar 350KB
spring-tx-5.2.12.RELEASE.jar 307KB
spring-expression-5.2.12.RELEASE.jar 276KB
共 441 条
- 1
- 2
- 3
- 4
- 5
资源评论
季风泯灭的季节
- 粉丝: 696
- 资源: 2920
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- Installing Anaconda and PyCharm - Marco Sammon
- git使用文档(一步一步教你使用Git仓库管理代码)
- 进制转换(通用版).cpp
- linux实践之从DistroWatch排名第三的EndeavourOS转到排名第五的Manjaro工作机迁移
- Discuz模板+资讯博客课程干货+商业版(GBK+UTF)
- 基于Selenium的Java爬虫实战(内含谷歌浏览器Chrom和Chromedriver版本123.0.6292.0)
- RB308A-SOT23-5 单节锂电池保护IC 深圳市可芯电子有限公司.pdf
- Ubuntu下安装JDK
- 基于Selenium的Java爬虫实战(内含谷歌浏览器Chrom和Chromedriver版本123.0.6291.0)
- Android基础之用Eclipse建立工程
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功