日期:2014-05-16  浏览次数:20764 次

Ibatis+MySql实例 例子

步骤如下:
1,在eclipse中新建一个工程ibatisnew,然后把mysql和ibatis的jar包导入进去。这两个包(ibatis-2.3.4.726.jar+mysql-connector-java-5.0.8-bin.jar)可以从网上下载,直接拷贝到WEB-INF/lib目录下。

2,建立SqlMapConfig.xml文件
这个文件包含了数据库的配置,和各个数据表对应的xml的引用部分。

文件名: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>

? <!-- Configure a built-in transaction manager.? If youre using an?
?????? app server, you probably want to use its transaction manager?
?????? and a managed datasource -->
? <transactionManager type="JDBC" commitRequired="false">
??? <dataSource type="SIMPLE">
????? <property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/>
????? <property name="JDBC.ConnectionURL" value="jdbc:mysql://127.0.0.1:3306/db"/>
????? <property name="JDBC.Username" value="root"/>
????? <property name="JDBC.Password" value=""/>
??? </dataSource>
? </transactionManager>

? <!-- List the SQL Map XML files. They can be loaded from the?
?????? classpath, as they are here (com.domain.data...) -->
? <sqlMap resource="test_ibatis/User.xml"/>

</sqlMapConfig>

3,建立SqlMapConfig.xml中引用的User.xml文件,
这个文件对应数据库中的user表,在这个文件中可以定义别名,可以写sql语句。

文件名:User.xml
文件内容:
<?xml version="1.0" encoding="UTF-8" ?>

<!DOCTYPE sqlMap??????
??? PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"??????
??? "http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="User">

? <!-- Use type aliases to avoid typing the full classname every time. -->
? <typeAlias alias="User" type="test_ibatis.User"/>

? <!-- Select with no parameters using the result map for Account class. -->
? <select id="selectAllUsers" resultClass="User">
??? select * from user
? </select>

</sqlMap>

4,建立user.xml文件中指定的class的文件
这个文件就是一个javabean,和数据库的表的字段相对应,有set和get方法。

文件名;User.java
文件内容:
package test_ibatis;

import java.sql.Date;

public class User {
??? @Override
??? public String toString() {
??????? // TODO Auto-generated method stub
??????? String str = "id = " + this.id;
??????? str += " name = " + this.name;
??????? str += " birthday = " + this.birthday;
??????? str += " money = " + this.money;
??????? return str;
??? }

??? private int id;
??? private String name;
??? private Date birthday;
??? private float mon