使用mybatis连接mysql_使用MyBatis链接MySQL

48304ba5e6f9fe08f3fa1abda7d326ab.png

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

)

48304ba5e6f9fe08f3fa1abda7d326ab.png

2.2. 创建实体类

48304ba5e6f9fe08f3fa1abda7d326ab.png

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;

}

}

48304ba5e6f9fe08f3fa1abda7d326ab.png

3. 定义数据访问接口

48304ba5e6f9fe08f3fa1abda7d326ab.png

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 selectAll();

public int countAll();

public User findByUserName(String userName);

}

48304ba5e6f9fe08f3fa1abda7d326ab.png

4.创建MyBatis映射文件(UserDaoMapper.xml)

48304ba5e6f9fe08f3fa1abda7d326ab.png

select count(*) c from user;

select * from user order by userName asc

insert into user(userName,password,comment) values(#{userName},#{password},#{comment})

update user set userName=#{userName},password=#{password},comment=#{comment} where userName=#{userName}

delete from user where userName=#{userName}

select * from user where userName=#{userName}

48304ba5e6f9fe08f3fa1abda7d326ab.png

5. 创建mybatis配置文件

48304ba5e6f9fe08f3fa1abda7d326ab.png

/p>

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

48304ba5e6f9fe08f3fa1abda7d326ab.png

6. 编写测试代码

48304ba5e6f9fe08f3fa1abda7d326ab.png

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 users = userDao.selectAll();

Iterator 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();

}

}

48304ba5e6f9fe08f3fa1abda7d326ab.png

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值