<?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>
<!-- Configure a built-in transaction manager. If you're using an app server,
you probably want to use its transaction manager and a managed datasource -->
<transactionManager type="JDBC" commitRequired="false">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="oracle.jdbc.driver.OracleDriver" />
<property name="JDBC.ConnectionURL" value="jdbc:oracle:thin:@localhost:1521:ESB" />
<property name="JDBC.Username" value="system" />
<property name="JDBC.Password" value="ngbss" />
</dataSource>
</transactionManager>
<!-- List the SQL Map XML files. They can be loaded from the classpath,
as they are here (com.domain.data...) -->
<sqlMap resource="User.xml" />
<!-- List more here... <sqlMap resource="com/mydomain/data/Order.xml"/>
<sqlMap resource="com/mydomain/data/Documents.xml"/> -->
</sqlMapConfig>
<?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="UserVo" type="com.huawei.vo.User" />
<resultMap class="UserVo" id="UserResult">
<result property="s_id" column="S_ID" />
<result property="c_id" column="C_ID" />
<result property="s_name" column="S_NAME" />
</resultMap>
<!-- select all User-->
<select id="selectAllUser" resultMap="UserResult">
select * from T_Stu
</select>
<!-- select one user by Id -->
<select id="selectUserById" parameterClass="String" resultClass="UserVo">
select * from T_Stu where s_id=#s_id#
</select>
<!-- insert a new user -->
<insert id="insertNewUser" parameterClass="UserVo">
insert into T_Stu (s_id,c_id,s_name) values(#s_id#,#c_id#,#s_name#)
</insert>
<!-- update one user by id-->
<update id="updateUserInfo" parameterClass="UserVo">
update T_Stu set s_id=#s_id#,c_id=#c_id#,s_name=#s_name# where s_id=#s_id#
</update>
<delete id="deleteUserByid" parameterClass="String">
delete from T_Stu where s_id=#s_id#
</delete>
</sqlMap>
package com.huawei.vo;
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 UserEaample
{
private static SqlMapClient sqlMapper;
public static void initSqlMap() throws IOException
{
Reader reader=Resources.getResourceAsReader("SqlMapConfig.xml");
sqlMapper=SqlMapClientBuilder.buildSqlMapClient(reader);
reader.close();
}
public static List getAllUser() throws SQLException
{
return sqlMapper.queryForList("selectAllUser");
}
public static User getOneUserById(String s_id) throws SQLException
{
return (User)sqlMapper.queryForObject("selectUserById",s_id);
}
public static void addNewUser(User user) throws SQLException
{
sqlMapper.insert("insertNewUser", user);
}
public static void updateUserInfo(User user) throws SQLException
{
sqlMapper.update("updateUserInfo", user);
}
public static void deleteUserById(String s_id) throws SQLException
{
sqlMapper.delete("deleteUserByid", s_id);
}
}
//////ibatis-2.3.0.677.jar
分享到:
相关推荐
struts2 + spring + ibatis 实例 struts2 + spring + ibatis 实例 struts2 + spring + ibatis 实例 struts2 + spring + ibatis 实例 struts2 + spring + ibatis 实例
ibatis 实例 配置 源码 依赖包 ibatis-2.3.4.726.jar commons-logging-api.jar commons-logging-1.1.jar commons-dbcp-1.2.2.jar commons-pool.jar
其中包含iBatis精讲PDF iBatis实例 iBatis开发指南 iBatis分页 spring+iBatis处理1对多数据表实例等等若干帮助文档。希望可以帮助大家学习iBatis...
ibatis实例 ibatis实例 ibatis实例
ibatis 配置教程 本人通过此文档学会写ibatis实例 ibatis 配置教程 本人通过此文档学会写ibatis实例 ibatis 配置教程 本人通过此文档学会写ibatis实例 ibatis 配置教程 本人通过此文档学会写ibatis实例
spring mybatis ibatis 实例
ibatis实例,ibatis实例,mysql应用举例,大家快来看。
Ibatis实例教程 入门使用 Ibatis实例教程 入门使用 如有不懂联系QQ:294647378 详细:http://itba.taobao.com
iBatis 实例 简单 轻松学会 简单的iBatis 实例
struts+spring+ibatis实例(完整项目) struts+spring+ibatis实例(完整项目)
spring mybatis ibatis 实例(源代码)
spring+ibatis实例 多种数据库连接
可运行的ibatis实例,基本配置已写好。 对于入门新手很实用。
ibatis实例,包含了sqlmap,provider,maps配置,同时将代码分为持久层,服务层,UI层
一个ibatis的实例,一个ibatis的实例,一个ibatis的实例
简单的struts2+spring+ibatis实例,实现了增删改查以及分页显示功能,包含jar包和数据库脚本。
iBATIS的实例,能够简单了解如何写,能够简单了解如何写,能够简单了解如何写,能够简单了解如何写.
IBATIS实例入门代码,数据库使用MYSQL
NULL 博文链接:https://qing393260529.iteye.com/blog/459723
NULL 博文链接:https://runtheall.iteye.com/blog/828726