SMBMS

最新推荐文章于 2023-12-11 11:06:43 发布

果冻奶酪

最新推荐文章于 2023-12-11 11:06:43 发布

阅读量366

点赞数

分类专栏： Java

本文链接：https://blog.csdn.net/qq_43104182/article/details/109895942

版权

Java 专栏收录该内容

30 篇文章 0 订阅

订阅专栏

SMBMS

在这里插入图片描述
数据库：

项目如何搭建：
考虑使不使用maven，依赖，jar

项目搭建准备工作

1、搭建一个mavenweb项目
2、配置Tomcat
3、测试项目是否跑起来
4、导入项目中遇到的jar包：jsp、servlet、MySQL驱动
5、创建项目包结构

在这里插入图片描述
6、编写实体类
ORM映射：表–>类映射
7、编写基础公共类

数据库配置文件

driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/smbms?useSSL=false&useUnicode=false&serverTimezone=GMT
username=root
password=fj123456

编写数据库的公共类

//操作数据库的公共类
public class BaseDao {

    private static String driver;
    private static String url;
    private static String username;
    private static String password;

    //静态代码块，类加载时就初始化
    static {
        Properties properties = new Properties();
        //通过类加载器读取对应的资源
        InputStream is =
                BaseDao.class.getClassLoader().getResourceAsStream("db.properties");

        try {
            properties.load(is);
        } catch (IOException e) {
            e.printStackTrace();
        }

        driver = properties.getProperty("driver");
        url = properties.getProperty("url");
        username = properties.getProperty("username");
        password = properties.getProperty("password");
    }

    //获取数据库连接
    public static Connection getConnection(){
        Connection connection = null;
        try {
            Class.forName(driver);
            connection = DriverManager.getConnection(url, username, password);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return connection;
    }

    //编写查询公共方法
    public static ResultSet execute(Connection connection, String sql, Object[] params, ResultSet resultSet, PreparedStatement preparedStatement) throws SQLException {
        //预编译的sql，在后面不需要再次传入执行
        preparedStatement = connection.prepareStatement(sql);

        for (int i = 0; i < params.length; i++){
            //setObject占位符从1开始计数
            preparedStatement.setObject(i+1, params[i]);
        }

        resultSet = preparedStatement.executeQuery();
        return resultSet;
    }

    //编写增删改公共方法
    public static int execute(Connection connection, String sql, Object[] params, PreparedStatement preparedStatement) throws SQLException {
        //预编译的sql，在后面不需要再次传入执行
        preparedStatement = connection.prepareStatement(sql);

        for (int i = 0; i < params.length; i++){
            //setObject占位符从1开始计数
            preparedStatement.setObject(i+1, params[i]);
        }

        int updateRows = preparedStatement.executeUpdate();
        return updateRows;
    }

    //关闭连接，释放资源
    public static boolean closeResource(Connection connection, PreparedStatement preparedStatement, ResultSet resultSet){
        boolean flag = true;

        if (resultSet != null){
            try {
                resultSet.close();
                //GC回收
                resultSet = null;
            } catch (SQLException e) {
                e.printStackTrace();
                flag = false;
            }
        }
        if (preparedStatement != null){
            try {
                preparedStatement.close();
                //GC回收
                preparedStatement = null;
            } catch (SQLException e) {
                e.printStackTrace();
                flag = false;
            }
        }
        if (connection != null){
            try {
                connection.close();
                //GC回收
                connection = null;
            } catch (SQLException e) {
                e.printStackTrace();
                flag = false;
            }
        }

        return flag;
    }

}

编写字符编码过滤器

8、导入静态资源

登录功能实现

在这里插入图片描述
1、编写前端页面
2、设置首页

<!-- 设置欢迎页面 -->
<welcome-file-list>
	<welcome-file>login.jsp</welcome-file>
</welcome-file-list>

3、编写dao层登录用户登录的接口

//得到要登录的用户
public User getLoginUser(Connection connection, String userCode) throws SQLException;

4、编写dao接口的实现类

public class UserDaoImpl implements UserDao {
    @Override
    public User getLoginUser(Connection connection, String userCode) throws SQLException {

        PreparedStatement preparedStatement = null;
        ResultSet resultset = null;
        User user = null;

        if (connection != null){
            String sql = "select * from smbms_user where userCode = ?";
            Object[] params = {userCode};

            resultset = BaseDao.execute(connection, preparedStatement, resultset, sql, params);

            //如果resultSet中有数据，就获取到User中
            if (resultset.next()){
                user = new User();

                user.setId(resultset.getInt("id"));
                user.setUserCode(resultset.getString("userCode"));
                user.setUserName(resultset.getString("userName"));
                user.setUserPassword(resultset.getString("userPassword"));
                user.setGender(resultset.getInt("gender"));
                user.setBirthday(resultset.getDate("birthday"));
                user.setPhone(resultset.getString("phone"));
                user.setAddress(resultset.getString("address"));
                user.setUserRole(resultset.getInt("userRole"));
                user.setCreatedBy(resultset.getInt("createdBy"));
                user.setCreationDate(resultset.getDate("creationDate"));
                user.setModifyBy(resultset.getInt("modifyBy"));
                user.setModifyDate(resultset.getDate("modifyDate"));
            }
            //关闭资源
            BaseDao.closeResource(null, preparedStatement, resultset);
        }

        return user;

    }
}

5、业务层接口

//用户登录
public User login(String userCode, String password);

6、业务层实现类

public class UserServiceImpl implements UserService {

