SqlMapConfig.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<transactionManager type="JDBC">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/>
<property name="JDBC.ConnectionURL" value="jdbc:mysql://localhost/sample"/>
<property name="JDBC.Username" value="root"/>
<property name="JDBC.Password" value="root"/>
</dataSource>
</transactionManager>
<sqlMap resource="com/cs/User.xml"/>
</sqlMapConfig>
User.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="User">
<typeAlias alias="User" type="com.cs.User"/>
<resultMap id="UserResult" class="User">
<result property="id" column="id"/>
<result property="name" column="name"/>
<result property="sex" column="sex"/>
<result property="address" column="address"/>
</resultMap>
<!-- Select with no parameters using the result map for Account class. -->
<select id="selectAllUser" resultMap="UserResult">
select * from t_user
</select>
<select id="selectUserById" resultClass="User" parameterClass="int">
select * from t_user where id = #id#
</select>
<insert id="inserUser" parameterClass="User">
<selectKey resultClass="int" keyProperty="id">
select LAST_INSERT_ID() as value
</selectKey>
insert into t_user(id, name, sex, address)
values (#id#, #name#, #sex#, #address#)
</insert>
<update id="modifyUser" parameterClass="User">
update t_user set name=#name#, sex=#sex#, address=#address#
where id=#id#
</update>
<delete id="deleteUser" parameterClass="int">
delete from t_user where id = #id#
</delete>
<select id="selectUserByName" parameterClass="String" resultMap="UserResult">
select * from t_user where name = '$name$'
</select>
</sqlMap>
IUserDao.java
package com.cs;
import java.util.List;
public interface IUserDao {
public List selectAllUser();
public User selectUserById(int id);
public void addUser(User user);
public void delUser(int id);
public void modifyUser(User user);
public List selectUserByName(String name);
}
UserDaoImpl.java
package com.cs;
import java.io.IOException;
import java.io.Reader;
import java.sql.SQLException;
import java.util.List;
import com.ibatis.common.resources.Resources;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.ibatis.sqlmap.client.SqlMapClientBuilder;
public class UserDaoImpl implements IUserDao {
private static SqlMapClient sqlmapper = null;
static {
try {
Reader reader = Resources.getResourceAsReader("com/cs/SqlMapConfig.xml");
sqlmapper = SqlMapClientBuilder.buildSqlMapClient(reader);
} catch (IOException e) {
e.printStackTrace();
}
}
public void addUser(User user) {
try {
sqlmapper.insert("inserUser", user);
} catch (SQLException e) {
e.printStackTrace();
}
}
public void delUser(int id) {
try {
sqlmapper.delete("deleteUser", 12);
} catch (SQLException e) {
e.printStackTrace();
}
}
public void modifyUser(User user) {
try {
sqlmapper.update("modifyUser", user);
} catch (SQLException e) {
e.printStackTrace();
}
}
public List selectAllUser() {
List list = null;
try {
list = sqlmapper.queryForList("selectAllUser");
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
public User selectUserById(int id) {
User user = null;
try {
user = (User)sqlmapper.queryForObject("selectUserById",id);
} catch (SQLException e) {
e.printStackTrace();
}
return user;
}
public List selectUserByName(String name) {
List list = null;
try {
list = sqlmapper.queryForList("selectUserByName", name);
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}
/**
* @param args
*/
public static void main(String[] args) {
IUserDao userdao = new UserDaoImpl();
// 添加USER
// User user = new User();
// user.setId(100);
// user.setName("cs");
// user.setSex(1);
// user.setAddress(2);
// userdao.addUser(user);
//
// List list = userdao.selectAllUser();
// for(int i=0;i<list.size();i++) {
// System.out.println(list.get(i));
// }
// 修改USER
// User user = new User();
// user.setId(100);
// user.setName("cs");
// user.setSex(2);
// user.setAddress(1);
// userdao.modifyUser(user);
// 删除USER
// userdao.delUser(12);
// 模糊查询
// List list = userdao.selectUserByName("zk");
// 查询所有USER
List list = userdao.selectAllUser();
for(int i=0;i<list.size();i++) {
System.out.println(list.get(i));
}
// 根据ID查询
// User user = userdao.selectUserById(1);
// System.out.println(user);
}
}
分享到:
相关推荐
ibatis小结主要描述ibatis框架的一些基本使用。以及相关的配置,此demo可以运行
ibatis 组件 , 用于访问数据库 ibatis 基于O-R mapping 映射
IBATIS开发使用小结,手把手教会您IBATIS的使用
ibatis学习 ibatis总结 ibatis ibatis ibatis
ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料
iBATIS的实例,能够简单了解如何写,能够简单了解如何写,能够简单了解如何写,能够简单了解如何写.
ibatis demo,ibatis例子,ibatis示例
iBATIS 级联iBATIS 级联iBATIS 级联
ibatis小例子Demo,对于初学者是个很好的例子。
ibatis
ibatis的原码 ibatis源码 ibatis源码 ibatis源码
Ibatis3,手册,Ibatis3手册,Ibatis3使用手册,Ibatis3参考手册
ibatis api,ibatis文档,ibatis说明文档
ibatis代码自动生成,ibatis代码自动生成,ibatis代码自动生成,ibatis代码自动生成
ibatis教程,ibatis帮助文档,ibatis学习入门
ibatis2指南ibatis2指南ibatis2指南ibatis2指南ibatis2指南ibatis2指南ibatis2指南ibatis2指南ibatis2指南ibatis2指南ibatis2指南ibatis2指南ibatis2指南
简单的Ibatis入门例子,让你踏入Ibatis大门
iBatis学习,新手进,iBatis简单易上手。希望对广大学习者有所帮助。
iBatis文档\ibatis.doc
struts2+spring+ibatis的小demo