日期:2014-05-16 浏览次数:20843 次
步骤如下: 2,建立SqlMapConfig.xml文件 文件名:SqlMapConfig.xml <!DOCTYPE sqlMapConfig?????? <sqlMapConfig> ? <!-- Configure a built-in transaction manager.? If youre using an? ? <!-- List the SQL Map XML files. They can be loaded from the? </sqlMapConfig> 3,建立SqlMapConfig.xml中引用的User.xml文件, 文件名:User.xml <!DOCTYPE sqlMap?????? <sqlMap namespace="User"> ? <!-- Use type aliases to avoid typing the full classname every time. --> ? <!-- Select with no parameters using the result map for Account class. --> </sqlMap> 4,建立user.xml文件中指定的class的文件 文件名;User.java import java.sql.Date; public class User { ??? private int id;
1,在eclipse中新建一个工程ibatisnew,然后把mysql和ibatis的jar包导入进去。这两个包(ibatis-2.3.4.726.jar+mysql-connector-java-5.0.8-bin.jar)可以从网上下载,直接拷贝到WEB-INF/lib目录下。
这个文件包含了数据库的配置,和各个数据表对应的xml的引用部分。
文件内容:
<?xml version="1.0" encoding="UTF-8" ?>
??? PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"??????
??? "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
?????? 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>
?????? classpath, as they are here (com.domain.data...) -->
? <sqlMap resource="test_ibatis/User.xml"/>
这个文件对应数据库中的user表,在这个文件中可以定义别名,可以写sql语句。
文件内容:
<?xml version="1.0" encoding="UTF-8" ?>
??? PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"??????
??? "http://ibatis.apache.org/dtd/sql-map-2.dtd">
? <typeAlias alias="User" type="test_ibatis.User"/>
? <select id="selectAllUsers" resultClass="User">
??? select * from user
? </select>
这个文件就是一个javabean,和数据库的表的字段相对应,有set和get方法。
文件内容:
package test_ibatis;
??? @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 String name;
??? private Date birthday;
??? private float mon