mysql+tomacat+jsp+学籍管理系统（源码+数据库+配置环境）.rar

package com.demo.service; import com.demo.bean.UserBean; import com.demo.dao.JdbcUtils; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; public class UserService { //数据连接 Connection connection = JdbcUtils.getConnection(); /** * 查询所有用户信息 * * @return */ public List<UserBean> selectAllUser(HttpServletRequest request, HttpServletResponse response) { List<UserBean> userBeanList = new ArrayList<UserBean>(); String sql = "select * from studentinfo"; try { PreparedStatement preparedStatement = connection.prepareStatement(sql); ResultSet resultSet = preparedStatement.executeQuery(); while (resultSet.next()) { UserBean userBean = new UserBean(); userBean.setId(resultSet.getInt("id")); userBean.setUsername(resultSet.getString("username")); userBean.setPassword(resultSet.getString("password")); userBean.setSnum(resultSet.getInt("snum")); userBean.setSex(resultSet.getBoolean("sex")); userBean.setMajor(resultSet.getString("major")); userBean.setAge(resultSet.getInt("age")); userBeanList.add(userBean); } } catch (SQLException e) { e.printStackTrace(); } finally { try { if (connection.isClosed()) { connection.close(); } } catch (SQLException e) { e.printStackTrace(); } } return userBeanList; } /** * 查询单个用户 * * @param request * @param response * @return */ public List<UserBean> selectUserByName(HttpServletRequest request, HttpServletResponse response) { String username = request.getParameter("selectUserByName") == null ? "" : request.getParameter("selectUserByName"); List<UserBean> userBeanList = new ArrayList<UserBean>(); String sql = "select * from studentinfo where username like '%" + username + "%'"; try { PreparedStatement preparedStatement = connection.prepareStatement(sql); ResultSet resultSet = preparedStatement.executeQuery(); while (resultSet.next()) { UserBean userBean = new UserBean(); userBean.setId(resultSet.getInt("id")); userBean.setUsername(resultSet.getString("username")); userBean.setPassword(resultSet.getString("password")); userBean.setSnum(resultSet.getInt("snum")); userBean.setSex(resultSet.getBoolean("sex")); userBean.setMajor(resultSet.getString("major")); userBean.setAge(resultSet.getInt("age")); userBeanList.add(userBean); } } catch (SQLException e) { e.printStackTrace(); } finally { try { if (connection.isClosed()) { connection.close(); } } catch (SQLException e) { e.printStackTrace(); } } return userBeanList; } /** * 增加用户 * * @param request * @param response */ public Boolean addUser(HttpServletRequest request, HttpServletResponse response) { Boolean flag = false; String username = request.getParameter("username") == "" ? "" : request.getParameter("username"); String password = request.getParameter("password") == "" ? "" : request.getParameter("password"); Integer snum = Integer.valueOf(request.getParameter("snum") == "" ? "0" : request.getParameter("snum")); Boolean sex = "男".equals(request.getParameter("sex")) ? false : true;//如果性别是女，则为true String major = request.getParameter("major") == "" ? "" : request.getParameter("major"); Integer age = Integer.valueOf(request.getParameter("age") == "" ? "0" : request.getParameter("age")); if (!"".equals(username) && !"".equals(password)) { String sql = "insert into studentinfo (username,password,snum,sex,major,age) values (\'" + username + "\',\'" + password + "\'," + snum + ","+sex+",\'"+major+"\',"+age+");"; try { PreparedStatement preparedStatement = connection.prepareStatement(sql); //若 ececute 为 false 则插入成功 boolean execute = preparedStatement.execute(); if (!execute) { //若插入成功则返回ture flag = !execute; } } catch (SQLException e) { e.printStackTrace(); } finally { try { if (connection.isClosed()) { connection.close(); } } catch (SQLException e) { e.printStackTrace(); } } } return flag; } /** * 通过id 查询用户信息 * * @param request * @param response * @return */ public UserBean selectUserById(HttpServletRequest request, HttpServletResponse response) { String uid = request.getParameter("uid") == "" ? "" : request.getParameter("uid"); String sql = "select * from studentinfo where id = '" + uid + "'"; UserBean userBean = new UserBean(); try { PreparedStatement preparedStatement = connection.prepareStatement(sql); ResultSet resultSet = preparedStatement.executeQuery(); while (resultSet.next()) { userBean.setId(resultSet.getInt("id")); userBean.setUsername(resultSet.getString("username")); userBean.setPassword(resultSet.getString("password")); userBean.setSnum(resultSet.getInt("snum")); userBean.setSex(resultSet.getBoolean("sex")); userBean.setMajor(resultSet.getString("major")); userBean.setAge(resultSet.getInt("age")); } } catch (SQLException e) { e.printStackTrace(); } finally { try { if (connection.isClosed()) { connection.close(); } } catch (SQLException e) { e.printStackTrace(); } return userBean; } } /** * 修改用户信息 * * @param request * @param response * @return */ public Boolean updateUser(HttpServletRequest request, HttpServletResponse response) { Boolean flag = false; Integer id = Integer.valueOf(request.getParameter("id") == "" ? "0" : request.getParameter("id")); String username = request.getParameter("username") == "" ? "" : request.getParameter("username"); String password = request.getParameter("password") == "" ? "" : request.getParameter("password"); Integer snum = Integer.valueOf(request.getParameter("snum") == "" ? "0" : request.getParameter("snum")); Boolean sex = "男".equals(request.getParameter("sex")) ? false : true;//如果性别是女，则为true String major = request.getParameter("major") == "" ? "" : request.getParameter("major"); Integer age = Integer.valueOf(request.getParameter("age") == "" ? "0" : request.getParameter("age")); if (!"".equals(username) && !"".equals(password)) { String sql = "upda