花了一天时间看了传智播客的iBATIS2.3视频,地址点击打开链接,写下总结。
------------------------------------------------------------------------------------
1、先导包,导入一个ibatis-2.3.3.720.jar包,数据库使用的是MySQL,导入数据库的包mysql-connector-java-5.0.4-bin.jar准备工作完成;下载地址:点击打开链接
2、建立数据库,建表user,有四个字段,SQL语句如下:
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`userId` int(10) NOT NULL AUTO_INCREMENT,
`userName` varchar(100) DEFAULT NULL,
`userPassword` varchar(100) DEFAULT NULL,
`userFlag` varchar(100) DEFAULT NULL,
PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
3、配置数据库连接:
①SqlMap.properties文件:
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/itcast
username=root
password=123
②SqlMapConfig.xml文件:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<!-- 读取properties文件 -->
<properties resource="com/elifefly/SqlMap.properties" />
<!-- Configure a built-in transaction manager. If you're using an
app server, you probably want to use its transaction manager
and a managed datasource -->
<transactionManager type="JDBC" >
<dataSource type="SIMPLE">
<property value="${driver}" name="JDBC.Driver" />
<property value="${url}" name="JDBC.ConnectionURL" />
<property value="${username}" name="JDBC.Username" />
<property value="${password}" name="JDBC.Password" />
</dataSource>
</tran