- 获取SqlSession进行数据库操作
三.开始搭建SSH
- .maven引入jar包
junit
junit
4.11
test
org.springframework
spring-core
${spring.version}
org.springframework
spring-web
${spring.version}
org.springframework
spring-oxm
${spring.version}
org.springframework
spring-tx
${spring.version}
org.springframework
spring-jdbc
${spring.version}
org.springframework
spring-webmvc
${spring.version}
org.springframework
spring-aop
${spring.version}
org.springframework
spring-context-support
${spring.version}
org.springframework
spring-test
${spring.version}
org.mybatis
mybatis
${mybatis.version}
org.mybatis
mybatis-spring
1.2.2
javax
javaee-api
7.0
mysql
mysql-connector-java
5.1.30
commons-dbcp
commons-dbcp
1.2.2
jstl
jstl
1.2
log4j
log4j
${log4j.version}
com.alibaba
fastjson
1.1.41
org.slf4j
slf4j-api
${slf4j.version}
org.slf4j
slf4j-log4j12
${slf4j.version}
org.codehaus.jackson
jackson-mapper-asl
1.9.13
commons-fileupload
commons-fileupload
1.3.1
commons-io
commons-io
2.4
commons-codec
commons-codec
1.9
这里maven都已安装好了,教程见前边的视频。(maven https://www.imooc.com/learn/443 )
2.配置spring-mybatis文件,进行扫描,自动注入,配置数据库。
配置jdbc.properties文件
jdbc.username=voteadmin
jdbc.password=qjyj3423
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://180.76.56.157:3306/wechat?useUnicode=true&autoReconnect=true&characterEncoding=UTF-8
initialSize=0
maxActive=20
maxIdle=20
minIdle=1
maxWait=50000
- 新建一个spring-mybatis.xml,扫描配置
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:mvc=“http://www.springframework.org/schema/mvc” xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.1.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd"> class=“org.springframework.beans.factory.config.PropertyPlaceholderConfigurer”> destroy-method=“close”>



