derby+myBatis 入门
1， 下载derby, myBatis。2， 设定DERBY_HOME环境变量和PATH环境变量。
3， 用ij命令执行下面的代码。
connect 'jdbc:derby:tianyuDB;create=true';create table Person (id int primary);insert into Persion values (1);disconnect;4，写JavaBean
package examples.main;public class Person { private String name; public void setName(String name) { this.name = name; } public String getName() { return name; }}5，读取配置文件，取得SqlSessionFactory
package examples.main;import java.io.Reader;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;public class MyAppSqlConfig { private static final SqlSessionFactory sqlMap; static { try { String resource = "examples/sqlmap/maps/sqlMapConfig.xml"; Reader reader = Resources.getResourceAsReader(resource); sqlMap = new SqlSessionFactoryBuilder().build(reader); } catch (Exception e) { e.printStackTrace(); } } public static SqlSessionFactory getSqlMapInstance() { return sqlMap; }}6， SqlSession生成，执行SQL
package examples.main;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;public class TestMyAppSqlConfig { public static void main(String[] args) { SqlSessionFactory sqlMapper = MyAppSqlConfig.getSqlMapInstance(); SqlSession session = sqlMapper.openSession(); try { System.out.println(session.selectOne("selectId")); } finally { session.close(); } }}7， 编写 configuration XML
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration><environments default="development"><environment id="development"><transactionManager type="JDBC" /><dataSource type="POOLED"><property name="driver" value="org.apache.derby.jdbc.EmbeddedDriver" /><property name="url" value="jdbc:derby:tianyuDB;create=true" /></dataSource></environment></environments><mappers><mapper resource="examples/sqlmap/maps/Person.xml" /></mappers></configuration>8， 编写 mapper XML
<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="examples.main.Cat"><select id="selectId" resultType="Integer">select * from Person</select></mapper>9， 至此全部结束。可以运行试验一下啦。
10， 可以 google code 的这个地址。
http://javamp3player.googlecode.com/svn/study_derby/
页:
[1]