package com.web.controller.servlet;
import java.io.IOException;
import java.sql.SQLException;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.web.controller.dao.impl.UserDaoImpl;
import com.web.controller.dao.UserDao;
import com.web.controller.entity.Page;
import com.web.controller.entity.Project;
import com.web.controller.entity.Student;
import com.web.controller.entity.User;
public class UserServlet extends HttpServlet {
private static UserDaoImpl uDao = null;
static {
uDao = new UserDaoImpl();
}
/**
* request:用户的请求信息 response:响应用户的请求
*/
@Override
public void service(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
super.service(request, response);
}
@Override
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
this.doGet(request, response);
}
@Override
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html; charset=UTF-8");
// flag标示,从页面接收flag对应的值下面用来比对进行什么样的操作
String flag = request.getParameter("flag");
/**
* 添加数据操作
*/
if ("add".equals(flag)) {
User user = new User();
user.setUserName(request.getParameter("userName"));
user.setPassWord(request.getParameter("passWord"));
user.setStu_name(request.getParameter("stu_name"));
user.setStu_sex (request.getParameter("stu_sex"));
user.setStu_college(request.getParameter("stu_college"));
System.out.println(request.getParameter("userName"));
System.out.println(request.getParameter("passWord"));
try {
int num = uDao.addUser(user);
if (num == 1) {
System.out.print("插入成功");
response.sendRedirect("userServlet?flag=list");
} else {
System.out.print("插入失败" );
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/*
* 查询所有的数据项
*/
if ("list".equals(flag)) {
Page page = new Page();
try {
List<User> list = uDao.findAll();
int listSize = list.size();
// System.out.println(listSize);
if (listSize == 0) {
System.out.println("查询无结果");
} else {
if (listSize < 12) {
page.setPageSize(listSize);
} else {
page.setPageSize(12);
}
page.setTotalRecord(list.size());
page.setTotalPage(list.size(), page.getPageSize());
int currentRecorde = 0;
// 计算并设置分页的参数
if (request.getParameter("currentRecord") != null) {
currentRecorde = Integer.parseInt(request
.getParameter("currentRecord"));
page.setCurrentRecord(currentRecorde);
page.setCurrentPage(currentRecorde, page.getPageSize());
}
// 从结果集中取出当前页面要显示的子集
List<User> subResult = null;
if (currentRecorde == 0) {
subResult = list.subList(0, page.getPageSize());
}
if (page.getCurrentRecord() + page.getPageSize() < list
.size())
subResult = list.subList(page.getCurrentRecord(),
page.getCurrentRecord() + page.getPageSize());
else {
subResult = list.subList(page.getCurrentRecord(),
list.size());
}
request.setAttribute("subResult", subResult);
request.setAttribute("page", page);
request.getRequestDispatcher(
"pages/files/showAllStudent.jsp").forward(request,
response);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/*
* 查询所有的数据项
*/
if ("listAll".equals(flag)) {
Page page = new Page();
try {
List<User> list = uDao.getListAll();
int listSize = list.size();
// System.out.println(listSize);
if (listSize == 0) {
System.out.println("查询无结果");
} else {
if (listSize < 12) {
page.setPageSize(listSize);
} else {
page.setPageSize(12);
}
page.setTotalRecord(list.size());
page.setTotalPage(list.size(), page.getPageSize());
int currentRecorde = 0;
// 计算并设置分页的参数
if (request.getParameter("currentRecord") != null) {
currentRecorde = Integer.parseInt(request
.getParameter("currentRecord"));
page.setCurrentRecord(currentRecorde);
page.setCurrentPage(currentRecorde, page.getPageSize());
}
// 从结果集中取出当前页面要显示的子集
List<User> subResult = null;
if (currentRecorde == 0) {
subResult = list.subList(0, page.getPageSize());
}
if (page.getCurrentRecord() + page.getPageSize() < list
.size())
subResult = list.subList(page.getCurrentRecord(),
page.getCurrentRecord() + page.getPageSize());
else {
subResult = list.subList(page.getCurrentRecord(),
list.size());
}
request.setAttribute("subResult", subResult);
request.setAttribute("page", page);
request.getRequestDispatcher(
"pages/files/main.jsp").forward(request,
response);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/*
* 更新操作
*/
if ("update".equals(flag)) {
User user = new User();
user.setUserName(request.getParameter("userName"));
user.setPassWord(request.getParameter("passWord"));
System.out.println("更改密码");
try {
int num = uDao.update(user);
System.out.println(num);
if (num > 0) {
response.sendRedirect("userServlet?flag=list");
System.out.println("更新");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
System.out.print("修改出错");
e.printStackTrace();
}
}
/*
* 更新操作
*/
if ("updateuser".equals(flag)) {
User user = new User();
user.setUserName(request.getParameter("userName"));
user.setStu_name(request.getParameter("stu_name"));
user.setStu_sex(request.getParameter("stu_sex"));
user.setStu_college(request.getParameter("stu_college"));
System.out.println(request.getParameter("stu_name"));
try {
int num = uDao.updateuser(user);
System.out.println(num);
if (num > 0) {
response.sendRedirect("userServlet?flag=list");
System.out.println("更新");
}
} catch (SQLException e) {
// TODO Auto-generated catch block
System.out.print("修改出错");
e.printStackTrace();
}
}
/*
* 通过id查询详情
*/
if ("listbyusername".equals(flag)) {
User user = null;
String num = request.getParameter("userName");
System.out.println("根据ID修改");
try {
user = uDao.getUserByUsername(num);
request.setAttribute("user", user);
request.getRequestDispatcher("pages/files/setPassword.jsp")
.forward(request, response);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/*
* 通过id查询详情
*/
if ("listbynum".equals(flag)) {
User user = null;
String num =request.getParameter("userName");
System.out.println(" listbynum 根据ID修改");
try {
user = uDao.getUserByUsername(num);
request.setAttribute("user", user);
request.getRequestDispatcher("pages/files/setStudent.jsp")
.forward(request, response);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/*
* 通过用户名来查询用
没有合适的资源?快使用搜索试试~ 我知道了~
大学生毕业设计管理系统
共112个文件
png:22个
jsp:18个
java:16个
1星 需积分: 34 43 下载量 197 浏览量
2015-11-03
17:14:57
上传
评论 16
收藏 938KB RAR 举报
温馨提示
大学生毕业设计管理系统 带数据库,源码很全,Myecplise 打开直接用。
资源推荐
资源详情
资源评论
收起资源包目录
大学生毕业设计管理系统 (112个子文件)
UserServlet.class 6KB
UserDaoImpl.class 5KB
ProjectServlet.class 5KB
StudentServlet.class 5KB
DBConnection.class 4KB
StudentDaoImpl.class 4KB
ProjectDaoImpl.class 3KB
UserLoginServlet.class 3KB
User.class 2KB
Student.class 1KB
UserLogoutServlet.class 1KB
Page.class 1KB
Project.class 1KB
UserDao.class 568B
StudentDao.class 458B
ProjectDao.class 458B
.classpath 638B
org.eclipse.wst.common.component 447B
org.eclipse.wst.jsdt.ui.superType.container 49B
style.css 22KB
login_style.css 9KB
invalid.css 2KB
reset.css 1KB
login_body.css 946B
bg-sidebar.gif 32KB
bg-body.gif 21KB
bg-radial-gradient.gif 17KB
bg-login.gif 13KB
jquery.wysiwyg.gif 4KB
bg-menu-item-green.gif 3KB
shortcut-button-bg.gif 1KB
bg-menu-item-current.gif 315B
bg-button-green.gif 169B
bg-content-box.gif 126B
bg-form-field.gif 97B
menu-current-arrow.gif 59B
mysql-connector-java-5.1.7-bin.jar 693KB
UserServlet.java 9KB
ProjectServlet.java 8KB
StudentServlet.java 6KB
UserDaoImpl.java 6KB
StudentDaoImpl.java 4KB
ProjectDaoImpl.java 3KB
DBConnection.java 3KB
UserLoginServlet.java 2KB
User.java 2KB
Page.java 1KB
Student.java 1KB
UserLogoutServlet.java 1KB
UserDao.java 985B
Project.java 899B
StudentDao.java 670B
ProjectDao.java 640B
cloud.jpg 11KB
jquery-1.3.2.min.js 56KB
jquery.wysiwyg.js 22KB
facebox.js 9KB
simpla.jquery.configuration.js 4KB
script.js 3KB
jquery.date.js 231B
jquery.datePicker.js 231B
.jsdtscope 500B
showStudentAndProject.jsp 9KB
showAllStudent.jsp 8KB
showAllproject.jsp 8KB
main.jsp 8KB
showProjectOfStudent.jsp 8KB
setStudentAndProject.jsp 7KB
setProject.jsp 7KB
AddStudent.jsp 7KB
setStudent.jsp 7KB
AddProject.jsp 7KB
setPassword.jsp 6KB
left.jsp 4KB
left2.jsp 4KB
login.jsp 2KB
relogin.jsp 2KB
index2.jsp 1KB
index.jsp 1KB
index.jsp 803B
MANIFEST.MF 36B
.mymetadata 282B
.myumldata 66B
org.eclipse.wst.jsdt.ui.superType.name 6B
home.png 7KB
logo.png 7KB
paper_content_pencil_48.png 5KB
comment_48.png 5KB
image_add_48.png 5KB
pencil_48.png 4KB
cross_grey_small.png 3KB
bg-login-top.png 3KB
8bcLQqF.png 2KB
hammer_screwdriver.png 780B
tick_circle.png 741B
information.png 725B
cross_circle.png 721B
exclamation.png 622B
cross.png 540B
pencil.png 497B
共 112 条
- 1
- 2
资源评论
- 慢慢来会很快2015-11-04哎呀我去了,太坑了!
趁着年轻丶去疯狂吧
- 粉丝: 5
- 资源: 8
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功