在SSM环境已经搭建好的基础上:
创建UserDao进行登录,和注册的函数:
package com.zjj.dao;
import com.zjj.pojo.User;
import java.util.List;
public interface UserDao {
//查询所有
public List<User> queryAllUsers();
// 登录
public User queryUserByUserNameAndPwd(User user);
// 注册
public int insertUser(User user);
}
UserMapper.xml
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--namespace 值必须和接口路径保持一致-->
<mapper namespace="com.zjj.dao.UserDao">
<!--只写User因为那边定义了别名-->
<resultMap id="userResultMap" type="User">
<!-- private Long id;
private String username;
private String password;
private Integer isadmin;-->
<id property="id" column="id"/>
<result property="username" column="username"/>
<result property="password" column="password"/>
<result property="isadmin" column="isadmin"/>
</resultMap>
<select id="queryAllUsers" resultMap="userResultMap">
select *from tb_user
</select>
<select id="queryUserByUserNameAndPwd" resultMap="userResultMap" parameterType="User">
select *from tb_user where username=#{username} and password=#{password}
</select>
<insert id="insertUser" parameterType="User">
-- id是自增的可以随便的设置
insert into tb_user values(0,#{username},#{password},#{isadmin})
</insert>
</mapper>
UserService:
package com.zjj.service;
import com.zjj.pojo.User;
import java.util.List;
public interface UserService {
// 查询所有
public List<User> queryALlUsers();
public User queryUserByUserNameAndPwd(User user);
//注册
boolean insertUser(User user);
}
UserServiceimpl:
package com.zjj.service.impl;
import com.zjj.dao.UserDao;
import com.zjj.pojo.User;
import com.zjj.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import java.util.List;
@Service
@Transactional //查询的事务性要么一起成功
public class UserServiceImpl implements UserService {
@Autowired //把UserDao注入
private UserDao userDao;
@Override
public List<User> queryALlUsers() {
return userDao.queryAllUsers();
}
@Override
public User queryUserByUserNameAndPwd(User user) {
return userDao.queryUserByUserNameAndPwd(user);
}
@Override
public boolean insertUser(User user) {
int row = userDao.insertUser(user);
if (row>0){
return true;
}
return false;
}
}
还有:
Student类:
package com.zjj.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import java.util.Date;
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Student {
Integer sid;
String sname;
Date birthday;
String address;
String photo;//头像
}
另外一些知识点:
TomCat启动后的默认界面:
web.xml文件中:
<welcome-file-list>
<welcome-file>register.jsp</welcome-file>
</welcome-file-list>
stuList.jsp
<%--
Created by IntelliJ IDEA.
User: CourageAndLove
Date: 2021/5/17
Time: 11:48
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<center>
<h2>学生管理系统</h2>
<table>
<tr>
<td>编号</td>
<td>学生姓名 </td>
<td>学生生日</td>
<td>学生地址</td>
<td>学生照片</td>
<td><a href="">添加学生信息</a></td>
</tr>
<c:forEach items="${stuList}" var="s">
<tr>
<td>${s.sid}</td>
<td>${s.sname}</td>
<%-- springmvc文件中已经配置了FomattingConversion--%>
<td> <fmt:formatDate value="${s.birthday}" pattern="yyyy-MM-dd hh:mm:ss"></fmt:formatDate> </td>
<td>${s.address}</td>
<%-- 图片的显示, ${s.photo取到的是图片的路径}--%>
<td>
<img src=" ${s.photo}" width="150px" height="150px">
</td>
<td >
<a href="" style="color: red">删除</a>
</td>
<td>
<a href=""> 修改</a>
</td>
</tr>
</c:forEach>
</table>
</center>
</body>
</html>
login.jsp:
<html>
<body>
<center>
<h1>登录页面</h1>
<form action="login" method="post">
<table>
<tr>
<td>用户名</td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td>密码</td>
<td><input type="password" name="password"></td>
</tr>
<tr>
<td><input type="submit" value="登录"></td>
<td><a href="register.jsp">立即注册</a></td>
</tr>
</table>
</form>
</center>
</body>
</html>
register.jsp:
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<center>
<h1>注册页面</h1>
<form action="register" method="post">
<table>
<tr>
<td>用户名</td>
<td><input type="text" name="username"></td>
</tr>
<tr>
<td>密码</td>
<td><input type="password" name="password"></td>
</tr>
<%-- 单选按钮--%>
<tr>
<td><input type="radio" name="isadmin" value="1">管理员</td>
<%-- 默认选中为普通用户--%>
<td><input type="radio" name="isadmin" value="2" checked>普通用户</td>
</tr>
<tr>
<td><input type="submit" value="注册"></td>
<td><input type="reset" value="重置"></td>
</tr>
</table>
</form>
</center>
</body>
</html>