1.先在工程目录下导入对应的jar包.log4j用来输出日志文件,不用可以不导入,其他两个必须导入
拥有的所有文件如图
2.在数据库中添加上对应的表,并在java中创建其实体类
package region.basic; public class Region { private int id; private String name; public Region() { // TODO Auto-generated constructor stub } public Region(int id, String name) { super(); this.id = id; this.name = name; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } @Override public String toString() { return "Region [id=" + id + ", name=" + name + "]"; } }3.再写一个接口用来制定查询和新增的标准
package region.basic; import java.util.List; public interface IRegionDao { //查询所有数据 List<Region> selectAll(); //新增一条数据 int saveRegion(Region region); }4.创建一个mybatis-config.xml文件来配置一些信息,username,和password对应自己的,<mappers>中的东西下面会说
<?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="oracle.jdbc.OracleDriver"/> <property name="url" value="jdbc:oracle:thin:@localhost:1521:XE"/> <property name="username" value="cyg"/> <property name="password" value="cyg"/> </dataSource> </environment> </environments> <mappers> <mapper resource="region/basic/IRegionDaoMapper.xml"/> </mappers> </configuration>5.创建一个IRegionDaoMapper.xml用来配置要执行的SQL语句,查询和新增
<?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="region.basic.IRegionDao"> <select id="selectAll" resultType="region.basic.Region"> select id,name from s_region </select> <insert id="saveRegion"> insert into s_region(id,name) values (#{id},#{name}) </insert> </mapper>6.创建一个Test类来调用方法实现查询和新增
package region.basic; import java.util.List; import org.apache.ibatis.io.Resources; import org.apache.ibatis.session.SqlSession; import org.apache.ibatis.session.SqlSessionFactory; import org.apache.ibatis.session.SqlSessionFactoryBuilder; public class Test { public static void main(String[] args) throws Exception { SqlSessionFactory sf = new SqlSessionFactoryBuilder().build( Resources.getResourceAsReader("mybatis-config.xml")); SqlSession session = sf.openSession(); //通过SQLSession对象获取,mybatis自动生成的持久层实现对象 IRegionDao dao = session.getMapper(IRegionDao.class); //执行添加数据 Region region = new Region(14, "region9"); int i = dao.saveRegion(region); System.out.println(i); //执行查询操作 List<Region> list = dao.selectAll(); list.forEach(System.out::println); //事物处理 session.commit(); //关闭资源 session.close(); } }7.有兴趣的可以导入log4j的jar包,并创建一个log4j.properties并配置信息,来输出一下日志信息
#全局日志配置 log4j.rootLogger=DEBUG, stdout #]mybatis日志配置 log4j.logger.org.mybatis.example.BlogMapper=TRACE # 控制台输出 log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.layout=org.apache.log4j.PatternLayout log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n效果如图
