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 configuration
	PUBLIC "-//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 mapper
	PUBLIC "-//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/

评论

3 楼 柏新星 2011-07-30  

柏新星 写道

create table Person (id int primary);  
insert into Persion values (1);  

2 楼 柏新星 2011-07-30  

create table Person (id int primary);  
insert into Persion values (1);  

1 楼 nurenok 2010-11-05  

把工程传上来，大家参考下啊。谢谢了