    //业务层都会调用Dao层，所以要引用Dao层
    private UserDao userDao;

    public UserServiceImpl(){
        userDao = new UserDaoImpl();
    }

    @Override
    public User login(String userCode, String password) {

        Connection connection = null;
        User user = null;

        try {
            connection = BaseDao.getConnection();
            //通过业务层调用对应的数据库操作
            user = userDao.getLoginUser(connection, userCode);
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }finally {
            BaseDao.closeResource(connection, null, null);
        }

        return user;
    }

}

7、编写Servlet

public class LoginServlet extends HttpServlet {

    //Servlet：控制层，调用业务层代码

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        System.out.println("进入LoginServlet");

        //获取用户名和密码
        String username = req.getParameter("userCode");
        String password = req.getParameter("userPassword");

        //和数据库中的密码进行对比，调用业务层
        UserServiceImpl userService = new UserServiceImpl();
        //将登录的用户放入User中
        User user = userService.login(username, password);

        if(user != null && user.getUserPassword().equals(password)){//用户存在
            //将用户的信息存入Session中
            req.getSession().setAttribute(Constants.USER_SESSION, user);
            //跳转到主页
            resp.sendRedirect("jsp/frame.jsp");
        }else {//找不到该用户
            //转发到登录页面，顺带提示用户或密码错误
            req.setAttribute("error", "用户名或者密码不正确");
            req.getRequestDispatcher("login.jsp").forward(req, resp);
        }

    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doGet(req, resp);
    }
}

8、注册Servlet

<!-- Servlet -->
<servlet>
	<servlet-name>LoginServlet</servlet-name>
	<servlet-class>com.fj.servlet.User.LoginServlet</servlet-class>
</servlet>
<servlet-mapping>
	<servlet-name>LoginServlet</servlet-name>
	<url-pattern>/login.do</url-pattern>
</servlet-mapping>

登录功能优化

注销功能：

移除session，返回登录页面

public class LoginoutServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        //移除用户的Session
        req.getSession().removeAttribute(Constants.USER_SESSION);
        //返回登录页面
        //req.getContextPath()：获取项目的路径/smbms
        resp.sendRedirect(req.getContextPath() + "/login.jsp");
    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doGet(req, resp);
    }
}

注册xml

