java Mybatis split("\\|");http://kb.cnblogs.com/page/100216/

http://blog.csdn.net/rootsuper/article/details/8542236

 String resource = "MyXml.xml";

        Reader reader = Resources.getResourceAsReader(resource);

        SqlSessionFactory ssf = new SqlSessionFactoryBuilder().build(reader);

        

        SqlSession session = ssf.openSession();

        

        try {

            User user = (User) session.selectOne("selectUser", "1");

            System.out.println(user);

        } catch (Exception e) {

            e.printStackTrace();

        } finally {

            session.close();

        }

    }

 

3. User.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="User">

    <select id="selectUser" parameterType="int" resultType="User"><![CDATA[

        select * from user where id = #{id}

    ]]></select>

</mapper>

 

 

<?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/School?useUnicode=true&amp;characterEncoding=UTF-8" />

                <property name="username" value="root" />

                <property name="password" value="hello.1234" />

            </dataSource>

        </environment>

    </environments>



    <mappers>

        <mapper resource="User.xml" />

    </mappers>

</configuration>

 

 

2. 类User:

 

 

 

package domain;

 

 

 

public class User {

 

    private int id;

 

    private String name;

 

 

 

    public User() {}

 

 

 

    public User(String name) { this(0, name); }

 

 

 

    public User(int id, String name) {

 

        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 "ID: " + id + ", Name: " + name; }

 

}

 

转载于:https://www.cnblogs.com/standy225/archive/2013/01/24/2875832.html