springboot 简单的整合mybaties实现web数据查询

本是古典何须时尚 2022-06-18 07:25 230阅读 0赞

今天闲的没事爬了下springboot 整合mybaties的吭 这里总结一下:

1:pox.xml

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    	<modelVersion>4.0.0</modelVersion>
    	<groupId>mvc_boot</groupId>
    	<artifactId>mvc_boot</artifactId>
    	<version>0.0.1-SNAPSHOT</version>
    	<name>mvc_boot</name>
    	<url>http://maven.apache.org</url>
    	<description>mvc_boot</description>
    	
    	<parent>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-parent</artifactId>
    		<version>1.4.0.BUILD-SNAPSHOT</version>
    	</parent>
    	<properties>
    		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    		<shiro.version>1.2.3</shiro.version>
    		<spring.security.version>3.1.3.RELEASE</spring.security.version>
    		<tomcat.version>7.0.59</tomcat.version>
    	</properties>
    	
    	<dependencies>
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-web</artifactId>
    		</dependency>
    
    		
    
    		
    		<dependency>
    			<groupId>org.mybatis</groupId>
    			<artifactId>mybatis</artifactId>
    			<version>3.4.0</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>org.mybatis.spring.boot</groupId>
    			<artifactId>mybatis-spring-boot-starter</artifactId>
    			<version>1.1.1</version>
    		</dependency>
    
    		<dependency>
    			<groupId>tk.mybatis</groupId>
    			<artifactId>mapper</artifactId>
    			<version>3.3.7</version>
    		</dependency>
    
    		
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    		</dependency>
    
    		<dependency>
    			<groupId>javax.servlet</groupId>
    			<artifactId>servlet-api</artifactId>
    			<version>2.5</version>
    			<scope>provided</scope>
    		</dependency>
    	</dependencies>
    
    	
    	<build>
    		<plugins>
    			<plugin>
    				<groupId>org.springframework.boot</groupId>
    				<artifactId>spring-boot-maven-plugin</artifactId>
    				<dependencies>
    					
    					<dependency>
    						<groupId>org.springframework</groupId>
    						<artifactId>springloaded</artifactId>
    					</dependency>
    				</dependencies>
    			</plugin>
    		</plugins>
    	</build>
    
    	
    	
    	<repositories>
    		<repository>
    			<id>spring-snapshots</id>
    			<url>http://repo.spring.io/snapshot</url>
    			<snapshots>
    				<enabled>true</enabled>
    			</snapshots>
    		</repository>
    		<repository>
    			<id>spring-milestones</id>
    			<url>http://repo.spring.io/milestone</url>
    		</repository>
    	</repositories>
    	<pluginRepositories>
    		<pluginRepository>
    			<id>spring-snapshots</id>
    			<url>http://repo.spring.io/snapshot</url>
    		</pluginRepository>
    		<pluginRepository>
    			<id>spring-milestones</id>
    			<url>http://repo.spring.io/milestone</url>
    		</pluginRepository>
    	</pluginRepositories>
    </project>
    
    </project>

2.创建一个springboot的 核心Application.class类

package com.mvc.app;
    
    import javax.sql.DataSource;
    
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.apache.log4j.Logger;
    import org.mybatis.spring.SqlSessionFactoryBean;
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    import org.springframework.boot.context.properties.ConfigurationProperties;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.ComponentScan;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.jdbc.datasource.DataSourceTransactionManager;
    import org.springframework.transaction.PlatformTransactionManager;
    
    @Configuration
    @EnableAutoConfiguration
    @SpringBootApplication
    @ComponentScan
    @MapperScan("com.mvc.mapper")
    public class Application {
    	private static Logger logger = Logger.getLogger(Application.class);
    
    	// DataSource配置
    	@Bean
    	@ConfigurationProperties(prefix = "spring.datasource")
    	public DataSource dataSource() {
    		return new org.apache.tomcat.jdbc.pool.DataSource();
    	}
    
    	// 提供SqlSeesion
    	@Bean
    	public SqlSessionFactory sqlSessionFactoryBean() throws Exception {
    		SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
    		sqlSessionFactoryBean.setDataSource(dataSource());
    		// PathMatchingResourcePatternResolver resolver = new
    		// PathMatchingResourcePatternResolver();
    		// sqlSessionFactoryBean.setMapperLocations(resolver
    		// .getResources("classpath:/mybatis/*.xml"));
    		return sqlSessionFactoryBean.getObject();
    	}
    
    	@Bean
    	public PlatformTransactionManager transactionManager() {
    		return new DataSourceTransactionManager(dataSource());
    	}
    
    	/**
    	 * Main Start
    	 */
    	public static void main(String[] args) {
    		SpringApplication.run(Application.class, args);
    		logger.info("============= SpringBoot Start Success =============");
    	}
    
    }

