新公司使用 MyBatis,為快速上手,基於 Maven 從零搭建 SSM 整合項目,記錄全過程、依賴版本選型、核心配置及踩坑避坑。
Unsupported major.minor version 52.0)unknown system variable 'tx_read_only')maven-archetype-webappProperties → Java Compiler / Build Path → 1.8.settings/org.eclipse.wst.common.project.facet.core.xml 設為 3.0web.xml 文件頭為 Servlet 3.0 規範<properties>
<spring.version>4.2.5.RELEASE</spring.version>
<mybatis.version>3.4.0</mybatis.version>
<mybatis-spring.version>1.3.0</mybatis-spring.version>
<jackson.version>2.7.4</jackson.version>
</properties>
<dependencies>
<!-- Spring 核心模組 -->
<dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId><version>${spring.version}</version></dependency>
<dependency><groupId>org.springframework</groupId><artifactId>spring-webmvc</artifactId><version>${spring.version}</version></dependency>
<dependency><groupId>org.springframework</groupId><artifactId>spring-jdbc</artifactId><version>${spring.version}</version></dependency>
<dependency><groupId>org.springframework</groupId><artifactId>spring-tx</artifactId><version>${spring.version}</version></dependency>
<dependency><groupId>org.springframework</groupId><artifactId>spring-test</artifactId><version>${spring.version}</version><scope>test</scope></dependency>
<!-- MyBatis -->
<dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>${mybatis.version}</version></dependency>
<dependency><groupId>org.mybatis</groupId><artifactId>mybatis-spring</artifactId><version>${mybatis-spring.version}</version></dependency>
<!-- 數據庫與連接池 -->
<dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>5.1.6</version></dependency>
<dependency><groupId>com.alibaba</groupId><artifactId>druid</artifactId><version>1.0.20</version></dependency>
<!-- JSON -->
<dependency><groupId>com.fasterxml.jackson.core</groupId><artifactId>jackson-databind</artifactId><version>${jackson.version}</version></dependency>
<dependency><groupId>com.alibaba</groupId><artifactId>fastjson</artifactId><version>1.2.12</version></dependency>
<!-- 其他 -->
<dependency><groupId>javax</groupId><artifactId>javaee-api</artifactId><version>7.0</version></dependency>
<dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>3.8.1</version><scope>test</scope></dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.5.1</version>
<configuration><source>1.8</source><target>1.8</target></configuration>
</plugin>
</plugins>
</build>
com.chit.mvn
├── bean # 實體類 User
├── dao # Mapper 接口 IUserDao
├── service # Service 接口 IUserService
├── service.impl # Service 實現 UserServiceImpl
├── mapper # Mapper XML 文件
└── test # 測試類
jdbc.username=root
jdbc.password=root
jdbc.url=jdbc:mysql://localhost/mydatabase?characterEncoding=utf8&useSSL=true
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.initialSize=5
jdbc.maxActive=15
<context:property-placeholder location="classpath:jdbc.properties"/>
<context:component-scan base-package="com.chit.*"/>
<context:annotation-config/>
<!-- Druid 數據源 -->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
<property name="url" value="${jdbc.url}"/>
<property name="driverClassName" value="${jdbc.driverClassName}"/>
<property name="initialSize" value="${jdbc.initialSize}"/>
<property name="maxActive" value="${jdbc.maxActive}"/>
<property name="maxWait" value="60000"/>
<property name="validationQuery" value="SELECT 'x'"/>
<property name="testWhileIdle" value="true"/>
</bean>
<!-- SqlSessionFactory -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<property name="mapperLocations" value="classpath:com/chit/mvn/mapper/*.xml"/>
<property name="typeAliasesPackage" value="com.chit.mvn.bean"/> <!-- 實體類別名簡寫 -->
</bean>
<!-- Mapper 掃描器:自動代理 Dao 接口 -->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.chit.mvn.dao"/>
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
</bean>
<!-- 事務管理 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<tx:annotation-driven transaction-manager="transactionManager"/>
<mapper namespace="com.chit.mvn.dao.IUserDao">
<insert id="insertUser" parameterType="User">
insert into s_user(id,name,salary,job) values(#{id},#{name},#{salary},#{job})
</insert>
<select id="selectUser" parameterType="int" resultType="User">
select * from s_user where id=#{id}
</select>
</mapper>
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = "classpath:applicationContext.xml")
public class MvnTest {
@Autowired private IUserService userService;
@Test public void testCRUD() {
User u = new User(); u.setId(1); u.setName("Jack"); u.setJob("Teacher"); u.setSalary(10000);
userService.addUser(u);
System.out.println(userService.findUser(1)); // 輸出: User [id=1, name=Jack, salary=10000, job=Teacher]
}
}
ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext.xml");
IUserService service = ctx.getBean(IUserService.class);
// 同樣可正常增刪改查
52.0 錯誤。parameterType/resultType 可直接用簡類名。SELECT 'x'(MySQL)或 SELECT 1 FROM DUAL(Oracle),啟用 testWhileIdle 保證連接有效性。
SSM 整合核心在於:DataSource → SqlSessionFactory → MapperScannerConfigurer → 事務管理 四步走。掌握這條主線,配置不再迷茫。