<servlet>
	<servlet-name>LoginoutServlet</servlet-name>
	<servlet-class>com.fj.servlet.User.LoginoutServlet</servlet-class>
</servlet>
<servlet-mapping>
	<servlet-name>LoginoutServlet</servlet-name>
	<url-pattern>/jsp/logout.do</url-pattern>
</servlet-mapping>

登录拦截优化

编写一个过滤器

public class SysFilter implements Filter {
    @Override
    public void init(FilterConfig filterConfig) throws ServletException {

    }

    @Override
    public void doFilter(ServletRequest servletRequest, ServletResponse servletResponse, FilterChain filterChain) throws IOException, ServletException {
        HttpServletRequest request = (HttpServletRequest) servletRequest;//用于获取Session
        HttpServletResponse response = (HttpServletResponse) servletResponse;//用于重定向

        //过滤器，从Session中获取用户
        User user = (User) request.getSession().getAttribute(Constants.USER_SESSION);

        if (user == null){  //非用户登录进入
            response.sendRedirect("/smbms/error.jsp");
        }else {
            filterChain.doFilter(servletRequest, servletResponse);
        }
    }

    @Override
    public void destroy() {

    }
}

注册xml

<!-- 用户登录过滤器 -->
<filter>
	<filter-name>SysFilter</filter-name>
	<filter-class>com.fj.filter.SysFilter</filter-class>
