mybatis类和xml

MyBatisUtils.java


package dao;


import java.io.Reader;


import org.apache.ibatis.io.Resources;


import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;


public class MyBatisUtils {


private static SqlSessionFactory fac=null;
private static Reader reader=null;

static{
try{
reader=Resources.getResourceAsReader("mybatis.xml");
fac=new SqlSessionFactoryBuilder().build(reader);
}catch(Exception e){

}

}
public static SqlSessionFactory getFac(){
return fac;
}

public static void main(String[] args) {
System.out.println(getFac());
}

}



PersonMapper.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="po">
<resultMap type="po.Person" id="personMap">
<id property="id" column="id"/>
<result property="name" column="name"/>
<result property="sex" column="sex"/>
</resultMap>
 
    <insert id="addPerson" parameterType="po.Person"
        useGeneratedKeys="true" keyProperty="id">
insert into person(name,sex) values (#{name},#{sex})
</insert>


<update id="updatePerson" parameterType="po.Person">
update person set name=#{name},sex=#{sex} where id=#{id}
</update>
<delete id="deletePerson" parameterType="java.lang.Integer">
delete from person where id=#{id}
</delete>


<select id="selectPerson" parameterType="java.lang.Integer" resultMap="personMap">
select * from person where id=#{id}
</select>
<select id="selectPersons" resultMap="personMap">
select * from person
</select>
</mapper>





mybatis.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>
<typeAliases>
<typeAlias type="po.Person" alias="Person"/>
</typeAliases>
  <environments default="development"> 
        <environment id="development"> 
        <transactionManager type="JDBC"/> 
            <dataSource type="POOLED"> 
            <property name="driver" value="com.mysql.jdbc.Driver"/> 
            <property name="url" value="jdbc:mysql://127.0.0.1:3306/jq" /> 
            <property name="username" value="root"/> 
            <property name="password" value="3306"/> 
            </dataSource> 
        </environment> 
   </environments>
<mappers>
<mapper resource="po/PersonMapper.xml"/>
</mappers>


</configuration>





评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值