mybatis入门配置详解及实例下载

1、conf.xml文件配置

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" <a target=_blank href="http://mybatis.org/dtd/mybatis-3-mapper.dtd">http://mybatis.org/dtd/mybatis-3-mapper.dtd</a>>
<configuration><environments default="development"> <enviroment id="development"> <transactionManager type="JDBC" /><datasource type="POOLED"> <property name="driver" value="com.mysql.jdbc.Driver" /> <property name="url" value="jdbc:mysql//localhost:3306/monitor" /><property name="username" value="root" /><property name="password" value="123456" /></dataSource></enviroment></enviroments><mappers> <mapper resource="com/dcfs/zhangfyb/config/modelMapping.xml" /></mappers></configuration>

2、modelMapping文件配置详解

<pre class="html" name="code"><?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" <a target=_blank href="http://mybatis.org/dtd/mybatis-3-mapper.dtd">http://mybatis.org/dtd/mybatis-3-mapper.dtd</a>>
<mapper namespace="com.dcfs.zhangfyb.config.modelMapping">
	<update id="updateModel" parameterType="com.dcfs.zhangfyb.model">
  	update event_type set description=#{DESCRIPTION} where name= #{NAME}
	</update>

	<select id="getmodel" parameterType="string" resultType="com.dcfs.zhangfyb.model">
	select * from event_type where 1=1
	</select>
</mapper>

</pre><pre class="html" name="code">3、model类

public class Model{
	private String  name;
    	private String description;
    	private String des;

	public String getDes(){
   		return des;
	} 

	public void setDes (String des){
 		this.des = des;
	}

	public String getName(){
 		return name;
	}

	public void setName(String name){
		this.name = name;
	}

	public String getDescription(){
 		return description;
	}

	public void setDescription(String description){
  		this.description = description;
	}

}

 

4、测试类

<pre class="html" name="code">public class Test{

	public static void main(String[] args){
   
    		String resource="conf.xml";
    		InputStream is = Test.class.getClassLoader().getResourceAsStream(resource);
    		SqlSessionFactory sessionfactory = new  SqlSessionFactoryBuilder().build(is); 

		SqlSession session =sessionfactory.openSession();

		String state = "com.dcfs.zhangfyb.comfig.modelMapping.getModel"

		List<Model> lists = session.selectList(state);

		for(Model list:lists){

			System.out.println(list.getName() + "  " + lsit.getDescription());

		}
	}

}