</filter>
<filter-mapping>
	<filter-name>SysFilter</filter-name>
	<url-pattern>/jsp/*</url-pattern>
</filter-mapping>

密码修改

1、从底层开始写
在这里插入图片描述
2、UserDao接口

//修改当前用户密码
public int updatePwd(Connection connection, int id, String password) throws SQLException;

3、UserDao接口实现类

//修改当前密码
@Override
public int updatePwd(Connection connection, int id, String password) throws SQLException {
	PreparedStatement preparedStatement = null;
	int excute = 0;

	if (connection != null){
		String sql = "update smbms_user set userPassword = ? where id = ?";
		Object[] params = {password, id};
		excute = BaseDao.execute(connection, preparedStatement, sql, params);
		BaseDao.closeResource(null, preparedStatement, null);
	}
	return excute;
}

4、UserService接口

//根据用户ID修改密码
public boolean updatePwd(int id, String password);

5、UserService实现类

//根据用户ID修改密码
@Override
public boolean updatePwd(int id, String password) {
	Connection connection = null;
	boolean flag = false;

	//修改密码
	try {
		connection = BaseDao.getConnection();
		if (userDao.updatePwd(connection, id, password) > 0){
			flag = true;
		}
	} catch (SQLException e) {
		e.printStackTrace();
	}finally {
		BaseDao.closeResource(connection, null, null);
	}

	return flag;
}

6、Servlet方法

//从Session中拿取id
Object attribute = req.getSession().getAttribute(Constants.USER_SESSION);
String newpassword = req.getParameter("newpassword");

boolean flag = false;

if (attribute != null && newpassword != null){
	UserService userService = new UserServiceImpl();
	flag = userService.updatePwd(((User) attribute).getId(), newpassword);
	if (flag){
		req.setAttribute("message", "修改密码成功，请退出重新登录");
		//修改成功，移除当前Session
		req.getSession().removeAttribute(Constants.USER_SESSION);
	}else{
		req.setAttribute("message", "修改密码失败");
	}
}else {
	req.setAttribute("message", "新密码有问题");
}

try {
	req.getRequestDispatcher("pwdmodify.jsp").forward(req, resp);
} catch (ServletException e) {
	e.printStackTrace();
} catch (IOException e) {
	e.printStackTrace();
}

7、实现复用，需要提取方法

@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
	String method = req.getParameter("method");
	if (method.equals("savepwd") && method != null){
		this.updatePwd(req, resp);
	}
}

public void updatePwd(HttpServletRequest req, HttpServletResponse resp){
	//从Session中拿取id
	Object attribute = req.getSession().getAttribute(Constants.USER_SESSION);
	String newpassword = req.getParameter("newpassword");

	boolean flag = false;

	if (attribute != null && newpassword != null){
		UserService userService = new UserServiceImpl();
		flag = userService.updatePwd(((User) attribute).getId(), newpassword);
		if (flag){
		req.setAttribute("message", "修改密码成功，请退出重新登录");
			//修改成功，移除当前Session
			req.getSession().removeAttribute(Constants.USER_SESSION);
		}else{
			req.setAttribute("message", "修改密码失败");
		}
	}else {
		req.setAttribute("message", "新密码有问题");
	}

	try {
		req.getRequestDispatcher("pwdmodify.jsp").forward(req, resp);
	} catch (ServletException e) {
		e.printStackTrace();
	} catch (IOException e) {
		e.printStackTrace();
	}
}

优化密码修改使用Ajax：

1、阿里巴巴的fastjson

2、后台代码修改

//验证旧密码,session中有用户的密码
public void pwdModify(HttpServletRequest req, HttpServletResponse resp){
	//从Session中拿到password
	Object o = req.getSession().getAttribute(Constants.USER_SESSION);
	String oldpassword = req.getParameter("oldpassword");

	//万能的Map : 结果集
	HashMap<String, String> resultMap = new HashMap<>();

	if (o == null){//Session失效，或者Session过期
		resultMap.put("result", "sessionerror");
	}else if (oldpassword == null || oldpassword.length() == 0){    //输入的密码为空
		resultMap.put("result", "error");
	}else {
		String password = ((User) o).getUserPassword();//获取Session中用户的密码
		if (oldpassword.equals(password)){
			resultMap.put("result", "true");
		}else {
			resultMap.put("result", "false");
		}
	}

	try {
		resp.setContentType("application/json");
		PrintWriter writer = resp.getWriter();
		//JSONArray：阿里巴巴的工具类，用于转换格式
		writer.write(JSONArray.toJSONString(resultMap));
		writer.flush();
		writer.close();
	} catch (IOException e) {
		e.printStackTrace();
	}
}

用户管理实现

思路：
在这里插入图片描述
1、导入分页的工具类
2、用户列表页面导入

rollpage.jsp
userlist.jsp

1、获取用户数量

UserDao

//查询用户总数
public int getUserCount(Connection connection, String userName, int userRole) throws SQLException;

UserDaoImpl

//根据用户名或者角色查询用户总数
@Override
public int getUserCount(Connection connection, String userName, int userRole) throws SQLException {

	PreparedStatement preparedStatement = null;
	ResultSet resultSet = null;
	int count = 0;

	if (connection != null){
		StringBuffer sql = new StringBuffer();
		sql.append("select count(1) count from smbms_user u, smbms_role r where u.userRole = r.id");
		ArrayList<Object> list = new ArrayList<>(); //用于存放参数

		if (!StringUtils.isNullOrEmpty(userName)){
			sql.append(" and u.userName like ?");
			list.add("%" + userName + "%"); //index:0
		}
		if (userRole > 0){
			sql.append(" and u.userRole = ?");
			list.add(userRole); //index:1
		}
            
		//把List转化为数组
		Object[] params = list.toArray();

		System.out.println("UserDaoImpl -> getUserCount: " + sql.toString());//输出最后完整的SQL语句

		resultSet = BaseDao.execute(connection, preparedStatement, resultSet, sql.toString(), params);

		if (resultSet.next()){
			count = resultSet.getInt("count");//从结果集中获取用户数量
		}
		BaseDao.closeResource(null, preparedStatement, resultSet);
	}

	return count;

}

UserService

//查询记录数
public int getUserCount(String username, int userRole);

UserServiceImpl

//查询记录数
@Override
public int getUserCount(String username, int userRole) {

	Connection connection = null;
	int count = 0;

	try {
		connection = BaseDao.getConnection();
		count = userDao.getUserCount(connection, username, userRole);
	} catch (SQLException e) {
		e.printStackTrace();
	}finally {
		BaseDao.closeResource(connection, null, null);
	}

	return count;

}

2、获取用户列表

UserDao

//通过条件查询用户
public List<User> getUserList(Connection connection, String username, int userRole, int currentPageNo, int PageSize) throws SQLException;

UserDaoImpl

//通过条件查询用户
@Override
public List<User> getUserList(Connection connection, String username, int userRole, int currentPageNo, int PageSize) throws SQLException {
	PreparedStatement preparedStatement = null;
	ResultSet resultSet = null;
	List<User> userList = new ArrayList<>();

	if (connection != null){
		StringBuffer sql = new StringBuffer();
		sql.append("select u.*, r.roleName as userRoleName from smbms_user u, smbms_role r where u.userRole = r.id");
		ArrayList<Object> list = new ArrayList<>(); //用于存放参数

		if (!StringUtils.isNullOrEmpty(username)){
			sql.append(" and u.userName like ?");
			list.add("%" + username + "%"); //index:0
		}
		if (userRole > 0){
			sql.append(" and u.userRole = ?");
			list.add(userRole); //index:1
		}

		//数据库中，分页使用limit
		sql.append(" order by creationDate DESC limit ?,?");

		currentPageNo = (currentPageNo - 1) * PageSize;
		list.add(currentPageNo);
		list.add(PageSize);

		Object[] params = list.toArray();
		System.out.println("sql ----> " + sql.toString());

		resultSet = BaseDao.execute(connection, preparedStatement, resultSet, sql.toString(), params);
		if (resultSet.next()){
			User user = new User();
			user.setId(resultSet.getInt("id"));
			user.setUserCode(resultSet.getString("userCode"));
			user.setUserName(resultSet.getString("userName"));
			user.setGender(resultSet.getInt("gender"));
			user.setBirthday(resultSet.getDate("birthday"));
			user.setPhone(resultSet.getString("phone"));
			user.setUserRole(resultSet.getInt("userRole"));
			user.setUserRoleName(resultSet.getString("userRoleName"));
			userList.add(user);
		}

		BaseDao.closeResource(null, preparedStatement, resultSet);
	}
	return userList;
}

UserService

//根据条件查询用户列表
public List<User> getUserList(String queryUserName, int queryUserRole, int currentPageNo, int pageSize);

UserServiceImpl

//根据条件查询用户列表
@Override
public List<User> getUserList(String queryUserName, int queryUserRole, int currentPageNo, int pageSize) {
	Connection connection = null;
	List<User> userList = null;

	try {
		connection = BaseDao.getConnection();
		userList = userDao.getUserList(connection, queryUserName, queryUserRole, currentPageNo, pageSize);
	}catch (Exception e){
		e.printStackTrace();
	}finally {
		BaseDao.closeResource(connection, null, null);
	}

	return userList;
}

3、获取角色操作

为了职责统一，将角色相关的操作类单独放在一个包中，和POJO中的类相对应

RoleDao

//获取角色列表
public List<Role> getRoleList(Connection connection) throws SQLException;

RoleDaoImpl

//获取角色列表
@Override
public List<Role> getRoleList(Connection connection) throws SQLException {
	PreparedStatement preparedStatement = null;
	ResultSet resultSet = null;
	List<Role> roleList = new ArrayList<>();

	if (connection != null){
		String sql = "select * from smbms_role";
		Object[] params = {};
		resultSet = BaseDao.execute(connection, preparedStatement, resultSet, sql, params);

		while (resultSet.next()){
			Role role = new Role();
			role.setId(resultSet.getInt("id"));
			role.setRoleName(resultSet.getNString("roleName"));
			role.setRoleCode(resultSet.getString("roleCode"));
			roleList.add(role);
		}
		BaseDao.closeResource(null, preparedStatement, resultSet);
	}
	return roleList;
}

RoleService

//获取角色列表
public List<Role> getRoleList();

RoleServiceImpl

//获取角色列表
@Override
public List<Role> getRoleList() {
	Connection connection = null;
	List<Role> roleList = null;
	try {
		connection = BaseDao.getConnection();
		roleList = roleDao.getRoleList(connection);
	}catch (Exception e){
		e.printStackTrace();
	}finally {
		BaseDao.closeResource(connection, null, null);
	}
	return roleList;
}

4、用户显示的Servlet

1、获取用户前端的数据（查询）
2、判断请求是否需要执行，看参数的值判断
3、为了实现分页，需要计算出当前页、总页数、页面大小
4、用户列表展示
5、返回前端页面

//查询用户列表
public void query(HttpServletRequest req, HttpServletResponse resp){

	//从前端获取数据
	String queryUserName = req.getParameter("queryUserName");
	String temp = req.getParameter("queryUserRole");
	String pageIndex = req.getParameter("pageIndex");
	int queryUserRole = 0;

	//获取用户列表
	UserServiceImpl userService = new UserServiceImpl();
	List<User> userList = null;

	//第一次发送这个请求，一定是第一页，页面大小是固定的
	int pageSize = 5;//可以将这个写入到配置文件中，可以后期动态修改
	int currentPageNo = 1;

	if (queryUserName == null){
		queryUserName = "";
	}
	if (temp != null && !temp.equals("")){
		queryUserRole = Integer.parseInt(temp); //给查询的角色号赋值：0、1、2、3
	}
	if (pageIndex != null){
		currentPageNo = Integer.parseInt(pageIndex);
	}

	//获取用户总数(分页： 上一页， 下一页的情况)
	int totalCount = userService.getUserCount(queryUserName, queryUserRole);
	//总页数支持
	PageSupport pageSupport = new PageSupport();
	pageSupport.setCurrentPageNo(currentPageNo);
	pageSupport.setPageSize(pageSize);
	pageSupport.setTotalCount(totalCount);

	int totalPageCount = pageSupport.getTotalPageCount();//总共是几页

	//控制首页和尾页
	if (currentPageNo < 1){//如果页面小于1，就显示第一页的内容
		currentPageNo = 1;
	}else if (currentPageNo > totalPageCount){//当前页面大于了最后一页，就显示最后一页的
		currentPageNo = totalPageCount;
	}

	//获取用户列表的展示
	userList = userService.getUserList(queryUserName, queryUserRole, currentPageNo, pageSize);
	req.setAttribute("userList", userList);

	RoleServiceImpl roleService = new RoleServiceImpl();
	List<Role> roleList = roleService.getRoleList();
	req.setAttribute("roleList", roleList);

	req.setAttribute("totalCount", totalCount);
	req.setAttribute("currentPageNo", currentPageNo);
	req.setAttribute("totalPageCount", totalPageCount);
	req.setAttribute("queryUserName", queryUserName);
	req.setAttribute("queryUserRole", queryUserRole);

	//返回前端
	try {
		req.getRequestDispatcher("userlist.jsp").forward(req, resp);
	} catch (ServletException e) {
		e.printStackTrace();
	} catch (IOException e) {
		e.printStackTrace();
	}

}

果冻奶酪

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
SMBMS

SMBMS数据库：项目如何搭建：考虑使不使用maven，依赖，jar项目搭建准备工作1、搭建一个mavenweb项目2、配置Tomcat3、测试项目是否跑起来4、导入项目中遇到的jar包：jsp、servlet、MySQL驱动5、创建项目包结构6、编写实体类ORM映射：表–>类映射7、编写基础公共类数据库配置文件driver=com.mysql.cj.jdbc.Driverurl=jdbc:mysql://localhost:3306/smbms?useSSL=
复制链接

扫一扫