&&&&简单的ibatis连接oracle数据库
&简单的ibatis连接oracle数据库
简单的ibatis连接oracle数据库，简单实用，虽简单，缺不可或缺
若举报审核通过，可奖励20下载分
被举报人：
举报的资源分：
请选择类型
资源无法下载
资源无法使用
标题与实际内容不符
含有危害国家安全内容
含有反动色情等内容
含广告内容
版权问题，侵犯个人或公司的版权
*详细原因：
VIP下载&&免积分60元/年（1200次）
您可能还需要
Q.为什么我点的下载下不了，但积分却被扣了
A. 由于下载人数众多，下载服务器做了并发的限制。若发现下载不了，请稍后再试，多次下载是不会重复扣分的。
Q.我的积分不多了，如何获取积分？
A. 获得积分，详细见。
完成任务获取积分。
论坛可用分兑换下载积分。
第一次绑定手机，将获得5个C币，C币可。
关注并绑定CSDNID，送10个下载分
下载资源意味着您已经同意遵守以下协议
资源的所有权益归上传用户所有
未经权益所有人同意，不得将资源中的内容挪作商业或盈利用途
CSDN下载频道仅提供交流平台，并不能对任何下载资源负责
下载资源中如有侵权或不适当内容，
本站不保证本站提供的资源的准确性，安全性和完整性，同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
数据库下载排行
您当前C币：0&&&可兑换 0 下载积分
兑换下载分:&
消耗C币:0&
立即兑换&&
兑换成功你当前的下载分为 。前去下载资源
你下载资源过于频繁，请输入验证码
如何快速获得积分？
你已经下载过该资源，再次下载不需要扣除积分
简单的ibatis连接oracle数据库
所需积分：1
剩余积分：0
扫描微信二维码精彩活动、课程更新抢先知
VIP会员，免积分下载
会员到期时间：日
剩余下载次数：1000
简单的ibatis连接oracle数据库
剩余次数：&&&&有效期截止到：
你还不是VIP会员VIP会员享免积分 . 专属通道极速下载
VIP下载次数已满VIP会员享免积分 . 专属通道极速下载，请继续开通VIP会员
你的VIP会员已过期VIP会员享免积分 . 专属通道极速下载，请继续开通VIP会员用如下命令，
imp&ss/123@xx&fromuser=ss&touser=ss&file=/opt/oracle/oradata/.dmp
把A机器的备份文件，还原到B机器上。曾经A，B机器字符集不一样，查找网络上资料手工修改一样了。然后在Imp时候，报错内容如下：
----------------------------
following&statement&failed&with&ORACLE&error&6550:
&&DECLARE&&SREC&DBMS_STATS.STATREC;&
BEGIN&SREC.MINVAL&:=&'5DE5516&
&&C53F80020';&SREC.MAXVAL&:=&'9F';&SREC.EAVS&:=&4;&SREC.CHVALS&:=&D&
&&BMS_STATS.CHARARRAY(utl_raw.cast_to_varchar2('5DE20'&
&&),utl_raw.cast_to_varchar2('F36CB35B505EEFA&
&&'),utl_raw.cast_to_varchar2('DE'),utl_raw.cast_t&
&&o_varchar2('DE20'),utl_raw.cast_to_varchar2('D&
&&E55382'),utl_raw.cast_to_varchar2('6C346CE5'),utl_raw.cast_to_v&
&&archar2('A5020'),utl_raw.cast_to_varchar2('&
&&E1A70ED'),utl_raw.cast_to_varchar2('A20'),utl_&
&&raw.cast_to_varchar2('A8FB04E1A0020'),utl_raw.cast_to_varchar2('&
&&A8FB04E1A53165DE5'),utl_raw.cast_to_varchar2('FD753553&
&&82'),utl_raw.cast_to_varchar2('FD'),utl_raw.cast_to_varch&
&&ar2('FD20'),utl_raw.cast_to_varchar2('FB053165&
&&DE5'),utl_raw.cast_to_varchar2('FB020'),utl_raw.cast_to_&
&&varchar2('FB06C346CE5'),utl_raw.cast_to_varchar2('FB06C34&
&&6CE50020'),utl_raw.cast_to_varchar2('FB'),utl_raw.cast_to&
&&_varchar2('FB0'),utl_raw.cast_to_varchar2('FB&
&&'),utl_raw.cast_to_varchar2('FB20'),utl_raw.ca&
&&st_to_varchar2('A516C53F80020'),utl_raw.cast_to_varchar2('00206C&
&&F80020'),utl_raw.cast_to_varchar2(''),utl_r&
&&aw.cast_to_varchar2('FD0'),utl_raw.cast_to_varchar2('0&
&&'),utl_raw.cast_to_varchar2('E6C346CE5002&
&&00020'),'N-S?]',utl_raw.cast_to_varchar2('4E2D53D020'),'N-V??
l&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&8fg&&&&PQlS','NLg(PTXQy?&
&&S?UglPQlS','OsQlS',utl_raw.cast_to_varchar2('4F737F8E516C53F80020'),'Q&
&&tN?',utl_raw.cast_to_varchar2('519C516B5E3956E2'),'S]?lS'&
&&,utl_raw.cast_to_varchar2('5C53F80020'),'S]?lS?N','S]?',utl&
&&_raw.cast_to_varchar2('50200020'),'SW\ql4l','SW\ql4l?','XQeS'&
&&,'Y)NS]','Y)NS]?',utl_raw.cast_to_varchar2('65DE')&
&&,'Y)Np?5',utl_raw.cast_to_varchar2('ED'),'Y)Nu5S','Y)N&
&&u5w',utl_raw.cast_to_varchar2('577F30020'),'Y)Nu5w?e9','Y)N&
&&ujR6T?lS','Y)N??imA?&&&&&&&',utl_raw.cast_to_varchar2('26C340&
&&020'),'Y)N??lS?imA?&&&&&&&&','Y)N??imA?&&','Y)fz?',utl_raw.cast_to_&
&&varchar2('FB04E1A0020'),'Y)fz?S]','Y)?]',utl_raw.cast_to_va&
&&rchar2('165DE50020'),'Y)?]?e9','Y)?]?5w??K[','Y)?4l'&
&&,'Y)?4l?e9','Y)?5S',utl_raw.cast_to_varchar2(''),&
&&'Y)?5SY''O','Y)?5Sbe9','Y)?5w',utl_raw.cast_to_varchar2('&
&&'),utl_raw.cast_to_varchar2('20'),'Y)?]&
&&',utl_raw.cast_to_varchar2('5DE50020'),'Y)?]?l','Y)?]??&
&&KN-_','Y)?4l',utl_raw.cast_to_varchar2('5CE50020'),'Y)?4l?&
&&''O','Y)?5S',utl_raw.cast_to_varchar2('53820020'),'Y)?5w',u&
&&tl_raw.cast_to_varchar2('57F30020'),'Y)?5w?e9','^N`?&
&&??&&PQlS','_&_ft4','b^N&&&&&gI[N??&&&&&&&&PQlS','bXQK
QlS','bXQK
&&utl_raw.cast_to_varchar2('627F8FD065B9FF1AE'),'e?RGV&
&&?rimAg&&&&&&&PQlS','e?Y)^?\rguribg/QlS',utl_raw.cast_to_varchar2('65B0758&
&&665B04EC16C53F80020'),'e?uN??QuV?,Qm^?Q[??
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&','e??&
&&b?l}fV?6b沏?&&&&&&&&g&&&&&&&P',utl_raw.cast_to_varchar2('65B077F377F')&
&&,'gm]?&&&&&&&y?ㄐg&&PQlS','lGN','lGNQlS',utl_raw.cast_to_varchar2('6C474E1A5&
&&16C53F80020'),'lG','lG?lS',utl_raw.cast_to_varchar2('6CF8002
&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&8fg&&&PQlS','w??&
&&PSW\ql4l?','w??PY){Q^???-Y)QlS','|?????p','|??v??N','l4&
&&QlS','l4RQlS','\Ye?SW\?LS:l4gClcbl4e9','knlS','?S',ut&
&&l_raw.cast_to_varchar2('957F8FD0'),'??imA','????'Rg~&
&&l4l',utl_raw.cast_to_varchar2('C346CE50020'),'Rg~l4l?''O','PQI&
&&');&SREC.NOVALS&:=&DBMS_STATS.NUMARRAY(&
&&1012763&
&（。。。。。省略一部分）
&&9,230,231,232,234,235,236,239,244,246,247,248,250,252,253,254);&SREC.EPC&:=&
&&&126;&DBMS_STATS.SET_COLUMN_STATS(NULL,'&WF_P_CONTRACT&','&DEMANDER_&',&NUL&
&&L&,NULL,NULL,366,.209,0,srec,12,6);&END;&
IMP-00003:&ORACLE&error&6550&encountered
ORA-06550:&line&1,&column&3371:
PLS-00103:&Encountered&the&symbol&&Y)N&&when&expecting&one&of&the&following:
&&&(&-&+&case&mod&new&not&null&others&&an&identifier&
&&&&a&double-quoted&delimited-identifier&&&a&bind&variable&&avg
&&&count&current&exists&max&min&prior&sql&stddev&sum&variance
&&&execute&forall&merge&time&timestamp&interval&date
&&&&a&string&literal&with&character&set&specification&
&&&&a&number&&&a&single-quoted&SQL&string&&pipe
&&&&一个带有字符集说明的可带引号的字符串文字&
&&&&一个可带引号的&
--------------------------
从网络查询&&解决办法，就是在exp或imp时加上一个参数来禁用统计信息的导出/导入：&&statistics=none&&&&
请问，还有没有其他的原因，看到导入结果提示里面还显示的有乱码。
但是还原后的数据库，用程序访问，没有乱码？
谢谢帮助。
回复讨论(解决方案)
字符集不一样的话数据导入后会有乱码的&在导入前将目标数据库字符修改&并重启&查询字符集&确认与源数据库一致后再进行数据的导入51035人阅读
Hibernate/Mybatis（12）
该问题，我百度了下，根本没发现什么有价值的文章；还是看源代码（详见最后附录）中的注释，最有效了！
insert，返回值是：新插入行的主键（primary&key）；需要包含&selectKey&语句，才会返回主键，否则返回值为null。
update/delete，返回值是：更新或删除的行数；无需指明resultClass；但如果有约束异常而删除失败，只能去捕捉异常。
queryForObject，返回的是：一个实例对象或null；需要包含&select&语句，并且指明resultMap；
queryForList，返回的是：实例对象的列表；需要包含&select&语句，并且指明resultMap；
我的配置文件如下（desktop_common_sqlMap.xml）：
&typeAlias alias=&UnlockTagInfo& type=&mon.bean.UnlockTagInfo& /&
&resultMap class=&UnlockTagInfo& id=&UnlockTagInfoResult&&
&result column=&id& property=&id& jdbcType=&INTEGER& /&
&result column=&name& property=&name& jdbcType=&VARCHAR& /&
&result column=&description& property=&description& jdbcType=&VARCHAR& /&
&result column=&priority& property=&priority& jdbcType=&INTEGER& /&
&/resultMap&
&insert id=&insertUnlockTagInfo& parameterClass=&map&&
&selectKey resultClass=&int& keyProperty=&id&&
nextval('desktop_unlock_tag_id_seq') as id
&/selectKey&
insert into
desktop_unlock_tag(id,name,description,priority)
values(#id:INTEGER#,#name:VARCHAR#,#description:VARCHAR#,#priority:INTEGER#)
&update id=&updateUnlockTagInfo& parameterClass=&map&&
desktop_unlock_tag
set modify_time=now(),priority=#priority:INTEGER#,
name=#name:VARCHAR#,description=#description:VARCHAR#
id=#id:INTEGER#
&delete id=&deleteUnlockTagInfo& parameterClass=&int&&
delete from
desktop_unlock_tag
where id=#value:INTEGER#
&select id=&countUnlockTagInfo& resultClass=&int&&
select count(*)
desktop_unlock_tag
&sql id=&selectUnlockTagInfo&&
id,name,description,priority
desktop_unlock_tag
&select id=&findUnlockTagInfoById& parameterClass=&int&
resultMap=&UnlockTagInfoResult&&
&include refid=&selectUnlockTagInfo& /&
where id=#id:INTEGER#
&select id=&listUnlockTagInfo& parameterClass=&map&
resultMap=&UnlockTagInfoResult&&
&include refid=&selectUnlockTagInfo& /&
modify_time desc limit #size:INTEGER#
offset #start:INTEGER#
&/select&我的DAO源码如下：
public class UnlockTagDaoImpl extends SqlMapClientDaoSupport implements
UnlockTagDao {
public Integer addItem(String name, String desc, Integer priority) {
SqlMapClientTemplate template = this.getSqlMapClientTemplate();
Map&String, Object& args = new HashMap&String, Object&();
args.put(&name&, name);
args.put(&description&, desc);
args.put(&priority&, priority);
Object key = template.insert(&DesktopCommon.insertUnlockTagInfo&, args);
return (Integer)
public boolean updateItem(Integer id, String name, String description,
Integer priority) {
SqlMapClientTemplate template = this.getSqlMapClientTemplate();
Map&String, Object& args = new HashMap&String, Object&();
args.put(&id&, id);
args.put(&name&, name);
args.put(&description&, description);
args.put(&priority&, priority);
int c = template.update(&DesktopCommon.updateUnlockTagInfo&, args);
if (c & 0) {
} catch (Exception e) {
public boolean deleteItem(Integer id) {
SqlMapClientTemplate template = this.getSqlMapClientTemplate();
int c = template.delete(&DesktopCommon.deleteUnlockTagInfo&, id);
if (c & 0) {
} catch (Exception e) {
public UnlockTagInfo findItemById(Integer id) {
SqlMapClientTemplate template = this.getSqlMapClientTemplate();
UnlockTagInfo item = (UnlockTagInfo) template.queryForObject(
&DesktopCommon.findUnlockTagInfoById&, id);
public PagedList&UnlockTagInfo& listAll(Integer nStart, Integer nSize,
boolean bCountTotal) {
SqlMapClientTemplate template = this.getSqlMapClientTemplate();
PagedList&UnlockTagInfo& result = new PagedList&UnlockTagInfo&();
if (bCountTotal) {
int total = (Integer) template
.queryForObject(&DesktopCommon.countUnlockTagInfo&);
result.setTotal(total);
Map&String, Integer& args = new HashMap&String, Integer&();
args.put(&start&, nStart);
args.put(&size&, nSize);
@SuppressWarnings(&unchecked&)
List&UnlockTagInfo& items = template.queryForList(
&DesktopCommon.listUnlockTagInfo&, args);
result.setData(items);
关于ibatis的接口，参见其源码（com\ibatis\sqlmap\client\SqlMapExecutor.java）:
Copyright 2004 Clinton Begin
Licensed under the Apache License, Version 2.0 (the &License&);
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an &AS IS& BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
package com.ibatis.sqlmap.
import mon.util.PaginatedL
import com.ibatis.sqlmap.client.event.RowH
import com.ibatis.sqlmap.engine.execution.BatchE
import java.sql.SQLE
import java.util.L
import java.util.M
* This interface declares all methods involved with executing statements
* and batches for an SQL Map.
* @see SqlMapSession
* @see SqlMapClient
public interface SqlMapExecutor {
* Executes a mapped SQL INSERT statement.
* Insert is a bit different from other update methods, as it
* provides facilities for returning the primary key of the
* newly inserted row (rather than the effected rows).
* functionality is of course optional.
* The parameter object is generally used to supply the input
* data for the INSERT values.
* @param id
The name of the statement to execute.
* @param parameterObject The parameter object (e.g. JavaBean, Map, XML etc.).
* @return The primary key of the newly inserted row.
This might be automatically
generated by the RDBMS, or selected from a sequence table or other source.
* @throws java.sql.SQLException If an error occurs.
Object insert(String id, Object parameterObject) throws SQLE
* Executes a mapped SQL INSERT statement.
* Insert is a bit different from other update methods, as it
* provides facilities for returning the primary key of the
* newly inserted row (rather than the effected rows).
* functionality is of course optional.
* This overload assumes no parameter is needed.
* @param id
The name of the statement to execute.
* @return The primary key of the newly inserted row.
This might be automatically
generated by the RDBMS, or selected from a sequence table or other source.
* @throws java.sql.SQLException If an error occurs.
Object insert(String id) throws SQLE
* Executes a mapped SQL UPDATE statement.
* Update can also be used for any other update statement type,
* such as inserts and deletes.
Update returns the number of
* rows effected.
* The parameter object is generally used to supply the input
* data for the UPDATE values as well as the WHERE clause parameter(s).
* @param id
The name of the statement to execute.
* @param parameterObject The parameter object (e.g. JavaBean, Map, XML etc.).
* @return The number of rows effected.
* @throws java.sql.SQLException If an error occurs.
int update(String id, Object parameterObject) throws SQLE
* Executes a mapped SQL UPDATE statement.
* Update can also be used for any other update statement type,
* such as inserts and deletes.
Update returns the number of
* rows effected.
* This overload assumes no parameter is needed.
* @param id
The name of the statement to execute.
* @return The number of rows effected.
* @throws java.sql.SQLException If an error occurs.
int update(String id) throws SQLE
* Executes a mapped SQL DELETE statement.
* Delete returns the number of rows effected.
* The parameter object is generally used to supply the input
* data for the WHERE clause parameter(s) of the DELETE statement.
* @param id
The name of the statement to execute.
* @param parameterObject The parameter object (e.g. JavaBean, Map, XML etc.).
* @return The number of rows effected.
* @throws java.sql.SQLException If an error occurs.
int delete(String id, Object parameterObject) throws SQLE
* Executes a mapped SQL DELETE statement.
* Delete returns the number of rows effected.
* This overload assumes no parameter is needed.
* @param id
The name of the statement to execute.
* @return The number of rows effected.
* @throws java.sql.SQLException If an error occurs.
int delete(String id) throws SQLE
* Executes a mapped SQL SELECT statement that returns data to populate
* a single object instance.
* The parameter object is generally used to supply the input
* data for the WHERE clause parameter(s) of the SELECT statement.
* @param id
The name of the statement to execute.
* @param parameterObject The parameter object (e.g. JavaBean, Map, XML etc.).
* @return The single result object populated with the result set data,
or null if no result was found
* @throws java.sql.SQLException If more than one result was found, or if any other error occurs.
Object queryForObject(String id, Object parameterObject) throws SQLE
* Executes a mapped SQL SELECT statement that returns data to populate
* a single object instance.
* This overload assumes no parameter is needed.
* @param id
The name of the statement to execute.
* @return The single result object populated with the result set data,
or null if no result was found
* @throws java.sql.SQLException If more than one result was found, or if any other error occurs.
Object queryForObject(String id) throws SQLE
* Executes a mapped SQL SELECT statement that returns data to populate
* the supplied result object.
* The parameter object is generally used to supply the input
* data for the WHERE clause parameter(s) of the SELECT statement.
* @param id
The name of the statement to execute.
* @param parameterObject The parameter object (e.g. JavaBean, Map, XML etc.).
* @param resultObject
The result object instance that should be populated with result data.
* @return The single result object as supplied by the resultObject parameter, populated with the result set data,
or null if no result was found
* @throws java.sql.SQLException If more than one result was found, or if any other error occurs.
Object queryForObject(String id, Object parameterObject, Object resultObject) throws SQLE
* Executes a mapped SQL SELECT statement that returns data to populate
* a number of result objects.
* The parameter object is generally used to supply the input
* data for the WHERE clause parameter(s) of the SELECT statement.
* @param id
The name of the statement to execute.
* @param parameterObject The parameter object (e.g. JavaBean, Map, XML etc.).
* @return A List of result objects.
* @throws java.sql.SQLException If an error occurs.
List queryForList(String id, Object parameterObject) throws SQLE
* Executes a mapped SQL SELECT statement that returns data to populate
* a number of result objects.
* This overload assumes no parameter is needed.
* @param id
The name of the statement to execute.
* @return A List of result objects.
* @throws java.sql.SQLException If an error occurs.
List queryForList(String id) throws SQLE
* Executes a mapped SQL SELECT statement that returns data to populate
* a number of result objects within a certain range.
* The parameter object is generally used to supply the input
* data for the WHERE clause parameter(s) of the SELECT statement.
* @param id
The name of the statement to execute.
* @param parameterObject The parameter object (e.g. JavaBean, Map, XML etc.).
* @param skip
The number of results to ignore.
* @param max
The maximum number of results to return.
* @return A List of result objects.
* @throws java.sql.SQLException If an error occurs.
List queryForList(String id, Object parameterObject, int skip, int max) throws SQLE
* Executes a mapped SQL SELECT statement that returns data to populate
* a number of result objects within a certain range.
* This overload assumes no parameter is needed.
* @param id
The name of the statement to execute.
* @param skip
The number of results to ignore.
* @param max
The maximum number of results to return.
* @return A List of result objects.
* @throws java.sql.SQLException If an error occurs.
List queryForList(String id, int skip, int max) throws SQLE
* Executes a mapped SQL SELECT statement that returns a number of
* result objects that will be handled one at a time by a
* RowHandler.
* This is generally a good approach to take when dealing with large sets
* of records (i.e. hundreds, thousands...) that need to be processed without
* eating up all of the system resources.
* The parameter object is generally used to supply the input
* data for the WHERE clause parameter(s) of the SELECT statement.
* @param id
The name of the statement to execute.
* @param parameterObject The parameter object (e.g. JavaBean, Map, XML etc.).
* @param rowHandler
A RowHandler instance
* @throws java.sql.SQLException If an error occurs.
void queryWithRowHandler(String id, Object parameterObject, RowHandler rowHandler) throws SQLE
* Executes a mapped SQL SELECT statement that returns a number of
* result objects that will be handled one at a time by a
* RowHandler.
* This is generally a good approach to take when dealing with large sets
* of records (i.e. hundreds, thousands...) that need to be processed without
* eating up all of the system resources.
* This overload assumes no parameter is needed.
* @param id
The name of the statement to execute.
* @param rowHandler
A RowHandler instance
* @throws java.sql.SQLException If an error occurs.
void queryWithRowHandler(String id, RowHandler rowHandler) throws SQLE
* Executes a mapped SQL SELECT statement that returns data to populate
* a number of result objects a page at a time.
* The parameter object is generally used to supply the input
* data for the WHERE clause parameter(s) of the SELECT statement.
* @param id
The name of the statement to execute.
* @param parameterObject The parameter object (e.g. JavaBean, Map, XML etc.).
* @param pageSize
The maximum number of result objects each page can hold.
* @return A PaginatedList of result objects.
* @throws java.sql.SQLException If an error occurs.
* @deprecated All paginated list features have been deprecated
PaginatedList queryForPaginatedList(String id, Object parameterObject, int pageSize) throws SQLE
* Executes a mapped SQL SELECT statement that returns data to populate
* a number of result objects a page at a time.
* This overload assumes no parameter is needed.
* @param id
The name of the statement to execute.
* @param pageSize
The maximum number of result objects each page can hold.
* @return A PaginatedList of result objects.
* @throws java.sql.SQLException If an error occurs.
* @deprecated All paginated list features have been deprecated
PaginatedList queryForPaginatedList(String id, int pageSize) throws SQLE
* Executes a mapped SQL SELECT statement that returns data to populate
* a number of result objects that will be keyed into a Map.
* The parameter object is generally used to supply the input
* data for the WHERE clause parameter(s) of the SELECT statement.
* @param id
The name of the statement to execute.
* @param parameterObject The parameter object (e.g. JavaBean, Map, XML etc.).
* @param keyProp
The property to be used as the key in the Map.
* @return A Map keyed by keyProp with values being the result object instance.
* @throws java.sql.SQLException If an error occurs.
Map queryForMap(String id, Object parameterObject, String keyProp) throws SQLE
* Executes a mapped SQL SELECT statement that returns data to populate
* a number of result objects from which one property will be keyed into a Map.
* The parameter object is generally used to supply the input
* data for the WHERE clause parameter(s) of the SELECT statement.
* @param id
The name of the statement to execute.
* @param parameterObject The parameter object (e.g. JavaBean, Map, XML etc.).
* @param keyProp
The property to be used as the key in the Map.
* @param valueProp
The property to be used as the value in the Map.
* @return A Map keyed by keyProp with values of valueProp.
* @throws java.sql.SQLException If an error occurs.
Map queryForMap(String id, Object parameterObject, String keyProp, String valueProp) throws SQLE
* Starts a batch in which update statements will be cached before being sent to
* the database all at once. This can improve overall performance of updates update
* when dealing with numerous updates (e.g. inserting 1:M related data).
* @throws java.sql.SQLException If the batch could not be started.
void startBatch() throws SQLE
* Executes (flushes) all statements currently batched.
* @return the number of rows updated in the batch
* @throws java.sql.SQLException If the batch could not be executed or if any of the statements
int executeBatch() throws SQLE
* Executes (flushes) all statements currently batched.
* @return a List of BatchResult objects.
There will be one element in the
list for each sub-batch executed.
A sub-batch is created by adding a statement
to the batch that does not equal the prior statement.
* @throws SQLException if a database access error occurs, or the drive
does not support batch statements
* @throws BatchException if the driver throws BatchUpdateException
* @see com.ibatis.sqlmap.engine.execution.BatchException
List executeBatchDetailed() throws SQLException, BatchE
参考知识库
* 以上用户言论只代表其个人观点，不代表CSDN网站的观点或立场
访问：1898602次
积分：19549
积分：19549
排名：第283名
原创：459篇
转载：124篇
译文：11篇
评论：775条
(1)(4)(4)(2)(3)(6)(12)(2)(18)(8)(9)(4)(5)(7)(7)(5)(12)(1)(1)(4)(4)(22)(6)(12)(14)(22)(11)(8)(14)(24)(5)(14)(25)(31)(15)(16)(31)(44)(2)(9)(2)(1)(10)(16)(17)(7)(5)(94)