maven中的操作
<properties>
<!--在這個标記下配置常量-->
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.7</maven.compiler.source>
<maven.compiler.target>1.7</maven.compiler.target>
<spring.version>5.1.5.RELEASE</spring.version>
<!--常量版本太多容易管理定義一個常量隻要跟這個包版本一緻找這個常量即可-->
</properties>
—————————————————————————————
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spring.version}</version>
<!--使用常量通過常量名來調用-->
</dependency>
需要的jar:
資料資料源c3p0
Spring包
mybatis包
xml配置:注意Spring的xml檔案不要和mybatis的xml檔案放在一起
這裡的配置是最最重要的因為 相關操作依賴都在這裡面配置
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd">
<!--注解配置-->
<context:annotation-config></context:annotation-config>
<context:component-scan base-package="com.sun.SpringAndMybatis"></context:component-scan>
<!--事務管理者-->
<tx:annotation-driven proxy-target-class="true" transaction-manager="transactionManager"/>
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!--資料庫連結-->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="com.mysql.jdbc.Driver"/>
<property name="jdbcUrl" value="jdbc:mysql://localhost:3306/test2?useUnicode=true&
characterEncoding=UTF-8&useSSL=false"/>
<property name="user" value="root"/>
<property name="password" value="Sb1996350."/>
<property name="maxPoolSize" value="3"/>
<property name="minPoolSize" value="1"/>
</bean>
<!--建立mybatis對象工廠sqlSessionFactoryBean-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<!--資料源對象 将dataSource對象放入、屬性dataSource中-->
<!--相應的配置找裡面的屬性進行配置即可-->
<!--mybatis配置的xml路徑-->
<property name="mapperLocations" value="classpath:mybatis/*.xml"></property>
</bean>
<!--掃描接口-->
<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<!--掃描mapper映射接口-->
<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory">
<!--value通過名字來查找sqlSessionFactory對象-->
</property>
<property name="basePackage" value="com.sun.SpringAndMybatis.Dao"/>
</bean>
</beans>
其餘操作就跟mybatis操作是一樣的
package com.sun.SpringAndMybatis;
import com.sun.SpringAndMybatis.Dao.Stu;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
public class Test2 {
public static void main(String[] args) {
ApplicationContext applicationContext = new ClassPathXmlApplicationContext("app.xml");
Test test = applicationContext.getBean(Test.class);
Stu stu = test.Select(5);
System.out.println(stu.toString());
}
}
@Component
@Transactional
public class Test {
@Autowired
private StuMapper stuMapper;//引用接口 通過标記将對象指派給他
public void rgeUser(Integer sid, String sname, String address) {
Stu stu = new Stu();
stu.setAddress(address);
stu.setSname(sname);
stuMapper.insertSelective(stu);
}
public Stu Select(Integer sid) {
Stu stu = stuMapper.selectByPrimaryKey(sid);
return stu;
}
}