- 浏览: 39103 次
- 性别:
- 来自: 北京
最新评论
调用存储过程
- 博客分类:
- java 后台
public void queryProce( final int deptNo,final String dname,final String loc) {
System.out.println(" 进入");
//没有参数的存储过程
this.getHibernateTemplate().execute(new HibernateCallback(){
public Object doInHibernate(Session session) throws HibernateException, SQLException {
SQLQuery sqlQuery = session.createSQLQuery("{call myproc(?,?,?)}");
sqlQuery.setInteger(0, deptNo);
sqlQuery.setString(1, dname);
sqlQuery.setString(2, loc);
sqlQuery.executeUpdate();
//SQLQuery sqlQuery = session.createSQLQuery("{call myproc3}");
//sqlQuery.executeUpdate();
return null;
}
});
}
public Map<String, Object> queryProceList( final int deptNo, String dname, String loc) {
// TODO Auto-generated method stub
//System.out.println("进入"+deptNo);
final Map<String, Object> map=new HashMap();
this.getHibernateTemplate().execute(new HibernateCallback(){
public Object doInHibernate(Session session) throws HibernateException, SQLException {
Connection conn = session.connection();
CallableStatement procout = conn.prepareCall ("{call myproc4(?,?,?)}");
procout.setInt(1, deptNo);
procout.registerOutParameter (2, Types.VARCHAR);
procout.registerOutParameter (3, Types.VARCHAR);
procout.execute ();
System.out.println ("\nOut argument to procout in PL/SQL block is:\n\t" +
procout.getString(2) + " " + procout.getString (3));
map.put("vale1", procout.getString(2));
map.put("vale2", procout.getString (3));
procout.close();
return null;
}
});
return map;
}
//Call a procedure with an IN parameter
{
CallableStatement procin = conn.prepareCall ("begin procin (?, ?); end;");
procin.setInt (1, 303);
procin.setString (2, "Australia");
procin.execute ();
System.out.println("\ndump table regions after calling to procin--"
+ "insert 303 Australia\n");
dumpTable (conn);
procin.close();
}
// Call a procedure with an OUT parameter
{
CallableStatement procout = conn.prepareCall ("begin procout (?, ?); end;");
procout.registerOutParameter (1, Types.INTEGER);
procout.registerOutParameter (2, Types.CHAR);
procout.execute ();
System.out.println ("\nOut argument to procout in PL/SQL block is:\n\t" +
procout.getInt (1) + " " + procout.getString (2));
procout.close();
}
// Call a procedure with an IN/OUT prameter
// This will insert "404, North Pole" instead of "303, Mars" that
// are in PL/SQL block of procedure procinout into table regions
{
CallableStatement procinout = conn.prepareCall ("begin procinout (?, ?); end;");
procinout.registerOutParameter (1, Types.INTEGER);
procinout.registerOutParameter (2, Types.VARCHAR);
procinout.setInt (1, 404);
procinout.setString (2, "North Pole");
procinout.execute ();
System.out.println ("\ndump table regions after calling to procinout--"
+ "insert 404 North Pole\n");
dumpTable (conn);
System.out.println ("Out argument in PL/SQL block definition of procinout is:\n\t" +
procinout.getInt (1) + " " + procinout.getString (2));
procinout.close();
}
// Call a function with no parameters
{
CallableStatement funcnone = conn.prepareCall ("begin ? := funcnone; end;");
funcnone.registerOutParameter (1, Types.CHAR);
funcnone.execute ();
System.out.println ("\nReturn value of funcnone is: " + funcnone.getString (1));
funcnone.close();
}
// Call a function with an IN parameter
{
CallableStatement funcin = conn.prepareCall ("begin ? := funcin (?); end;");
funcin.registerOutParameter (1, Types.CHAR);
funcin.setString (2, "testing");
funcin.execute ();
System.out.println ("\nReturn value of funcin is: " + funcin.getString (1));
funcin.close();
}
// Call a function with an OUT parameter
{
CallableStatement funcout = conn.prepareCall ("begin ? := funcout (?); end;");
funcout.registerOutParameter (1, Types.CHAR);
funcout.registerOutParameter (2, Types.CHAR);
funcout.execute ();
System.out.println ("\nReturn value of funcout is: " + funcout.getString (1));
System.out.println ("Out argument is: " + funcout.getString (2));
funcout.close();
}
System.out.println(" 进入");
//没有参数的存储过程
this.getHibernateTemplate().execute(new HibernateCallback(){
public Object doInHibernate(Session session) throws HibernateException, SQLException {
SQLQuery sqlQuery = session.createSQLQuery("{call myproc(?,?,?)}");
sqlQuery.setInteger(0, deptNo);
sqlQuery.setString(1, dname);
sqlQuery.setString(2, loc);
sqlQuery.executeUpdate();
//SQLQuery sqlQuery = session.createSQLQuery("{call myproc3}");
//sqlQuery.executeUpdate();
return null;
}
});
}
public Map<String, Object> queryProceList( final int deptNo, String dname, String loc) {
// TODO Auto-generated method stub
//System.out.println("进入"+deptNo);
final Map<String, Object> map=new HashMap();
this.getHibernateTemplate().execute(new HibernateCallback(){
public Object doInHibernate(Session session) throws HibernateException, SQLException {
Connection conn = session.connection();
CallableStatement procout = conn.prepareCall ("{call myproc4(?,?,?)}");
procout.setInt(1, deptNo);
procout.registerOutParameter (2, Types.VARCHAR);
procout.registerOutParameter (3, Types.VARCHAR);
procout.execute ();
System.out.println ("\nOut argument to procout in PL/SQL block is:\n\t" +
procout.getString(2) + " " + procout.getString (3));
map.put("vale1", procout.getString(2));
map.put("vale2", procout.getString (3));
procout.close();
return null;
}
});
return map;
}
//Call a procedure with an IN parameter
{
CallableStatement procin = conn.prepareCall ("begin procin (?, ?); end;");
procin.setInt (1, 303);
procin.setString (2, "Australia");
procin.execute ();
System.out.println("\ndump table regions after calling to procin--"
+ "insert 303 Australia\n");
dumpTable (conn);
procin.close();
}
// Call a procedure with an OUT parameter
{
CallableStatement procout = conn.prepareCall ("begin procout (?, ?); end;");
procout.registerOutParameter (1, Types.INTEGER);
procout.registerOutParameter (2, Types.CHAR);
procout.execute ();
System.out.println ("\nOut argument to procout in PL/SQL block is:\n\t" +
procout.getInt (1) + " " + procout.getString (2));
procout.close();
}
// Call a procedure with an IN/OUT prameter
// This will insert "404, North Pole" instead of "303, Mars" that
// are in PL/SQL block of procedure procinout into table regions
{
CallableStatement procinout = conn.prepareCall ("begin procinout (?, ?); end;");
procinout.registerOutParameter (1, Types.INTEGER);
procinout.registerOutParameter (2, Types.VARCHAR);
procinout.setInt (1, 404);
procinout.setString (2, "North Pole");
procinout.execute ();
System.out.println ("\ndump table regions after calling to procinout--"
+ "insert 404 North Pole\n");
dumpTable (conn);
System.out.println ("Out argument in PL/SQL block definition of procinout is:\n\t" +
procinout.getInt (1) + " " + procinout.getString (2));
procinout.close();
}
// Call a function with no parameters
{
CallableStatement funcnone = conn.prepareCall ("begin ? := funcnone; end;");
funcnone.registerOutParameter (1, Types.CHAR);
funcnone.execute ();
System.out.println ("\nReturn value of funcnone is: " + funcnone.getString (1));
funcnone.close();
}
// Call a function with an IN parameter
{
CallableStatement funcin = conn.prepareCall ("begin ? := funcin (?); end;");
funcin.registerOutParameter (1, Types.CHAR);
funcin.setString (2, "testing");
funcin.execute ();
System.out.println ("\nReturn value of funcin is: " + funcin.getString (1));
funcin.close();
}
// Call a function with an OUT parameter
{
CallableStatement funcout = conn.prepareCall ("begin ? := funcout (?); end;");
funcout.registerOutParameter (1, Types.CHAR);
funcout.registerOutParameter (2, Types.CHAR);
funcout.execute ();
System.out.println ("\nReturn value of funcout is: " + funcout.getString (1));
System.out.println ("Out argument is: " + funcout.getString (2));
funcout.close();
}
发表评论
-
linux 下载并安装Memcache服务器端
2015-07-25 15:50 684下载并安装Memcache服务器端 服务器端主要是安装memc ... -
spring的jar功能说明及个jar包之间的依赖关系
2015-07-24 14:39 350spring.jar是包含有完整发布的单个jar包,sprin ... -
sping
2015-07-07 09:45 540一、简单的用ApplicationContext做测试的话,获 ... -
大型互联网站解决高并发的常见策略
2015-04-10 14:13 654一个运营的系统在正式 ... -
excel
2014-08-22 10:24 558HSSFSheet sheet = workbook. ... -
在线打开word
2012-06-11 12:59 1309在线打开word . 2010-05-10 17:16 184 ... -
Lucene_3.0_原理与代码分析.
2011-12-09 17:54 677Lucene_3.0_原理与代码分析 -
池链接
2011-11-03 17:34 7471. 线程池是啥子 一说 ... -
JAVA中的IO流.txt
2011-11-03 17:32 932JAVA中的IO流是非常重要的知识点,用于文件内容的写入、读取 ... -
quanxian
2011-05-20 16:18 532quanxian -
Restrictions
2011-05-20 11:23 786Restrictions dev.firnow.com ... -
权限设计
2011-05-20 11:21 658权限设计权限设计 -
struts 跳转 action
2011-05-20 11:20 711<result name="showList& ... -
java
2011-05-11 23:04 531大点javaeye -
md5 加密
2011-05-06 15:56 647md5 加密 -
java 导出 excel
2011-05-04 21:49 998java导出Excel例举方式 方法一:导出Excel数据 ... -
java 读取 Excel
2011-05-02 15:44 645private void initMachine() thro ...
相关推荐
java 调用存储过程java 调用存储过程java 调用存储过程java 调用存储过程java 调用存储过程java 调用存储过程java 调用存储过程
birt报表中调用存储过程的方法. 目录 1. 概述 3 2. BIRT支持的存储过程返回值类型 3 3. BIRT调用存储过程的语法 4 4. 创建存储过程数据源/集 4 5. 在BIRT中使用存储过程 5 调用返回单结果集的存储过程。 5 调用...
关于ADO调用存储过程的标准的做法:按照以下步骤进行: 1、生成并初始化一个_CommandPtr对象; 2、生成调用存储过程需要的参数,这些参数都是_ParameterPtr对象; 3、按照顺序将使用_CommandPtr的Append方法为...
hibernate调用存储过程 hibernate调用存储过程 hibernate调用存储过程 hibernate调用存储过程 hibernate调用存储过程 hibernate调用存储过程 hibernate调用存储过程
java,调用存储过程java,调用存储过程java,调用存储过程java,调用存储过程java,调用存储过程java,调用存储过程java,调用存储过程java,调用存储过程java,调用存储过程java,调用存储过程java,调用存储过程
Informatica调用存储过程图文流程
金蝶K3插件开发调用存储过程
java调用存储过程的方法,含还有out参数的存储过程,解决方案,在网上找了n久发现这样的资源太少,现在总结一下我的解决方案供大家分享,希望对大家有用
sqlhelper调用存储过程,sqlhelper调用存储过程方法,sqlhelper怎样调用存储过程
本文实例讲述了C#调用存储过程的方法。分享给大家供大家参考,具体如下: CREATE PROCEDURE [dbo].[GetNameById] @studentid varchar(8), @studentname nvarchar(50) OUTPUT AS BEGIN SELECT @studentname=...
能不能写个动态的业务,只输入存储过程名称,自动获取存储过程参数,并且参数的数据从前台传递过来...只根据输入不同的存储过程名称、参数内容,自动调用不同的存储过程。 已经使用在多个项目中 全开源项目 请放心下载
vb调用存储过程基本教程vb调用存储过程基本教程vb调用存储过程基本教程vb调用存储过程基本教程
一、调用存储过程(无结果集返回) Connection connection = ConnectionHelper.getConnection(); CallableStatement callableStatement = connection.prepareCall("{ call procedureName(?,?) }"); ...
c#调用存储过程两种方法 - - c# sql .net asp.net
Java调用存储过程--传入集合参数 具体的方法描述分析
oracle定时器调用存储过程
oracle 触发器 调用 存储过程 Oracle自治事务(Autonomous Transaction)
这是用JBuilder做的一个简单的例子, 用java代码调用存储过程,实现增删改查。
VB6.0 调用存储过程的例子(方法一) rm1窗体,Copy以下的代码到窗体中,该段代码将测试存储过程ADOTestRPE的返回值、输入参数及输出参数,测试的过程中,可能需要修改链接字符串。