实习第四天心得

在昨天创建了SQL数据库，然后开始写增删改查。
具体代码如下：

在dao文件之中
public interface UserDao {
//查询全部
List findAllUser();
//新增
void addUser(User user);
//删除
void deleteUser(int id);
//模糊查询
List findUser(String name);
}

编写完dao文件之后，我们要在Mapping文件之中写SQL语句

<?xml version="1.0" encoding="UTF-8" ?> select * from tb_user insert into tb_user(id,name,passward) values (#{id},#{name},#{passward})

</insert>
<!--删除-->
<delete id="deleteUser" parameterType="java.lang.Integer">
        delete from tb_user where id=#{id}
</delete>
<!--模糊查询-->
<select id="findUser" parameterType="java.lang.String" resultType="com.soft.bean.User">
   Select * from tb_user where name Like concat ("%", #{name},"%")
</select>

在UserServices里面新加方法： package com.soft.service;

import com.soft.bean.User;

import java.util.List;

public interface UserService {

List<User> findAllUser();
void  addUser(User user);
void  deleteUser(int id);
List<User> findUser(String name);

}
然后在impl里面实现这个方法

age com.soft.service.impl;

import com.soft.bean.User;
import com.soft.dao.UserDao;
import com.soft.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
@Service
public class UserServiceImp implements UserService {

@Autowired
private UserDao userDao;

@Override
public List<User> findAllUser() {
    return userDao.findAllUser();
}

@Override
public void addUser(User user) {
    userDao.addUser(user);
}

@Override
public void deleteUser(int id) {
    userDao.deleteUser(id);
}

@Override
public List<User> findUser(String name) {
    return userDao.findUser(name);
}

}

随后在控制器之中编写方法：
package com.soft.controller;

import com.soft.bean.User;
import com.soft.service.UserService;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;

import java.util.List;

@Controller
@RequestMapping(“user”)
public class UserController {
private final Logger log = LoggerFactory.getLogger(UserController.class);
@Autowired
private UserService userService;

//查询所有
@RequestMapping("findALlUser.do")
public ModelAndView findAllUser(){
    //调用Service 方法，去查询得到结果
    List<User> userList = userService.findAllUser();
    //为了进行返回值的传递，需要把返回值封装到Spring内置到ModeAndView
    ModelAndView mv = new ModelAndView();
    mv.addObject("userList",userList);
    mv.setViewName("user-list");
    return mv;
}
//增加
@RequestMapping("/addUser")
public String addUser(User user){
    //1.调用service方法,得到结果
    userService.addUser(user);

    return "redirect:findALlUser.do";
}
//删除
@RequestMapping("/delUser.do")
public String delUser(int id){
    log.error("id:" +id +"");
    userService.deleteUser(id);
    return "redirect:findALlUser.do";
}
//查询所有
@RequestMapping("findUser.do")
public ModelAndView findUser(String name){
    //调用Service 方法，去查询得到结果
    //log.error(""+name);
    List<User> userList1 = userService.findUser(name);
    //为了进行返回值的传递，需要把返回值封装到Spring内置到ModeAndView
    ModelAndView mv1 = new ModelAndView();
    log.error(userList1.toString());
    log.error(name);
    mv1.addObject("userList",userList1);
    mv1.setViewName("user-list");
    return mv1;
}

}