ssm代码：
-----------------------Student 实体类
package com.ssm.book.model;
import lombok.ToString;
import java.util.Date;
import java.util.List;
@ToString
public class Student {
private Integer sid;
private String sname;
private String idcard;
private Integer sage;
private String ssex;
private Date createdate;
public Student(Integer sid, String sname, String idcard, Integer sage, String ssex, Date createdate) {
this.sid = sid;
this.sname = sname;
this.idcard = idcard;
this.sage = sage;
this.ssex = ssex;
this.createdate = createdate;
}
public Student() {
super();
}
public Integer getSid() {
return sid;
}
public void setSid(Integer sid) {
this.sid = sid;
}
public String getSname() {
return sname;
}
public void setSname(String sname) {
this.sname = sname;
}
public String getIdcard() {
return idcard;
}
public void setIdcard(String idcard) {
this.idcard = idcard;
}
public Integer getSage() {
return sage;
}
public void setSage(Integer sage) {
this.sage = sage;
}
public String getSsex() {
return ssex;
}
public void setSsex(String ssex) {
this.ssex = ssex;
}
public Date getCreatedate() {
return createdate;
}
public void setCreatedate(Date createdate) {
this.createdate = createdate;
}
}
-----------------------StudentVo 实体类
package com.ssm.book.model;
import lombok.Data;
import java.util.List;
@Data //setter/getter/toString
public class StudentVo extends Student {
private List ids;
private float min;
private float max;
}
-----------------------StudentMapper 数据访问层（接口）
package com.ssm.book.mapper;
import com.ssm.book.model.Student;
import com.ssm.book.model.StudentVo;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
import java.util.List;
import java.util.Map;
@Repository
public interface StudentMapper {
//1.动态SQL之if标签
List queryByIf(Student student);
// 2.动态SQL之foreach标签（3种方式）
List queryByForeach(StudentVo studentVo);
// 3.参数传递
// 3.1 参数传递之基础类型
List queryById(Integer id);
// 3.2 参数传递之String类型
List queryBySname(@Param("name") String name);
// 3.3 参数传递之实体类型
List queryByStu(Student s);
// 4.模糊查询（3种方式）
List queryByLike(@Param("name") String name);
// 5.查询返回结果集(ResultMap和ResultType)
// 5.1 查询返回结果集之ResultMap
List queryResultMap();
Student querySingleBtId(Integer id);
// 5.2 查询返回结果集之List
List queryByList();
// 5.3 查询返回结果集之T
Student querySingle(Integer id);
// 5.4 查询返回结果集之Map
Map getMap(Integer id);
// 5.5 查询返回结果集之List>
List> getListMap();
// 6.分页查询
List getPager();
// 7.范围查询（特殊字符转移）
List getRange(StudentVo studentVo);
// 8.新增
int insertStu(Student student);
// 9.修改
int updateStu(Student student);
// 10.删除
int deleteStu(Integer sid);
// 11.批量新增
int insertStus(Student student);
}
-----------------------StudentMapper.xml 数据访问层（实现类）
sid, sname, idcard, sage, ssex, createdate
insert into t_student(sname, idcard, sage, ssex)
value (#{sname,jdbcType=VARCHAR}, #{idcard,jdbcType=VARCHAR}, #{sage,jdbcType=INTEGER}, #{ssex,jdbcType=VARCHAR})
insert into t_student
sname,
idcard,
sage,
ssex,
#{sname,jdbcType=VARCHAR},
#{idcard,jdbcType=VARCHAR},
#{sage,jdbcType=INTEGER},
#{createdate,jdbcType=DATE},
update t_student set sname=#{sname,jdbcType=VARCHAR}, idcard=#{idcard,jdbcType=VARCHAR},sage=#{sage,jdbcType=INTEGER}, ssex=#{ssex,jdbcType=VARCHAR}, createdate=#{createdate,jdbcType=DATE} where sid=#{sid}
delete from t_student where sid=#{sid,jdbcType=INTEGER}
-----------------------IStudentService 业务逻辑层（接口）
package com.ssm.book.service;
import com.ssm.book.model.Student;
import com.ssm.book.model.StudentVo;
import com.ssm.book.util.PageBean;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
import java.util.List;
import java.util.Map;
@Repository
public interface IStudentService {
//1.动态SQL之if标签
List queryByIf(Student student);
// 2.动态SQL之foreach标签（3种方式）
List queryByForeach(StudentVo studentVo);
// 3.参数传递
// 3.1 参数传递之基础类型
List queryById(Integer id);
// 3.2 参数传递之String类型
List queryBySname(String name);
// 3.3 参数传递之实体类型
List queryByStu(Student s);
// 4.模糊查询（3种方式）
List queryByLike(String name);
// 5.查询返回结果集(ResultMap和ResultType)
// 5.1 查询返回结果集之ResultMap
List queryResultMap();
Student querySingleBtId(Integer id);
// 5.2 查询返回结果集之List
List queryByList();
// 5.3 查询返回结果集之T
Student querySingle(Integer id);
// 5.4 查询返回结果集之Map
Map getMap(Integer id);
// 5.5 查询返回结果集之List>
List> getListMap();
// 6.分页查询
List getPager(PageBean pageBean);
// 7.范围查询（特殊字符转移）
List getRange(StudentVo studentVo);
// 8.新增
int insertStu(Student student);
// 9.修改
int updateStu(Student student);
// 10.删除
int deleteStu(Integer sid);
// 11.批量新增
int insertStus(Student student);
}
-----------------------StudentServiceImpl 业务逻辑层（实现类）
package com.ssm.book.service.imp;
import com.ssm.book.mapper.StudentMapper;
import com.ssm.book.model.Student;
import com.ssm.book.model.StudentVo;
import com.ssm.book.service.IStudentService;
import com.ssm.book.util.PageBean;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
import java.util.Map;
@Service
public class StudentServiceImpl implements IStudentService {
@Autowired
StudentMapper studentMapper;
@Override
public List queryByIf(Student student) {
return studentMapper.queryByIf(student);
}
@Override
public List queryByForeach(StudentVo studentVo) {
return studentMapper.queryByForeach(studentVo);
}
@Override
public List queryById(Integer id) {
return studentMapper.queryById(id);
}
@Override
public List queryBySname(String name) {
return studentMapper.queryBySname(name);
}
@Override
public List queryByStu(Student s) {
return studentMapper.queryByStu(s);
}
@Override
public List queryByLike(String name) {
return studentMapper.queryByLike(name);
}
@Override
public List queryResultMap() {
return studentMapper.queryResultMap();
}
@Override
public Student querySingleBtId(Integer id) {
return studentMapper.querySingleBtId(id);
}
@Override
public List queryByList() {
return studentMapper.queryByList();
}
@Override
public Student querySingle(Integer id) {
return studentMapper.querySingle(id);
}
@Override
public Map getMap(Integer id) {
return studentMapper.getMap(id);
}
@Override
public List> getListMap() {
return studentMapper.getListMap();
}
@Override
public List getPager(PageBean pageBean) {
return studentMapper.getPager();
}
@Override
public List getRange(StudentVo studentVo) {
return studentMapper.getRange(studentVo);
}
@Override
public int insertStu(Student student) {
return studentMapper.insertStu(student);
}
@Override
public int updateStu(Student student) {
return studentMapper.updateStu(student);
}
@Override
public int deleteStu(Integer sid) {
return studentMapper.deleteStu(sid);
}
@Override
public int insertStus(Student student) {
return studentMapper.insertStus(student);
}
}
-----------------------BaseTest
package com.ssm.book.service.imp;
import org.junit.runner.RunWith;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = {"classpath:spring.xml"})
public class BaseTest {
}
-----------------------StudentServiceImplTest
package com.ssm.book.service.imp;
import com.ssm.book.mapper.StudentMapper;
import com.ssm.book.model.Student;
import com.ssm.book.model.StudentVo;
import com.ssm.book.service.IStudentService;
import com.ssm.book.util.PageBean;
import org.junit.Test;
import org.springframework.beans.factory.annotation.Autowired;
import java.util.Arrays;
import java.util.List;
import static org.junit.Assert.*;
public class StudentServiceImplTest extends BaseTest {
@Autowired
IStudentService studentService;
@Test
public void demo() {
//1.
// Student s=new Student();
// s.setSname("张三");
// List stu = studentService.queryByIf(s);
// stu.forEach(System.out::println);
//2.
// StudentVo s=new StudentVo();
// s.setIds(Arrays.asList(new Integer[]{1,3,5}));
// List stud = studentService.queryByForeach(s);
// stud.forEach(System.out::println);
//3.1
// System.out.println(studentService.queryById(1));
//3.2
// System.out.println(studentService.queryBySname("李四"));
//3.3
// Student s=new Student();
// s.setSname("赵六");
// List list = studentService.queryByStu(s);
// list.forEach(System.out::println);
// 4.
// studentService.queryByLike("%六%").forEach(System.out::println); ----①
// studentService.queryByLike("六").forEach(System.out::println); ----②③
// 5.1
// studentService.queryResultMap().forEach(System.out::println);
// System.out.println(studentService.querySingleBtId(2));
// 5.2
// studentService.queryByList().forEach(System.out::println);
//5.3
// System.out.println(studentService.querySingle(4));
// 5.4
// System.out.println(studentService.getMap(5));
// 5.5
// studentService.getListMap().forEach(System.out::println);
// 6.
// PageBean pageBean=new PageBean();
// pageBean.setRows(2);
// List pager = studentService.getPager(pageBean);
// System.out.println("总记录数："+pageBean.getTotal());
// pager.forEach(System.out::println);
// 7.
// StudentVo studentVo=new StudentVo();
// studentVo.setMin(10f);
// studentVo.setMax(19f);
// studentService.getRange(studentVo).forEach(System.out::println);
// 8.
// Student s=new Student();
// s.setSname("hh");
// s.setIdcard("5666");
// s.setSage(9);
// studentService.insertStu(s);
// 9.
// Student s=new Student();
// s.setSname("hh");
// s.setIdcard("555");
// s.setSage(9);
// s.setSid(6);
// studentService.updateStu(s);
// 10.删除
studentService.deleteStu(6);
}
}
前端：
{ts}} -->
查询
添加
移除
修改
取 消
确 定
