Spring+Mybatis整合
- 整体结构
- 所需jar包
- 数据库
- 数据库名称
- mybatis_db
- 表名称
- user
- 表结构
- 数据库名称
-
代码
-
com.peng.mapper
-
UserMapper
package com.peng.mapper; import java.util.List; import org.springframework.stereotype.Repository; import com.peng.pojo.User; @Repository(value = "userMapper") public interface UserMapper { // 查询全部的User public List<User> findAll(); }
-
-
com.peng.pojo
-
User
package com.peng.pojo; public class User { private int id; private String name; private int age; public User() { super(); } public User(int id, String name, int age) { super(); this.id = id; this.name = name; this.age = age; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public int getAge() { return age; } public void setAge(int age) { this.age = age; } @Override public String toString() { return "编号:" + id + ",姓名:" + name + ",年龄:" + age; } }
-
UserMapper
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.peng.mapper.UserMapper"> <select id="findAll" resultType="com.peng.pojo.User"> select * from user </select> </mapper>
-
-
com.peng.service
-
UserService
package com.peng.service; import java.util.List; import com.peng.pojo.User; public interface UserService { public List<User> findAll(); }
-
UserServiceImpl
package com.peng.service; import java.util.List; import com.peng.pojo.User; public interface UserService { public List<User> findAll(); }
-
-
com.peng.test
-
Test
package com.peng.test; import java.util.List; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import com.peng.pojo.User; import com.peng.web.UserServlet; public class Test { @org.junit.Test public void findAllTest() { ApplicationContext ac = new ClassPathXmlApplicationContext( "applicationContext.xml"); UserServlet us = (UserServlet) ac.getBean("userServlet"); List<User> findAll = us.findAll(); for (User user : findAll) { System.out.println(user); } } }
-
-
com.peng.web
-
UserServlet
package com.peng.web; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Qualifier; import org.springframework.stereotype.Controller; import com.peng.pojo.User; import com.peng.service.UserService; @Controller(value = "userServlet") public class UserServlet { @Autowired @Qualifier(value = "userService") private UserService userService; public List<User> findAll() { return userService.findAll(); } }
-
-
配置文件
-
applicationContext.xml
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd "> <!-- 扫描包 --> <context:component-scan base-package="com.peng"></context:component-scan> <!-- 扫描注解 --> <context:annotation-config></context:annotation-config> <!-- sql的会话工厂 --> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <!-- 引入数据源 --> <property name="dataSource" ref="c3p0dataSource"></property> <!-- 引入核心配置文件 --> <property name="configLocation" value="classpath:/sqlMapConfig.xml"></property> <!-- 引入映射文件 --> <property name="mapperLocations" value="classpath:/com/peng/pojo/*.xml"></property> </bean> <!-- Mapper接口的扫描器 --> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.peng.mapper"></property> </bean> <!-- 配置文件 --> <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="location" value="classpath:/jdbc_config.properties"></property> </bean> <!--c3p0 --> <bean id="c3p0dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="${jdbc.driver}"></property> <property name="jdbcUrl" value="${jdbc.url}"></property> <property name="user" value="${jdbc.user}"></property> <property name="password" value="${jdbc.password}"></property> <property name="minPoolSize" value="3"></property> <!--最小连接数 --> <property name="initialPoolSize" value="5"></property> <!-- 初始化连接数 --> <property name="acquireIncrement" value="3"></property> <!-- 每次增长的个数 --> </bean> </beans>
-
jdbc_config.properties
jdbc.user=root jdbc.password=root jdbc.url=jdbc\:mysql\://localhost\:3306/mybatis_db jdbc.driver=com.mysql.jdbc.Driver
-
log4j.properties
log4j.rootLogger=DEBUG, Console #Console log4j.appender.Console=org.apache.log4j.ConsoleAppender log4j.appender.Console.layout=org.apache.log4j.PatternLayout log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n log4j.logger.java.sql.ResultSet=INFO log4j.logger.org.apache=INFO log4j.logger.java.sql.Connection=DEBUG log4j.logger.java.sql.Statement=DEBUG log4j.logger.java.sql.PreparedStatement=DEBUG
- sqlMapConfig.xml
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> </configuration>
-
-