白山云科技java-凯发ag旗舰厅登录网址下载

一.导入jar包

org.springframework.boot

spring-boot-starter-web

org.springframework.boot

spring-boot-starter-test

mysql

mysql-connector-java

org.mybatis.spring.boot

mybatis-spring-boot-starter

1.1.1

com.github.pagehelper

pagehelper

4.1.0

2.创建启动类app.java

@springbootapplication

@mapperscan("cn.itsource.springboot.employee.mapper")//扫描mapper的路径

public class ssmapplication {

public static void main(string[] args) {

springapplication.run(ssmapplication.class);

}

}

3.在application.yml添加配置文件

spring:

datasource:

url: jdbc:mysql://localhost:3306/test

driver-class-name: com.mysql.jdbc.driver

password: root

username: root

mybatis:

type-aliases-package: cn.itsource.springboot.employee.domain,cn.itsource.springboot.employee.query

4.编写demomapper

public interface usermapper {

void save(user user);

list querypage(userquery query);

}

5.编写demoservice

@service

@transactional(propagation = propagation.supports,readonly = true)//类级别是只读事务

public class userserviceimpl implements iuserservice {

@autowired

private usermapper usermapper;

@transactional(propagation = propagation.required,readonly = false)

//@transactional 后两个配置是默认值

@override

public void add(user user) {

usermapper.save(user);

// int i = 1/0;

}

@override

public list querypage(userquery query) {

pagehelper.startpage(1, 2); //limit (pagenum-1)*pagesize,pagesize

return usermapper.querypage(query);

}

}

6.编写test

@runwith(springrunner.class)

@springboottest(classes = ssmapplication.class)

public class iuserservicetest {

@autowired

private iuserservice userservice;

@test

public void add()

{

user ww = new user("ww");

system.out.println(ww);//没有id

userservice.add(ww);

system.out.println(ww);//有id

}

@test

public void testlist() throws exception{

//com.github.pagehelper.page --->pagelist(currentpage,pagesizs,totalrecords,totalpages,data)

page list = (page) userservice.querypage(new userquery());

system.out.println(list.getclass());

system.out.println("总记录数:" list.gettotal());

system.out.println("总页数:" list.getpages());

system.out.println("当前页" list.getpagenum());

system.out.println("每页多少条:" list.getpagesize());

for (user o : list) {

system.out.println(o);

}

}

}

xml版本的xml(获取自增id)

/p>

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

//获取自增id

insert into t_user(name) values(#{name})

select * from t_user

annotation版本(获取自增id)

public interface usermapper {

@insert("insert into t_user(name) values(#{name})")

@options(usegeneratedkeys = true,keyproperty = "id",keycolumn = "id")//获取自增id

void save(user user);

}

分页插件的配置

@configuration //相当于我们建了applicationcontext-xxx.xml

public class mybatisconfiguration {

//相当于配置了一个bean

@bean

public pagehelper pagehelper() {

system.out.println("mybatisconfiguration.pagehelper()");

pagehelper pagehelper = new pagehelper();

properties p = new properties();

p.setproperty("offsetaspagenum", "true");

p.setproperty("rowboundswithcount", "true");

p.setproperty("reasonable", "true");

pagehelper.setproperties(p);

return pagehelper;

}

}

总结

以上是凯发ag旗舰厅登录网址下载为你收集整理的白山云科技java_springboot——04ssm的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得凯发ag旗舰厅登录网址下载网站内容还不错，欢迎将凯发ag旗舰厅登录网址下载推荐给好友。