package cn.edu.data;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Repository;
import java.util.List;
@Repository
public interface StudentMapper {
@Select("select id,studentID, name, class as aclass from student where ID = #{ID}")
Student selectOne(String studentID);
@Select("select id,studentID, name, class as aclass from student")
List selectAll();
@Insert("insert into student (studentID,name,class) values (#{studentID},#{name},#{aclass})")
int insert(Student student);
@Delete("delete from student where studentID = #{studentID}")
int delete(String studentID);
@Update("update student set studentID=#{studentID},name=#{name},class=#{aclass} where studentID=#{studentID}")
int update(Student student);
}
2.4 User
package cn.edu.data;
public class User{
private int id;
private String name;
private String password;
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public User(){}
public User(int id,String name){
this.setId(id);
this.setName(name);
}
public int getId(){
return this.id;
}
public void setId(int id){
this.id = id;
}
public String getName(){
return this.name;
}
public void setName(String name){
this.name = name;
}
}
2.5 UserMapper
package cn.edu.data;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Repository;
import java.util.List;
@Repository
public interface UserMapper {
@Select("select * from User where name=#{name}")
User selectOne(String name);
@Select("select * from User")
List selectAll();
@Insert("insert into user (name,password) values (#{name},#{password})")
void insert(User user);
@Delete("delete from user where id = #{id}")
void delete(int id);
@Update("update user set name=#{name},password=#{password} where id=#{id} ")
void update(User user);
}
2.6 UserController
package cn.edu.springmvc.login;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
import cn.edu.data.*;
@Controller // 控制器注解
@RequestMapping("/login") // 类中的请求映射注解
public class UserController{ // 控制器类
//自动装配Mybatis User映射器
@Autowired
UserMapper usermapper;
@RequestMapping("/check")
public String hello(User user, Model model){
// 视图模型对象初始化
ModelAndView modelAndView = new ModelAndView();
User user_test= (User)usermapper.selectOne(user.getName());
if(user_test.getPassword().equals(user.getPassword()))
{
modelAndView.addObject(user);
return "redirect:/student/selectall";
}
else
{
model.addAttribute("msg", "登录密码或用户名错误！！");
return "error";
}
}
//查询全部用户
@RequestMapping("/selectall")
public String select(Model model){
//ModelAndView modelAndView = new ModelAndView();
List user_list = (List)usermapper.selectAll();
/*for(User user:user_list)
System.out.println(user.getId()+" "+user.getName()+" "+user.getPassword());*/
model.addAttribute("user_list",user_list);
return "showList";
}
//插入一条记录的录入视图
@RequestMapping("/adduser")
public String addUser() {
return "AddUser";
}
//插入一条记录
@RequestMapping("/insert")
public String insert(User user) {
usermapper.insert(user);
return "hello";
}
@RequestMapping("/delete")
public String delete(User user) {
usermapper.delete(user.getId());
return "hello";
}
@RequestMapping("/update")
public String update(User user) {
usermapper.update(user);
return "hello";
}
}
<?xml version="1.0" encoding="UTF-8"?>
Archetype Created Web Applicationorg.springframework.web.context.ContextLoaderListenercontextConfigLocationclasspath*:springmvc.xmldispatcherServletorg.springframework.web.servlet.DispatcherServletcontextConfigLocation1dispatcherServlet/log4jConfigLocationclasspath:log4j.properties