- 论坛徽章:
- 0
|
Hibernate确实不错,实现了数据的持久,但是自从接触ibatis后就觉得如果只用hibernate的话那么是不完整的,有了ibatis后就如人不在单身一样哦
- package com.yzq;
- import java.io.Reader;
- import com.ibatis.common.resources.Resources;
- import com.ibatis.sqlmap.client.SqlMapClient;
- import com.ibatis.sqlmap.client.SqlMapClientBuilder;
- //此类用语生成sqlmap来映射sql语句,从xml文件中读
- public class FriendsBuilder
- {
- public SqlMapClient getSqlMapInstance()
- {
- SqlMapClient sqlMap = null;
- try
- {
- String resource = "sqlmapconfig.xml";
- Reader reader = Resources.getResourceAsReader(resource);
- sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader);
- }
- catch(Exception err)
- {
- err.printStackTrace();
- }
- return sqlMap;
- }
- }
复制代码- package com.yzq;
- public class Friends
- {
- private int id;
- private String name;
- private String sex;
- private int age;
- private String mobile;
- private String address;
- private String memo;
-
- public void setId(int id)
- {
- this.id = id;
- }
-
- public int getId()
- {
- return id;
- }
-
- public void setName(String name)
- {
- this.name = name.trim();
- }
-
- public String getName()
- {
- return name;
- }
-
- public void setSex(String sex)
- {
- this.sex = sex.trim();
- }
-
- public String getSex()
- {
- return sex;
- }
-
- public void setAge(int age)
- {
- this.age = age;
- }
-
- public int getAge()
- {
- return age;
- }
-
- public void setMobile(String mobile)
- {
- this.mobile = mobile.trim();
- }
-
- public String getMobile()
- {
- return mobile;
- }
-
- public void setAddress(String address)
- {
- this.address = address;
- }
-
- public String getAddress()
- {
- return address;
- }
-
- public void setMemo(String memo)
- {
- this.memo = memo.trim();
- }
-
- public String getMemo()
- {
- return memo;
- }
- }
复制代码- package com.yzq;
- import com.ibatis.sqlmap.client.SqlMapClient;
- public class FriendsOper
- {
- private void addFriend()
- {
- FriendsBuilder fb = new FriendsBuilder();
-
- Friends friend = new Friends();
- friend.setName("蒙嫄");
- friend.setSex("女");
- friend.setAge(25);
- friend.setMobile("13811181660");
- friend.setAddress("北京");
- friend.setMemo("高中同学,如今在北京闯荡,估计要结婚了");
- SqlMapClient sqlMap = fb.getSqlMapInstance();
- try
- {
- //插入记录语句
- sqlMap.insert("insertFriends",friend);
- System.out.println("插入成功");
- //查询语句
-
- }
- catch(Exception err)
- {
- err.printStackTrace();
- System.out.println("插入失败");
- }
- }
-
- public static void main(String args[])
- {
- new FriendsOper().addFriend();
- }
- }
复制代码-
- SELECT * FROM friends WHERE id=#id#
-
-
- INSERT INTO
- friends(name,sex,age,mobile,address,memo)
- VALUES(#name#,#sex#,#age#,#mobile#,#address#,#memo#)
-
复制代码- driver=org.gjt.mm.mysql.Driver
- url=jdbc:mysql://IP地址/数据库名
- username=用户名
- password=密码
复制代码 ibatis属于半自动化的方式,hibernate就如全自动化的方式,我感觉两者的关系就像cmp EJB,bean EJB一般.
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u/460/showart_66300.html |
|