mybatis实现表与对象的关联关系_动力节点Java学院整理

mybatis实现表与对象的关联关系_动力节点Java学院整理

所需要用到的其他工具或技术:

项目管理工具 : Maven

测试运行工具 : Junit

数据库 : Derby

Maven Dependencies:

org.mybatis

mybatis

3.2.7

junit

junit

4.9

test

org.apache.derby

derby

10.10.2.0

org.apache.derby

derbyclient

10.10.2.0

SQL 建表及数据插入（新建一个USER_TEST_TB_RELATIONSHIP表，然后CopyUSER_TEST_TB的数据，Derby不支持表结构中列名的修改，只能这么做了）:

CREATE TABLE USER_TEST_TB_RELATIONSHIP(

USER_ID INT PRIMARY KEY,

USER_USERNAME VARCHAR(20) NOT NULL,

USER_PASSWORD VARCHAR(20) NOT NULL,

USER_NICKNAME VARCHAR(20) NOT NULL

);

INSERT INTO USER_TEST_TB_RELATIONSHIP(USER_ID,USER_USERNAME,USER_PASSWORD,USER_NICKNAME) SELECT ID,USERNAME,PASSWORD,NICKNAME FROM USER_TEST_TB;

Mybatis配置文件 src/main/resource源目录下

test-mybatis-configuration.xml

PUBLIC "-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

User.java对象类(src/main/java/com/bjpowernode/practice目录下)

package com.bjpowernode.practice;

public class User

{

private Integer id;

private String username;

private String password;

private String nickname;

public Integer getId()

{

return id;

}

public void setId(Integer id)

{

this.id = id;

}

phttp://ublic String getUsername()

{

return username;

}

public void setUsername(String username)

{

this.username = username;

}

public String getPassword()

{

return password;

}

public void setPassword(String password)

{

this.password = password;

}

public String getNickname()

{

return nickname;

}

public void shttp://etNickname(String nickname)

{

this.nickname = nickname;

}

}

UserMapper.xml  Mapper文件（src/main/java/com.bjpowernode.practice目录下）

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

select *

from USER_TEST_TB_RELATIONSHIP

UserMapper.java Mapper类（src/main/java/com.bjpowernode.practice目录下）

package com.bjpowernode.practice;

import java.util.List;

public interface UserMapper

{

public List getUser();

}

测试类TestMyBatis.Java（src/test/java/com.bjpowernode.practice目录下）

package com.bjpowernode.practice;

import java.io.InputStream;

import java.text.MessageFormat;

import java.util.List;

import org.apache.ibatis.session.SqlSession;

import org.apache.ibatis.session.SqlSessionFactory;

import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import org.junit.Before;

import org.junit.Test;

public class TestMyBatis

{

private String source;

private InputStream inputStream;

private SqlSessionFactory sqlSessionFactory;

@Before

public void setUp()

{

/**

* 准备Mybatis运行环境

*/

source = "test-mybatis-configuration.xml";

inputStream = TestMyBatis.class.getClassLoader().getResourceAsStream(source);

sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

}

@Test

public void testGet()

{

try

{

// 获取Session连接

SqlSession session = sqlSessionFactory.openSession();

// 获取Mapper

UserMapper userMapper = session.getMapper(UserMapper.class);

// 显示User信息

System.out.println("Test Get start...");

this.printUsers(userMapper.getUser());

System.out.println("Test Get finished...");

}

catch (Exception e)

{

e.printStackTrace();

}

}

/**

*

* 打印用户信息到控制台

*

* @param users

*/

private void printUsers(final List users)

{

int count = 0;

for (User user : users)

{

System.out.println(MessageFormat.format("==User[{0}]=================", ++count));

System.out.println("User Id: " + user.getId());

System.out.println("User UserName: " + user.getUsername());

System.out.println("User Password: " + user.getPassword());

System.out.println("User nickname: " + user.getNickname());

}

}

}

总结

以上所述是给大家介绍的mybatis实现表与对象的关联关系_动力节点Java学院整理，希望对大家有所帮助，如果大家有任何疑问请给我留言，会及时回复大家的。在此也非常感谢大家对我们网站的支持！

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。