导入开发包 asm-3.2.0.RELEASE.jar asm-3.3.1.jar c3p0-0.9.jar cglib-2.2.2.jar com.springsource.net.sf.cglib-2.2.0.jar com.springsource.org.aopalliance-1.0.0.jar com.springsource.org.apache.commons.logging-1.1.1.jar com.springsource.org.aspectj.weaver-1.6.8.RELEASE.jar jackson-core-asl-1.7.2.jar jackson-mapper-asl-1.7.2.jar javassist-3.17.1-GA.jar javax.servlet.jsp.jstl.jar jsf-api.jar jsf-impl.jar jstl-impl.jar junit.jar log4j-1.2.17.jar mybatis-3.2.2.jar mybatis-spring-1.2.0.jar mysql-connector-java-5.1.26-bin.jar org.hamcrest.core_1.1.0.v20090501071000.jar org.springframework.transaction-3.2.2.RELEASE.jar slf4j-api-1.7.5.jar slf4j-log4j12-1.7.5.jar spring-aop-3.2.0.RELEASE.jar spring-beans-3.2.0.RELEASE.jar spring-context-3.2.0.RELEASE.jar spring-core-3.2.0.RELEASE.jar spring-expression-3.2.0.RELEASE.jar spring-jdbc-3.2.0.RELEASE.jar spring-orm-3.2.0.RELEASE.jar spring-test-3.2.0.RELEASE.jar spring-web-3.2.0.RELEASE.jar spring-webmvc-3.2.0.RELEASE.jar 整合Spring与Mybatis 相关的配置文件 log4j.properties
Rules reminder: DEBUG < INFO < WARN < ERROR < FATAL
Global logging configuration log4j.rootLogger=debug,stdout
My logging configuration... log4j.logger.cn.jbit.mybatisdemo=DEBUG
Console output... log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=%5p %d %C: %m%n
log4j.logger.org.apache.ibatis=DEBUG log4j.logger.org.apache.jdbc.SimpleDataSource=DEBUG log4j.logger.org.apache.ibatis.jdbc.ScriptRunner=DEBUG log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapclientDelegate=DEBUG log4j.logger.java.sql.Connection=DEBUG log4j.logger.java.sql.Statement=DEBUG log4j.logger.java.sql.PreparedStatement=DEBUG
myBatis-config.xml文件
通过package, 可以直接指定package的名字， mybatis会自动http：//www扫描你指定包下面的javabean,并且默认设置一个别名，默认的名字为非限定类名来作为它的别名。
通过package, 可以直接指定package的名字， mybatis会自动扫描你指定包下面的javabean,
并且默认设置一个别名，默认的名字为非限定类名来作为它的别名。
-->
配置数据源，记得去掉myBatis-config.xml的数据
<tx:advice id="advice" transaction-manager="transactionManager"> tx:attributes <tx:method name="insert*" propagation="REQUIRED" rollback-for="Exception" /> <tx:method name="update*" propagation="REQUIRED" rollback-for="Exception" /> <tx:method name="delete*" propagation="REQUIRED" rollback-for="Exception" /> <tx:method name="*" propagation="SUPPORTS" /> </tx:attributes> </tx:advice>
aop:config <aop:advisor advice-ref="advice" pointcut="execution(* cn.itcast.scm.service.impl..(..))" /> </aop:config>
<context:component-scan base-package="cn.itcast"> <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller" /> </context:component-scan>
1 编写实体及sql映射游戏文件 SQL脚本如果相对electron有更多直观理解的, 也可以参考其格式如下:drop database if exists mybatis; create database mybatis CHARACTER SET UTF8; use mybatis;
create table dept(
dept_id int primary key auto_increment, dept_name varchar(50), dept_address varchar(50) );
实体：
package zhongfucheng.entity;
import java.io.Serializable;
public class Dept implements Serializable {
private Integer deptId; private String deptName; private String deptAddress; public Integer getDeptId() { return deptId; } public void setDeptId(Integer deptId) { this.deptId = deptId; } public String getDeptName() { return deptName; } public void setDeptNamhttp：//wwww.cungun.com e(String deptName) { this.deptName = deptName; } public String getDeptAddress() { return deptAddress; } public void setDeptAddress(String deptAddress) { this.deptAddress = deptAddress; } @Override public String toString() { return "Dept [deptId=" + deptId + ", deptName=" + deptName + ", deptAddress=" + deptAddress + "]"; } }
映射文件
select * from dept where dept_id=#{deptID} insert into dept(dept_name,dept_address) values(#{deptName},#{deptAddress});
