方法一
导入jar包
<dependency> <groupid>org.mybatis</groupid> <artifactid>mybatis-spring</artifactid> <version>2.0.6</version> </dependency>
创建spring-dao.xml
1,配置数据源
<bean id="datasource" class="org.springframework.jdbc.datasource.drivermamagerdatasource"> <property name="driver" value="com.mysql.jdbc.driver"/> <property name="url" value="jdbc:mysql://localhost:3306/yhzz?usessl=true&useunicode=true&characterencoding=utf8"/> <property name="username" value="root"/> <property name="password" value="root"/> </bean>
2,绑定mybaits文件数据源
<bean id="transactionmanager" class="org.springframework.jdbc.datasource.datasourcetransactionmanager"> <property name="datasource" ref="datasource" /> </bean>
3,使用构造器注入
<bean id="sqlsession" class="org.mybaits.spirng.sqlsessiontemplate"> <constructor-arg index="0" ref="sqlsessionfactory"/> </bean>
编写接口和实现累
package com.pojo; import com.dao.usermpil; import java.util.list; public class user implements usermpil { private sqlsessiontemplate sqlsession; public list<user> query() { user mapper= sqlsession.getmapper(user.class); return mapper.query(); } }
package com.dao; import com.pojo.user; import java.util.list; public interface usermpil { list<user> query(); }
测试
package text; import com.pojo.user; import sun.tools.java.classpath; public class text { public static void main(string[] args) { applicationcontext context = new classpathxmlapplicationcontext("spring-dao.xml"); user user= context.getbean("user", user.class); for (user user:user.query) { system.out.println(user); } } }
总结
以上为个人经验,希望能给大家一个参考,也希望大家多多支持代码网。
发表评论