- 浏览: 1233878 次
- 性别:
- 来自: 杭州
文章分类
- 全部博客 (399)
- 心情故事 (12)
- java (115)
- linux (55)
- 关系型数据库 (35)
- struts,jsf,spring (11)
- jdbc,hibernate,ibatis (11)
- jsp,jstl,c:tag,标签库 (2)
- ejb,webservice (1)
- tomcat,jboss,jetty,weblogic,websphere (15)
- java网络编程 (6)
- java线程 (0)
- js,jquery,json,xml,dom,html.regex (25)
- 设计模式 (6)
- BUG记录 (2)
- ant (2)
- jsp,servlet (4)
- swing (6)
- lucene+nutch (6)
- log4j (2)
- windows doc (2)
- ruby (1)
- ruby on rails (3)
- 操作系统网络 (18)
- apache 错误 (1)
- tomcat (10)
- jboss (9)
- jetty (9)
- weblogic (9)
- websphere (10)
- apache (2)
- AIX的iostat命令查看系统磁盘的使用情况 (1)
- oracle 统计一个表格有多少列 (1)
- Exception in thread "main" java.security.KeyStoreException: Windows-MY not found (1)
- jsp (1)
- jstl (1)
- c:tag (1)
- 标签库 (1)
- struts (1)
- jsf (1)
- spring (2)
- oracle,sqlplus (2)
- sqlplus (2)
- show errors (1)
- proc (1)
- function (1)
- ORA-06544: PL/SQL: internal error (1)
- arguments: [55916] (1)
- [] (7)
- 终端身份实施文档 (1)
- 重装系统之后飞鸽传书只能看到自己 (1)
- vsftp "上传 553 Could not create file" (1)
- startWebLogic.sh启动失败,提示Error initializing Embedded LDAP Server (1)
- java agent 注册为 windows 服务 (1)
- centos (1)
- svn (1)
- apr (1)
- apr-util (1)
- activemq (2)
- oracle (5)
- mysql (3)
- nosql (3)
- NSIS (1)
- windows wmic (1)
- c 指针 (1)
- c c++ (0)
- jmeter (0)
- 性能测试 (0)
- linux,备份 (2)
- C++ ,Virtual (1)
- windows dos (1)
- android (2)
- 大数据,云计算 (1)
- JVM垃圾收集 (1)
- jdbc (2)
- invoke (1)
- hibernate (1)
- ibatis (1)
- 个人开源项目源码收藏 (1)
- 批处理 (1)
- Mongodb mapreduce (8)
- kettle (1)
- Mongodb capped (1)
- mongodb gridfs (1)
- Mongodb 入门基础知识 (1)
- mongodb (8)
- hadoop2.5.1 (1)
- hadoop (4)
- eclipse (1)
- hdfs fs (1)
- elipse hadoop plugin (1)
- PHP相关知识 (1)
- js (1)
- jquery (1)
- json (1)
- xml (1)
- dom (1)
- html.regex (1)
- 网络知识 (1)
- nginx (1)
- docker (1)
- 测试 (1)
- nodejs (1)
- iptables (1)
- linux gitlab (1)
最新评论
-
July01:
最近了解到一款StratoIO打印控件,功能如下:1、Html ...
web页面调用window.print()函数实现打印的功能 -
hxdtech:
非常感谢!
我在学习ibatis时的培训ppt -
zmwxiaoming:
what 能连数据库不错
SOLR的学习整理 -
springdata_springmvc:
java程序语言学习教程 地址http://www.zuida ...
java获取当前操作系统的信息 -
huanzei:
整理的不错,
oracle lpad函数
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd
">
<sqlMap namespace="adminuser">
<typeAlias
alias="adminuser"
type="com.hzmc.capaa.domain.persistence.trustuser.AdminUser" />
<parameterMap
id="addAdminUser"
class
="com.hzmc.capaa.domain.persistence.trustuser.AdminUser">
<parameter property
="username" jdbcType="varchar"
javaType="java.lang.String" />
<parameter property="password" jdbcType="varchar"
javaType="string" />
<parameter property="enabled" jdbcType="varchar"
javaType="java.lang.String" />
<parameter property="roles" jdbcType="varchar"
javaType="java.lang.String" />
<parameter property="expiryDate" jdbcType="Date"
javaType="java.util.Date" />
<parameter property="lockDate" jdbcType="Date"
javaType="java.util.Date" />
<parameter property="changePasswordDate" jdbcType="Date"
javaType="java.util.Date" />
<parameter property="accessLimited" jdbcType="NUMBER"
javaType="java.lang.Integer" />
<parameter property="failureLimited" jdbcType="NUMBER"
javaType="java.lang.Integer" />
<parameter property="realUser" jdbcType="varchar"
javaType="java.lang.String" />
<parameter property="contact" jdbcType="varchar"
javaType="java.lang.String" />
</parameterMap
>
<
parameterMap id="CheckupdateAdminUser"
class="com.hzmc.capaa.domain.persistence.trustuser.AdminUser">
<parameter property="username" jdbcType="varchar"
javaType="java.lang.String" />
<parameter property="rowId" jdbcType="varchar"
javaType="java.lang.String" />
</
parameterMap>
<
parameterMap id="AdminUser_chackIsSame"
class="com.hzmc.capaa.domain.persistence.trustuser.AdminUser">
<parameter property="username" jdbcType="varchar"
javaType="java.lang.String" />
<parameter property="password" jdbcType="varchar"
javaType="java.lang.String" />
</
parameterMap>
<parameterMap
id="AdminUser_updatePassword"
class="com.hzmc.capaa.domain.persistence.trustuser.AdminUser">
<parameter property="password" jdbcType="varchar"
javaType="string" />
<parameter property="changePasswordAccessNumber"
jdbcType="NUMBER" javaType="java.lang.Integer" />
<parameter property="username" jdbcType="varchar"
javaType="java.lang.String" />
</parameterMap>
<parameterMap
id="AdminUser_updateAccess"
class="com.hzmc.capaa.domain.persistence.trustuser.AdminUser">
<parameter property="changePasswordAccessNumber"
jdbcType="NUMBER" javaType="java.lang.Integer" />
<parameter property="username" jdbcType="varchar"
javaType="java.lang.String" />
</parameterMap>
<parameterMap id="AdminUser_updateLoginAccess"
class="com.hzmc.capaa.domain.persistence.trustuser.AdminUser">
<parameter property="username" jdbcType="varchar"
javaType="java.lang.String" />
</parameterMap
>
<parameterMap
id="updateAdminUser"
class="com.hzmc.capaa.domain.persistence.trustuser.AdminUser">
<parameter property="username" jdbcType="varchar"
javaType="java.lang.String" />
<parameter property="password" jdbcType="varchar"
javaType="string" />
<parameter property="enabled" jdbcType="varchar"
javaType="java.lang.String" />
<parameter property="roles" jdbcType="varchar"
javaType="java.lang.String" />
<parameter property="expiryDate" jdbcType="Date"
javaType="java.util.Date" />
<parameter property="lockDate" jdbcType="Date"
javaType="java.util.Date" />
<parameter property="changePasswordDate" jdbcType="Date"
javaType="java.util.Date" />
<parameter property="accessLimited" jdbcType="NUMBER"
javaType="java.lang.Integer" />
<parameter property="failureLimited" jdbcType="NUMBER"
javaType="java.lang.Integer" />
<parameter property="realUser" jdbcType="varchar"
javaType="java.lang.String" />
<parameter property="contact" jdbcType="varchar"
javaType="java.lang.String" />
<parameter property="rowId" jdbcType="varchar"
javaType="java.lang.String" />
</parameterMap
>
<parameterMap
id="updateAdminUser_notUpdatePassword"
class="com.hzmc.capaa.domain.persistence.trustuser.AdminUser">
<parameter property="username" jdbcType="varchar"
javaType="java.lang.String" />
<parameter property="enabled" jdbcType="varchar"
javaType="java.lang.String" />
<parameter property="roles" jdbcType="varchar"
javaType="java.lang.String" />
<parameter property="expiryDate" jdbcType="Date"
javaType="java.util.Date" />
<parameter property="lockDate" jdbcType="Date"
javaType="java.util.Date" />
<parameter property="changePasswordDate" jdbcType="Date"
javaType="java.util.Date" />
<parameter property="accessLimited" jdbcType="NUMBER"
javaType="java.lang.Integer" />
<parameter property="failureLimited" jdbcType="NUMBER"
javaType="java.lang.Integer" />
<parameter property="realUser" jdbcType="varchar"
javaType="java.lang.String" />
<parameter property="contact" jdbcType="varchar"
javaType="java.lang.String" />
<parameter property="rowId" jdbcType="varchar"
javaType="java.lang.String" />
</parameterMap
>
<parameterMap
id="AdminUser_showDetail"
class="com.hzmc.capaa.domain.persistence.trustuser.AdminUser">
<parameter property="rowId" jdbcType="varchar"
javaType="java.lang.String" />
</parameterMap
>
<parameterMap
id="AdminUser_searchParm"
class="com.hzmc.capaa.domain.persistence.trustuser.AdminUser">
<parameter property="searchParameter.username"
jdbcType="varchar" javaType="java.lang.String" />
<parameter property="realUser" jdbcType="varchar"
javaType="java.lang.String" />
<parameter property="status" jdbcType="varchar"
javaType="java.lang.String" />
<parameter property="roles" jdbcType="varchar"
javaType="java.lang.String" />
<parameter property="contact" jdbcType="varchar"
javaType="java.lang.String" />
</parameterMap
>
<resultMap id="select"
class="com.hzmc.capaa.domain.persistence.trustuser.AdminUser">
<result property="username" column="username" />
<result property="password" column="password" />
<result property="status" column="account_status" />
<result property="roles" column="granted_role" />
<result property="realUser" column="realuser" />
<result property="contact" column="contact" />
<result property="created" column="created" />
<result property="expiryDate" column="expiry_date" />
<result property="lockDate" column="lock_date" />
<result property="changePasswordDate" column="change_date" />
<result property="rowId" column="rowid" />
</resultMap>
<resultMap id="AdminUser_resultList"
class="com.hzmc.capaa.domain.persistence.trustuser.AdminUser">
<result property="username" column="username" />
<result property="password" column="password" />
<result property="status" column="account_status" />
<result property="active" column="account_active" />
<result property="enabled" column="enabled" />
<result property="roles" column="granted_role" />
<result property="created" column="created" />
<result property="expiryDate" column="expiry_date" />
<result property="lockDate" column="lock_date" />
<result property="changePasswordDate" column="change_date" />
<result property="realUser" column="realuser" />
<result property="contact" column="contact" />
<result property="rowId" column="rowid_" />
</resultMap>
<resultMap id="AdminUser_resultLists"
class="com.hzmc.capaa.domain.persistence.trustuser.AdminUser">
<result property="username" column="username" />
<result property="password" column="password" />
<result property="status" column="account_status" />
<result property="active" column="account_active" />
<result property="enabled" column="enabled" />
<result property="roles" column="granted_role" />
<result property="created" column="created" />
<result property="expiryDate" column="expiry_date" />
<result property="lockDate" column="lock_date" />
<result property="changePasswordDate" column="change_date" />
<result property="accessLimited" column="access_limited" />
<result property="failureLimited" column="failure_limited" />
<result property="realUser" column="realuser" />
<result property="contact" column="contact" />
<result property="rowId" column="rowid_" />
</resultMap>
<resultMap id="AdminUser_password"
class="com.hzmc.capaa.domain.persistence.trustuser.AdminUser">
<result property="username" column="username" />
<result property="password" column="password" />
<result property="status" column="account_status" />
<result property="active" column="account_active" />
<result property="enabled" column="enabled" />
<result property="roles" column="granted_role" />
<result property="created" column="created" />
<result property="expiryDate" column="expiry_date" />
<result property="lockDate" column="lock_date" />
<result property="changePasswordDate" column="change_date" />
<result property="changePasswordAccessNumber"
column="change_acesses" />
<result property="accessLimited" column="access_limited" />
<result property="lockFailure" column="lock_failure" />
<result property="failureLimited" column="failure_limited" />
<result property="realUser" column="realuser" />
<result property="contact" column="contact" />
<result property="rowId" column="rowid_" />
</resultMap>
<cacheModel id="trustUserCache" type="MEMORY" >
<flushOnExecute statement="AdminUser_updatePassword" />
<flushOnExecute statement="AdminUser_updateAcesses" />
<flushOnExecute statement="AdminUser_updateLoginAcesses" />
<flushOnExecute statement="AdminUser_addAdminUser" />
<flushOnExecute statement="AdminUser_updateAdminUser" />
<flushInterval hours="2" />
<property name="size" value="50"/>
</cacheModel>
<resultMap id="AdminUser_password"
class="com.hzmc.capaa.domain.persistence.trustuser.AdminUser">
<result property="username" column="username" />
<result property="password" column="password" />
</resultMap>
<select id="AdminUser_checkIsSame"
parameterMap="AdminUser_chackIsSame" resultMap="AdminUser_password">
select username,password from mc$$lg_adminUser where username=?
and password=?
</select>
<update id="AdminUser_updatePassword"
parameterMap="AdminUser_updatePassword">
update mc$$lg_adminuser set password=?,change_acesses=? where
username=?
</update>
<update id="AdminUser_updateAcesses"
parameterMap="AdminUser_updateAccess">
update mc$$lg_adminuser set change_acesses=? where username=?
</update>
<update id="AdminUser_updateLoginAcesses"
parameterMap="AdminUser_updateLoginAccess">
update mc$$lg_adminuser set lock_failure=lock_failure+1 where
username=?
</update>
<select id="AdminUser_passwordCheck" parameterClass="string"
resultMap="AdminUser_password">
select username,password ,account_status,account_active,enabled,
granted_role, created ,expiry_date, lock_date, change_date ,
change_acesses,access_limited,lock_failure,failure_limited,
realuser ,contact,rowid rowid_ from mc$$lg_adminuser where
username=#username#
</select>
<select id="AdminUser_getAdminUser"
resultMap="AdminUser_resultLists" >
select rownum rownum_,rowid rowid_,row_.* from (select * from
mc$$lg_adminuser )row_ where rowid=#rowId#
</select>
<!-- 模糊查询不能用#,#在是用prepareStatement的?插入参数,$是文本替换 -->
<insert id="AdminUser_addAdminUser" parameterMap="addAdminUser">
insert into mc$$lg_adminuser
(username,password,enabled,GRANTED_ROLE,EXPIRY_DATE,LOCK_DATE,CHANGE_DATE,access_limited,failure_limited,realUser,contact)values(?,?,?,?,?,?,?,?,?,?,?)
</insert>
<update id="AdminUser_updateAdminUser"
parameterMap="updateAdminUser">
update mc$$lg_adminuser set
username=?,password=?,enabled=?,granted_role=?,expiry_date=?,lock_date=?,change_date=?,access_limited=?,failure_limited=?,realuser=?,contact=?
where rowid=?
</update>
<update id="AdminUser_updateAdminUserAndNotUpdatePassword"
parameterMap="updateAdminUser_notUpdatePassword">
update mc$$lg_adminuser set
username=?,enabled=?,granted_role=?,expiry_date=?,lock_date=?,change_date=?,access_limited=?,failure_limited=?,realuser=?,contact=?
where rowid=?
</update>
<delete id="AdminUser_delete">
delete from mc$$lg_adminuser where rowid=#rowId#
</delete>
<select id="AdminUser_isExists" parameterClass="string"
resultMap="select" cacheModel="trustUserCache">
select username,password ,account_status, granted_role, realuser
,contact, created ,expiry_date, lock_date, change_date ,rowid
from mc$$lg_adminuser where username=#username#
</select>
<select id="AdminUser_UpdateExists"
parameterMap="CheckupdateAdminUser" resultMap="select">
select username,password ,account_status, granted_role, realuser
,contact, created ,expiry_date, lock_date, change_date ,rowid
from mc$$lg_adminuser where username=? and rowid!=?
</select>
<select id="AdminUser_list" resultMap="select">
select
username,password,account_status,granted_role,realuser,contact,created,expiry_date,lock_date,change_date,change_acesses,rowid
from mc$$lg_adminuser
</select>
<!-- 以下是新加的分页的查询统计方法 测试用-->
<select id="AdminUser_countUser" parameterClass="com.hzmc.common.domain.Page"
resultClass="int">
select count(*) from mc$$lg_adminuser
<dynamic prepend="WHERE">
<isNotEmpty prepend="AND" property="searchParameters.username">
upper(username) like upper('%$searchParameters.username$%')
</isNotEmpty>
<isNotEmpty prepend="AND" property="searchParameters.realUser">
upper(realuser) like upper('%$searchParameters.realUser$%')
</isNotEmpty>
<isNotEmpty prepend="AND" property="searchParameters.status">
upper(account_status) like upper('%$searchParameters.status$%')
</isNotEmpty>
<isNotEmpty prepend="AND" property="searchParameters.roles">
upper(granted_role) like upper('%$searchParameters.roles$%')
</isNotEmpty>
<isNotEmpty prepend="AND" property="searchParameters.contact">
upper(contact) like upper('%$searchParameters.contact$%')
</isNotEmpty>
</dynamic>
</select>
<select id="AdminUser_searchResults"
parameterClass="com.hzmc.common.domain.Page"
resultMap="AdminUser_resultList">
select * from (select rowid rowid_,rownum rownum_,row_.* from
(select * from mc$$lg_adminuser
<dynamic prepend="WHERE">
<isNotEmpty prepend="AND" property="searchParameters.username">
upper(username) like upper('%$searchParameters.username$%')
</isNotEmpty>
<isNotEmpty prepend="AND" property="searchParameters.realUser">
upper(realuser) like upper('%$searchParameters.realUser$%')
</isNotEmpty>
<isNotEmpty prepend="AND" property="searchParameters.status">
upper(account_status) like upper('%$searchParameters.status$%')
</isNotEmpty>
<isNotEmpty prepend="AND" property="searchParameters.roles">
upper(granted_role) like upper('%$searchParameters.roles$%')
</isNotEmpty>
<isNotEmpty prepend="AND" property="searchParameters.contact">
upper(contact) like upper('%$searchParameters.contact$%')
</isNotEmpty>
</dynamic>
)row_)
<isEqual prepend="WHERE" property="paged" compareValue="true">
rownum_ between #startNumber# and #endNumber#
</isEqual>
order by created desc
</select>
<select id="AdminUser_Details" parameterMap="AdminUser_showDetail"
resultMap="AdminUser_resultList">
select * from (select rowid rowid_,rownum rownum_,row_.* from
(select * from mc$$lg_adminuser )row_)where rowid_=? desc
</select>
<select id="Adminuser_getRowId" parameterClass="string" resultClass="string">
select ROWID from MC$$LG_ADMINUSER where USERNAME=#value#
</select>
</sqlMap>
发表评论
-
struts2+spring2.6+hibernate3.4
2009-11-09 12:23 1987最近自己华了几天的时间,搭了一个ssh的架构,现在写 ... -
ibatis 对连接池的支持
2009-07-21 15:53 4182ibatis 对连接池的支持有3种,SIMPLE.DB ... -
我在学习ibatis时的培训ppt
2009-04-15 09:40 2698我在学习ibatis时的PPT,现在共享出来给大家,希望对需要 ... -
ibatis的动态sql,call proc等需要注意的地方(经验总结)
2009-04-10 10:06 27081环境:ibatis2.3,spring2.5. ... -
ibatis调用oracle的动态sql,sql大小不能超过32K
2009-04-03 10:22 22931环境:oracle10g,spring2.5,ibatis2 ... -
ibatis调用oracle的函数,存储过程的方法 IN 和OUT /游标(第五章)
2009-04-02 15:48 21111对于全部是in 类 ... -
ibatis的sqlMap配置文件(包含第三章)
2009-03-20 14:40 2120(1):sqlMapConfig.xml文件是Ibatis ... -
ibatis union oracle(第四章bean)
2009-01-07 10:31 2178ibatis中使用联合查询,com.hzmc. ... -
ibatis的优点和好处(包含一二章节)
2008-12-10 11:15 1941Ibatis的优势。 Ibatis是一个混合性的解决方案,吸 ... -
ibatis jdbcType Boolean oracle(第五章)
2008-12-10 11:11 3736最近在用spring+ibatis+oracle开发一个安全产 ...
相关推荐
ibatis学习 ibatis总结 ibatis ibatis ibatis
ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料ibatis资料
ibatis demo,ibatis例子,ibatis示例
iBATIS 级联iBATIS 级联iBATIS 级联
ibatis集成memcached做缓存 可用..经验证过
ibatis
ibatis的原码 ibatis源码 ibatis源码 ibatis源码
ibatis 批量 增删改查
ibatis中使用安全的拼接语句,动态查询,大于、小于、等于.doc
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.doc
ajax和ibatis的综合应用例子,内带了Ibaties的配置文件,是实现的一个读取XML文件的例子
Spring与iBATIS的集成 iBATIS似乎已远离众说纷纭的OR框架之列,通常人们对非常流行的Hibernate情有独钟。但正如Spring A Developer's Notebook作者Bruce Tate 和Justin Gehtland所说的那样,与其他的OR框架相比...
ibatis 乱码解决 ibatis乱码 gbk iso_8859_1 乱码
ibatis常用的sql语句,很全的一篇文档。。。