关于mybatis与mysql交互的一点小基础.
现在做开发都离不开与数据库打交道,在我们现在的j2ee开发中与数据库有交互的框架数hibernate用的最多了,但是也有不少的朋友用mybatis(以前叫ibatis).它们都是优秀的o/r mapping框架.
哪他们的区别主要在什么地方呢?只是两者的官方网站,上面都有介绍我就不多累述了.
hibernate参考资料： http://docs.jboss.org/hibernate/core/3.6/reference/zh-cn/html_single/
mybatis 参考资料官网：http://www.mybatis.org/core/zh/index.html
下面是个人做的mybatis的一些代码,供给基础薄弱,的朋友参考.如有什么不正确的地方请多多包涵,毕竟是我的处女文章.
声明:本人还是草根阶级,所以用的开发工具基本上都是免费的,个别工具是收费的,不过来到我们中国就不知不觉的免费了...
一下是本次开发所用的工具:
* mysql 5.6
* intellij idea 31.01
* mybatis 的jar包
* mysql的jar包
以上所需的两个jar包我上传到csdn上了的,不需要的积分,地址是:
http://download.csdn.net/download/nanguojisi/6820561
ok,我们开始吧!
1.先创建一个名为blog数据库
create database bbs;
再创建名为t_blog的表 如下:
create table t_blog (
id int not null auto_increment ,
content varchar(500) null ,
doc varchar(500) null ,
title varchar(50) null ,
primary key (id)
)
;
2.创建一个名为blog.java的javabean
package cn.it.beans;
/**
* created by mr_huang on 14-1-7.
*/
public class blog {
private int id;
private string title;
private string content;
private string doc;
public blog() {
}
public blog(string title, string content, string doc) {
this.title = title;
this.content = content;
this.doc = doc;
}
public int getid() {
return id;
}
public void setid(int id) {
this.id = id;
}
public string gettitle() {
return title;
}
public void settitle(string title) {
this.title = title;
}
public string getcontent() {
return content;
}
public void setcontent(string content) {
this.content = content;
}
public string getdoc() {
return doc;
}
public void setdoc(string doc) {
this.doc = doc;
}
}
3.先写一个连接数据库的 .properties文件,再写一个mybatis.xml的文件两个文件都在src的根目录(为了方便建议都放在src的根目录,也可以放于其他目录).
(1).jdbc_config.properties 文件内容如下:
db.driver = com.mysql.jdbc.driver
db.url = jdbc:mysql://127.0.0.1:3306/bbs?useunicode=true&characterencoding=utf8
db.username = 你的数据库用户名
db.password = 数据库密码
注意在每行的末尾不能有空格.
(2).mybatis.xml内容如下;
br /> public -//mybatis.org//dtd config 3.0//en
http://mybatis.org/dtd/mybatis-3-config.dtd>
4.创建一个blogmapper.xml的文件,放在blog.java同一个包里(也是问了一一对应起来方便):
blogmapper.xml
insert into t_blog (title, content, doc) values (#{title}, #{content},#{doc});
select * from t_blog where id = #{id}
delete from t_blog where id = #{id}
select * from t_blog
update t_blog set title = #{title}, content = #{content}, doc = #{doc} where id = #{id}
select * from t_blog where title like %#{title}%
5.这是最后一步,创建一个测试类(我个人习惯用idea了,很方便.如有对idea感兴趣者可与我联系交流):
testibatis.java
package cn.it.test.mybatis;
import cn.it.beans.blog;
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;
import java.io.ioexception;
import java.io.inputstream;
import java.util.list;
/**
* created by mr_huang on 14-1-7.
* 用于测试mybatis与数据库是否交互成功
*/
public class testibatis {
/**
* 测试插入一条语句是否成功
*/
@test
public void testinser(){
string resource = mybatis.xml;
try {
inputstream inputstream = resources.getresourceasstream(resource);
sqlsessionfactory sqlsessionfactory = new sqlsessionfactorybuilder().build(inputstream);
sqlsession session = sqlsessionfactory.opensession();
blog blog1 = new blog(半厘米阳光1,半厘米阳光半厘米阳光半厘米阳光半厘米阳光半厘米阳光,半厘米阳光);
blog blog2 = new blog(半厘米阳光3,半厘米阳光半厘米阳光半厘米阳光半厘米阳光,半厘米阳光);
blog blog3 = new blog(半厘米阳光4,半厘米阳光半厘米阳光半厘米阳光,半厘米阳光);
session.insert(cn.it.beans.blog.insertblog,blog1);//插入对象
session.insert(cn.it.beans.blog.insertblog,blog2);//插入对象
session.insert(cn.it.beans.blog.insertblog,blog3);//插入对象
session.commit();//提交事务
session.close();//关闭session
} catch (ioexception e) {
e.printstacktrace();
}
}
/**
* 测试查询语句
*/
@test
public void testselect(){
try {
inputstream inputstream = resources.getresourceasstream(mybatis.xml);//读取数据库连接文件
sqlsessionfactory sqlsessionfactory = new sqlsessionfactorybuilder().build(inputstream);
sqlsession session = sqlsessionfactory.opensession();
blog blog = session.selectone(cn.it.beans.blog.selectblog,1);
system.out.println(blog.getcontent());
session.close();
} catch (ioexception e) {
e.printstacktrace();
}
}
/**
* 测试删除语句
*/
@test
public void testdelete(){
try {
inputstream inputstream = resources.getresourceasstream(mybatis.xml);
sqlsessionfactory sqlsessionfactory = new sqlsessionfactorybuilder().build(inputstream);
sqlsession session = sqlsessionfactory.opensession();
session.delete(cn.it.beans.blog.deleteblog,2);
session.commit();
session.close();
} catch (ioexception e) {
e.printstacktrace();
}
}
/**
* 测试查询所有语句
*/
@test
public void testselectall(){
try {
inputstream inputstream = resources.getresourceasstream(mybatis.xml);
sqlsessionfactory sqlsessionfactory = new sqlsessionfactorybuilder().build(inputstream);
sqlsession session = sqlsessionfactory.opensession();
list blogs = session.selectlist(cn.it.beans.blog.selectall);
//循环遍历每一个的值
for (blog blog:blogs){
system.out.println(blog.gettitle());
}
session.close();
} catch (ioexception e) {
e.printstacktrace();
}
}
/**
* 测试更新数据
*/
@test
public void testupdate(){
try {
inputstream inputstream = resources.getresourceasstream(mybatis.xml);
sqlsessionfactory sqlsessionfactory = new sqlsessionfactorybuilder().build(inputstream);
sqlsession session = sqlsessionfactory.opensession();
blog blog = new blog(重庆,沙坪坝区西永镇,半厘米阳光);
blog.setid(1);
session.update(cn.it.beans.blog.updateblog,blog);
session.commit();
session.close();
} catch (ioexception e) {
e.printstacktrace();
}
}
/**
* 测试模糊查询
*/
@test
public void testselectdim(){
try {
inputstream inputstream = resources.getresourceasstream(mybatis.xml);
sqlsessionfactory sqlsessionfactory = new sqlsessionfactorybuilder().build(inputstream);
sqlsession session = sqlsessionfactory.opensession();
list blogs = session.selectlist(cn.it.beans.blog.selectdim,热);
for(blog blog:blogs){
system.out.println(blog.getcontent());
}
session.close();
} catch (ioexception e) {
e.printstacktrace();
}
}
}
大体内容就是以上这些了.有话好好说.望不满者勿喷为谢!!!