Mybatis根据id查询用户信息

来源：互联网发布：农行软件开发待遇编辑：程序博客网时间：2024/05/17 04:02

User.java 存储用户的信息
User.xml   配置查询用户的sql语句
SqlMapConfig.xml    加载配置文件，
MybatisFirst.java   数据库操作文件

MybatisFirst.java

public class MybatisFirst {    //根据id查询用户信息，得到一条记录结果    @Test    public void findUserByIdTest() throws IOException{        //MyBatis配置文件        String resource = "SqlMapConfig.xml";        //得到配置文件流        InputStream inputStream = Resources.getResourceAsStream(resource);                //创建会话工厂,想build中传入配置文件信息        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);        //通过工厂得到SqlSession        SqlSession sqlSession = sqlSessionFactory.openSession();        //通过SqlSession操作数据库        User user = sqlSession.selectOne("test.findUserById", 16);                System.out.println(user);                try{            sqlSession.close();        } catch(Exception e) {            throw new RuntimeException(e);        }    }}

User.java

public class User {    private int id;    private String username;//  用户姓名    private String sex;// 性别    private Date birthday;// 生日    private String address;// 地址    @Override    public String toString() {        return "User [id=" + id + ", username=" + username + ", sex=" + sex                + ", birthday=" + birthday + ", address=" + address + "]";    }    public int getId() {        return id;    }    public void setId(int id) {        this.id = id;    }    public String getUsername() {        return username;    }    public void setUsername(String username) {        this.username = username;    }    public String getSex() {        return sex;    }    public void setSex(String sex) {        this.sex = sex;    }    public Date getBirthday() {        return birthday;    }    public void setBirthday(Date birthday) {        this.birthday = birthday;    }    public String getAddress() {        return address;    }    public void setAddress(String address) {        this.address = address;    }    }

User.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapperPUBLIC "-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="test">    <select id="findUserById" parameterType="int" resultType="dancheng.mybatis.po.User">        SELECT * FROM USER WHERE id=#{value}    </select></mapper>

SqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configurationPUBLIC "-//mybatis.org//DTD Config 3.0//EN""http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration>    <!-- 和spring整合后 environments配置将废除-->    <environments default="development">        <environment id="development">        <!-- 使用jdbc事务管理-->            <transactionManager type="JDBC" />        <!-- 数据库连接池-->            <dataSource type="POOLED">                <property name="driver" value="com.mysql.jdbc.Driver" />                <property name="url" value="jdbc:mysql://localhost:3306/mybatis?characterEncoding=utf-8" />                <property name="username" value="root" />                <property name="password" value="123" />            </dataSource>        </environment>    </environments>    <!-- 加载映射文件 -->    <mappers>        <mapper resource="sqlmap/User.xml"/>    </mappers>    </configuration>

0 0