本文主要介紹了如何使用mybatis進行簡單的數據庫操作。本人使用的是mybatis3.05。
mybatis配置文件詳解。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; }}
mybatis怎么關數據庫連接。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 ListselectAll(); public int countAll(); public User findByUserName(String userName);}
4.創建MyBatis映射文件(UserDaoMapper.xml)
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}
5. 創建mybatis配置文件
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()); Listusers = userDao.selectAll(); Iteratoriter = 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 聯系我,非常感謝。
相關標簽:
本文原創發布php中文網,轉載請注明出處,感謝您的尊重!
版权声明:本站所有资料均为网友推荐收集整理而来,仅供学习和研究交流使用。
工作时间:8:00-18:00
客服电话
电子邮件
admin@qq.com
扫码二维码
获取最新动态