maven+spring整合mybatis.docx
- 文档编号:26163405
- 上传时间:2023-06-17
- 格式:DOCX
- 页数:15
- 大小:18.95KB
maven+spring整合mybatis.docx
《maven+spring整合mybatis.docx》由会员分享,可在线阅读,更多相关《maven+spring整合mybatis.docx(15页珍藏版)》请在冰豆网上搜索。
maven+spring整合mybatis
Maven+Spring整合Mybatis
运行环境:
maven+spring4.0.0+mybatis3.2.4+mybatis-spring1.2.2
一、编辑pom.xml配置文件,添加依赖
1 //maven.apache.org/POM/4.0.0"xmlns: xsi="http: //www.w3.org/2001/XMLSchema-instance" 2xsi: schemaLocation="http: //maven.apache.org/POM/4.0.0http: //maven.apache.org/xsd/maven-4.0.0.xsd"> 3 4 5 6 7 8 9 10 11 12 13 --springframework--> 14 15 16 17 18 19 20 21 22 23 24 25 26 27 --mybatisspring支持--> 28 29 30 31 32 33 --proxool--> 34 35 36 37 38 39 40 41 42 43 44 二、创建实体类: User 45packagecom.darren.models; 46 47importjava.io.Serializable; 48 49publicclassUserimplementsSerializable{ 50 51/** 52* 53*/ 54privatestaticfinallongserialVersionUID=1L; 55 56privateintuid; 57privateStringuserName; 58privateStringpassword; 59 60publicintgetUid(){ 61returnuid; 62} 63 64publicvoidsetUid(intuid){ 65this.uid=uid; 66} 67 68publicStringgetUserName(){ 69returnuserName; 70} 71 72publicvoidsetUserName(StringuserName){ 73this.userName=userName; 74} 75 76publicStringgetPassword(){ 77returnpassword; 78} 79 80publicvoidsetPassword(Stringpassword){ 81this.password=password; 82} 83 84publicstaticlonggetSerialversionuid(){ 85returnserialVersionUID; 86} 87 88@Override 89publicStringtoString(){ 90return"uId: "+this.uid+",Name: "+this.userName+",Pass: "+this.password; 91} 92} 三、创建接口: UserDao 93packagecom.darren.daointerface; 94 95importjava.util.List; 96 97importcom.darren.models.User; 98 99publicinterfaceUserDao{ 100 101publicUserqueryById(intid); 102 103publicvoidsave(Useru); 104 105publicvoidupdate(Useru); 106 107publicvoiddelete(Integerid); 108 109publicList 110} 四、接口实现类: 111packagecom.darren.mybatis; 112 113importjava.util.List; 114 115importorg.mybatis.spring.SqlSessionTemplate; 116importorg.springframework.beans.factory.annotation.Autowired; 117importorg.springframework.stereotype.Repository; 118 119importcom.darren.daointerface.UserDao; 120importcom.darren.models.User; 121 122@Repository 123publicclassUserDaoImplimplementsUserDao{ 124 125@Autowired 126privateSqlSessionTemplatesqlSessionTemplate; 127 128@Override 129publicUserqueryById(intid){ 130return(User)sqlSessionTemplate.selectOne("queryById",3); 131} 132 133@Override 134publicvoidsave(Useru){ 135sqlSessionTemplate.insert("insert-user",u); 136} 137 138@Override 139publicvoidupdate(Useru){ 140sqlSessionTemplate.update("update-user",u); 141} 142 143@Override 144publicvoiddelete(Integerid){ 145sqlSessionTemplate.delete("delete-user",id); 146} 147 148@Override 149publicList 150List 151returnusers; 152} 153 154} 说明: 1、@Repository: spring中的注解,把类注册到spring容器中. 2、@Autowired: 由spring自动注入 五、配置applicationContext.xml 155 xmlversion="1.0"encoding="UTF-8"? > 156 //www.springframework.org/schema/beans" 157xmlns: xsi="http: //www.w3.org/2001/XMLSchema-instance" 158xmlns: context="http: //www.springframework.org/schema/context" 159xmlns: aop="http: //www.springframework.org/schema/aop" 160xmlns: tx="http: //www.springframework.org/schema/tx" 161xsi: schemaLocation="http: //www.springframework.org/schema/beans 162http: //www.springframework.org/schema/beans/spring-beans-3.0.xsd 163http: //www.springframework.org/schema/aop 164http: //www.springframework.org/schema/aop/spring-aop-3.0.xsd 165http: //www.springframework.org/schema/tx 166http: //www.springframework.org/schema/tx/spring-tx-3.0.xsd 167http: //www.springframework.org/schema/context 168http: //www.springframework.org/schema/context/spring-context-3.0.xsd"> 169 170 --采用注释的方式配置bean--> 171 annotation-config/> 172 --配置要扫描的包--> 173 component-scanbase-package="com.darren"> component-scan> 174 175 --加载jdbc.properties配置文件--> 176 177class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> 178 179 180 jdbc.properties 181 182 183 184 185 --配置数据源(连接池,proxool)--> 186 187class="org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy"> 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 --Session工厂--> 204 205 206 --mybatis配置文件--> 207 mybatis.xml"/> 208 209 210 --配置SqlSessionTemplate--> 211 212 213 214 215 六、添加jdbc.properties 216proxool.maxConnCount=10 217proxool.minConnCount=5 218proxool.statistics=1m,15m,1h,1d 219proxool.simultaneousBuildThrottle=30 220proxool.trace=false 221 222jdbc.driverClassName=com.mysql.jdbc.Driver 223jdbc.url=jdbc: mysql: //localhost: 3306/test 224jdbc.username=root 225jdbc.password=root 七、添加mybatis.xml 226 xmlversion="1.0"encoding="UTF-8"? > 227 DOCTYPEconfigurationPUBLIC"-//mybatis.org//DTDConfig3.0//EN""http: //mybatis.org/dtd/mybatis-3-config.dtd"> 228 229 230 231 232 233 --指定映射文件--> 234 235 236 237 八、添加User-sqlmap-mapping.xml 238 xmlversion="1.0"encoding="UTF-8"? > 239 DOCTYPEmapper 240PUBLIC"-//mybatis.org//DTDMapper3.0//EN" 241"http: //mybatis.org/dtd/mybatis-3-mapper.dtd"> 242 243 244 245 246 247 248 249 250 251 252 253 254SELECT 255UID, 256USERNAME, 257PASSWORD 258FROMUSERS 259WHEREUID=#{id} 260 261 262 263insertinto 264users(userName,password)values(#{userName},#{password}) 265 266 267 268UPDATEUSERSSETUSERNAME=#{userName},PASSWORD=#{password}WHEREUID=#{uid} 269 270 271 272DELETEUSERSWHEREUID=#{id} 273 274 275 276SELECT*FROMUSERS 277 278 九、添加测试类: 279packagecom.darren.user; 280 281importjava.util.List; 282 283importorg.junit.Test; 284importorg.junit.runner.RunWith; 285importorg.springframework.beans.factory.annotation.Autowired; 286importorg.springframework.test.context.ContextConfiguration; 287importorg.springframework.test.context.junit4.SpringJUnit4ClassRunner; 288 289importcom.darren.models.User; 290importcom.darren.service.UserService; 291 292@RunWith(SpringJUnit4ClassRunner.class) 293@ContextConfiguration(locations="/applicationContext.xml") 294publicclassUserServiceTest{ 295 296@Autowired 297UserServiceuserService; 298 299@Test 300publicvoidtest
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- maven spring 整合 mybatis