使用MyBatis链接MySQL

    奶奶的,中国人写的文档真是烂,折腾了半天都没弄会guzz,还是退回去用MyBatis好了。

    http://www.cnblogs.com/wushiqi54719880/archive/2011/07/26/2117601.html

    这篇文章入门很好,我在这里转一下。

本文主要介绍了如何使用mybatis进行简单的数据库操作。本人使用的是mybatis3.05。

1.创建数据库表(User表)
复制代码
CREATE TABLE `NewTable` (
`userId`
bigint(20) NOT NULL AUTO_INCREMENT ,
`userName`
varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`password`
varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`comment`
varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
PRIMARY KEY (`userId`),
UNIQUE INDEX `UQ_User_userName` (`userName`) USING BTREE
)
复制代码

2.2. 创建实体类

复制代码
package com.mybatis.config;

public class User {
private int userId;
private String userName;
private String password;
private String comment;
public int getUserId() {
return userId;
}
public void setUserId(int userId) {
this.userId = userId;
}
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;
}
public String getComment() {
return comment;
}
public void setComment(String comment) {
this.comment = comment;
}
}
复制代码

3. 定义数据访问接口

复制代码
package com.mybatis.config;

import java.util.List;

public interface UserDao {

public int insert(User user);

public int update(User user);

public int delete(String userName);

public List<User> selectAll();

public int countAll();

public User findByUserName(String userName);
}
复制代码

4.创建MyBatis映射文件(UserDaoMapper.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="com.mybatis.config.UserDao">
<select id="countAll" resultType="int">
select count(*) c from user;
</select>

<select id="selectAll" resultType="com.mybatis.config.User">
select * from user order by userName asc
</select>

<insert id="insert" parameterType="com.mybatis.config.User">
insert into user(userName,password,comment) values(#{userName},#{password},#{comment})
</insert>

<update id="update" parameterType="com.mybatis.config.User">
update user set userName=#{userName},password=#{password},comment=#{comment} where userName=#{userName}
</update>

<delete id="delete" parameterType="int">
delete from user where userName=#{userName}
</delete>

<select id="findByUserName" parameterType="String" resultType="com.mybatis.config.User">
select * from user where userName=#{userName}
</select>
</mapper>
复制代码

5. 创建mybatis配置文件

复制代码
<?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://localhost:3306/hlp?useUnicode=true&amp;characterEncoding=UTF-8&amp;zeroDateTimeBehavior=convertToNull" />
<property name="username" value="root" />
<property name="password" value="1234" />
</dataSource>
</environment>
</environments>
<mappers>
<mapper resource="com/mybatis/config/UserDaoMapper.xml"/>
</mappers>
</configuration>
复制代码

6. 编写测试代码

复制代码
package com.mybatis.config;

import java.io.Reader;
import java.util.Iterator;
import java.util.List;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Test;

public class UserDaoTest {
@Test
public void userDaoTest() throws Exception
{
String resource
= "MyBatis-Configuration.xml";
Reader reader
= Resources.getResourceAsReader(resource);
SqlSessionFactoryBuilder builder
= new SqlSessionFactoryBuilder();
SqlSessionFactory factory
= builder.build(reader);

SqlSession session
= factory.openSession();
UserDao userDao
= session.getMapper(UserDao.class);

User user
= new User();
user.setUserName(
"hongye");
user.setPassword(
"123456");
user.setComment(
"备注");

userDao.insert(user);
System.out.println(
"记录条数:"+userDao.countAll());

List
<User> users = userDao.selectAll();
Iterator
<User> iter = users.iterator();
while(iter.hasNext()){
User u
= iter.next();
System.out.println(
"用户名:"+u.getUserName()+"密码:"+u.getPassword());
}

user.setComment(
"comment");
userDao.update(user);
User u
= userDao.findByUserName("hongye");
System.out.println(u.getComment());

userDao.delete(
"hongye");
System.out.println(
"记录条数:"+userDao.countAll());

session.commit();
session.close();
}
}
复制代码


作者:红枫落叶 
出处:http://www.cnblogs.com/wushiqi54719880/ 
关于作者:专注于Java企业运用、海量数据处理、hadoop、数字图像处理等。
本文版权归作者所有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,如有问题,可以通过wushiqi54719880@126.com  联系我,非常感谢。



评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值