测试ibatis3连接数据
来源:互联网 发布:360无线网卡网络不稳定 编辑:程序博客网 时间:2024/05/22 20:32
User.java文件:
package com.bsonline.test.ibatisTest;
public class User {
private Integer id;
private String username;
private String password;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public 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;
}
}
User_SqlMap.xml文件:
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE mapper
PUBLIC "-//ibatis.apache.org//DTD mapper 3.0//EN"
"http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<mapper namespace="User">
<select id="getUser" parameterType="java.lang.Integer" resultType="user">
select * from system where id=#{id}
</select>
</mapper>
SqlMapConfig.xml文件:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
PUBLIC "-//ibatis.apache.org//DTD Config 3.0//EN"
"http://ibatis.apache.org/dtd/ibatis-3-config.dtd">
<configuration>
<properties resource="com/bsonline/test/ibatisTest/jdbc.properties" />
<settings>
<setting name="cacheEnabled" value="false" />
<setting name="lazyLoadingEnabled" value="true" />
<setting name="multipleResultSetsEnabled" value="false" />
<setting name="useColumnLabel" value="true" />
<setting name="defaultExecutorType" value="SIMPLE" />
</settings>
<typeAliases>
<typeAlias type="com.bsonline.test.ibatisTest.User" alias="user"/>
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="${driver}" />
<property name="url" value="${url}" />
<property name="username" value="${username}" />
<property name="password" value="${password}" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/bsonline/test/ibatisTest/User_SqlMap.xml"/>
</mappers>
</configuration>
jdbc.properties文件:
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost/bsonline
username=root
password=123456
IbatisTest.java文件:
package com.bsonline.test.ibatisTest;
imp
imp
imp
imp
imp
imp
public class IbatisTest {
/**
*@author: zhangjp
*@功能:testIBATIS
*@公用:false
*@date:Apr 30, 2010 6:56:30 PM
**/
public static void main(String[] args) {
// TODO Auto-generated method stub
try {
String resource ="com/bsonline/test/ibatisTest/SqlMapConfig.xml";
Reader reader = Resources.getResourceAsReader(resource);
SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = sessionFactory.openSession();
User user = (User)session.selectOne("getUser", 1);
System.out.println(user.getId()+" "+user.getUsername()+" "+user.getPassword());
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
- 测试ibatis3连接数据
- ibatis3
- 数据连接测试
- 数据的测试与连接
- iBatis3尝鲜
- JAVA 连接oracle数据测试程序!
- 连接oracle 数据测试的程序
- select连接TCPIP数据收发测试
- PDO数据连接持久化性能测试
- select连接TCPIP数据收发测试(连接多客户)
- ibatis3整合spring
- ibatis3 配置文件实例
- Ibatis3 mapper配置文件实例
- Ibatis3入门学习
- 集成iBATIS3和bonecp
- ibatis3整合spring
- iBatis3架构分析
- iBatis3架构分析
- js正则表达式学习1
- 7款常用的光学字符识别(OCR)软件对比
- js正则表达式学习2
- BS开发经验
- jdbc连接Mysql数据库
- 测试ibatis3连接数据
- dbcp参数配置
- java正则
- C++编码规范
- OpenRisc-47-or1200的WB模块分析
- 日积月累的js日期操作的方法,吐血奉献
- 努力---是永远且持久的行为
- MVN生成java项目
- 时刻不忘提升自己