MyBatis学习笔记（二）

sqlMapConfig.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="com.mysql.jdbc.Driver" />
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/xxxx" />
                <property name="username" value="root" />
                <property name="password" value="root" />

            </dataSource>
        </environment>
    </environments>
    <!-- 加载mapper映射文件  -->
    <!-- mapping 文件路径配置 -->  
    <mappers>  
        <mapper resource="sqlmap/user.xml" />  
    </mappers>  

</configuration>

mapper文件：user.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 1.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- 命名空间，对sql进行分类化管理，隔离sql -->
<mapper namespace="test">

<!--需求：： 通过id查询user -->
<!--  在映射文件中配置sql-->
<!-- id 用于标识映射文件的表示，成为statement的id -->
<!-- parameterType:制定输入参数的类型、
    #{}：占位符
    resultType:指定输出结果的所映射的java对象，对应的pojo全路径
    #{uid}:其中的uid表示啊呼入的参数，参数名称就是uid，，如果是普通java类型，可以任意名称
 -->
<select id="findUserById" parameterType="int" resultType="com.lear.pojo.User">
select * from user where uid=#{uid}
</select>

<!--${}:表示拼接sql串 
使用${}拼接，可能会引起sql注入
${}里面只能是value
 -->
<select id="findUserByName" parameterType="java.lang.String" resultType="com.lear.pojo.User">
select * from user where uname like '%${value}%'
</select>

<!-- 需求：添加用户
 parameterType:指定输入参数的时候使用的是pojo
#{}:中指定pojo属性名称
主键自自增 
 <selectKey keyProperty="uid" order="AFTER" resultType="java.lang.Integer">
 SELECT LAST_INSERT_ID()
 </selectKey>

主键非自增 
 <selectKey keyProperty="uid" order="BEFORE" resultType="java.lang.Integer">
 SELECT uuid()
 </selectKey> -->


<insert id="insertUser" parameterType="com.lear.pojo.User" >
insert into user (uid,upassword,uname,usex,utel,uemail,ucredit) value(#{uid},#{upassword},#{uname},#{usex},#{utel},#{uemail},#{ucredit})
</insert>

<delete id="deleteUser" parameterType="java.lang.Integer">
delete from user where uid=#{uid}
</delete>

<!-- #{uid} 从user中取出来的user id -->
<update id="updateUser" parameterType="com.lear.pojo.User">
update user set uname=#{uname} where uid=#{uid}
</update>
</mapper>

User.java

public class User {
    private int uid;
    private String upassword;
    private String  uname;
    private String usex;
    private String utel;
    private String uemail;

    public String getUcredit() {
        return ucredit;
    }
    public void setUcredit(String ucredit) {
        this.ucredit = ucredit;
    }
    private String ucredit;
    public int getUid() {
        return uid;
    }
    public void setUid(int uid) {
        this.uid = uid;
    }
    public String getUpassword() {
        return upassword;
    }
    public void setUpassword(String upassword) {
        this.upassword = upassword;
    }
    public String getUname() {
        return uname;
    }
    public void setUname(String uname) {
        this.uname = uname;
    }
    public String getUsex() {
        return usex;
    }
    public void setUsex(String usex) {
        this.usex = usex;
    }
    public String getUtel() {
        return utel;
    }
    public void setUtel(String utel) {
        this.utel = utel;
    }
    public String getUemail() {
        return uemail;
    }
    public void setUemail(String uemail) {
        this.uemail = uemail;
    }
    @Override
    public String toString() {
        return "User [uid=" + uid + ", upassword=" + upassword + ", uname=" + uname + ", usex=" + usex + ", utel="
                + utel + ", uemail=" + uemail + ", ucredit=" + ucredit + "]";
    }

}

test:

@Test
    public void findUserById() throws IOException{
        SqlSession sqlSession =null;
        try {
            //mybatis配置文件
            String resource= "sqlMapConfig.xml";
            //得到配置文件流
            InputStream inputStream = Resources.getResourceAsStream(resource);
            //创建会化工厂
            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
            //通过工厂得到sqlsession
            sqlSession = sqlSessionFactory.openSession();
            //通过sqlsession操作数据库
            //第一个参数：映射文件中的statement的id = namespace.+statement的id
            //第二个参数：指定和映射文件中所匹配的parameterType的类型的参数
            User user = sqlSession.selectOne("test.findUserById", 123);
            System.out.println(user);
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

注：如有错误，欢迎指正，谢谢！