3,pojo 类 User.class

package com.mvc.app.pojo;
    
    import java.io.Serializable;
    
    public class User implements Serializable {
    
    	private static final long serialVersionUID = 1L;
    	public int id;
    	public String uname;
    	public String pwd;
    	public String addr;
    
    	/**
    	 * @return the id
    	 */
    	public int getId() {
    		return id;
    	}
    
    	/**
    	 * @param id
    	 *            the id to set
    	 */
    	public void setId(int id) {
    		this.id = id;
    	}
    
    	/**
    	 * @return the uname
    	 */
    	public String getUname() {
    		return uname;
    	}
    
    	/**
    	 * @param uname
    	 *            the uname to set
    	 */
    	public void setUname(String uname) {
    		this.uname = uname;
    	}
    
    	/**
    	 * @return the pwd
    	 */
    	public String getPwd() {
    		return pwd;
    	}
    
    	/**
    	 * @param pwd
    	 *            the pwd to set
    	 */
    	public void setPwd(String pwd) {
    		this.pwd = pwd;
    	}
    
    	/**
    	 * @return the addr
    	 */
    	public String getAddr() {
    		return addr;
    	}
    
    	/**
    	 * @param addr
    	 *            the addr to set
    	 */
    	public void setAddr(String addr) {
    		this.addr = addr;
    	}
    
    	/*
    	 * (non-Javadoc)
    	 * 
    	 * @see java.lang.Object#toString()
    	 */
    	@Override
    	public String toString() {
    		return "User [id=" + id + ", uname=" + uname + ", pwd=" + pwd
    				+ ", addr=" + addr + "]";
    	}
    
    }

4, UserMapper  接口

package com.mvc.app.mapper;
    
    import org.apache.ibatis.annotations.Mapper;
    import org.apache.ibatis.annotations.Param;
    import org.apache.ibatis.annotations.Select;
    
    import com.mvc.app.pojo.User;
    
    @Mapper
    public interface UserMapper {
    
    	@Select("select * from user where id = #{id}")
    	User findById(@Param("id") int id);
    
    }

5,HelloController 控制层

package com.mvc.app.controller;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RequestMethod;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    import com.mvc.app.mapper.UserMapper;
    import com.mvc.app.pojo.User;
    
    @Controller
    @RequestMapping(value = "/cs")
    public class HelloController {
    
    	@Autowired
    	private UserMapper userMapper;
    
    	@ResponseBody
    	@RequestMapping(value = "/test", method = RequestMethod.GET)
    	public String index() {
    		User user = userMapper.findById(1);
    		System.err.println("AAAAAAAAAAAAAAAAAAAAA");
    		return user.toString();
    	}
    
    }

6.application.properties

spring.datasource.url=jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=gbk&zeroDateTimeBehavior=convertToNull
    spring.datasource.username=root
    spring.datasource.password=1234
    spring.datasource.driver-class-name=com.mysql.jdbc.Driver

7,然后运行  Application.java里面的 main方法

![Center][]

8,继续调用 hellocon...控制层的方法开始访问

![Center 1][]

9,注意  Application 必须在根目录下   不然它扫描不到  控制层的类  导致无发访问控制层的方法

10 整体结构如下

![Center 2][]

就是单纯的 连上数据 调用mybaties  查询了一下数据   然后返回数据

新手发帖   大神勿喷

源码 dome 连接  http://download.csdn.net/detail/wangbo54979/9800480

[Center]: /images/20220618/f313313ff8ac4be3b0a1fbe4c31c02ab.png
[Center 1]: /images/20220618/68b75da318e24828ab42c0135425cfa0.png
[Center 2]: /images/20220618/6df123747577474faa46e5e11a5c28b6.png