java 调用存储过程
来源:互联网 发布:编辑声音的软件 编辑:程序博客网 时间:2024/06/06 03:48
1.jdbc
System.out.println("jdbc 调用-------------");
Connection conn = session.connection();
ResultSet rs =null;
CallableStatement call;
try {
call = conn.prepareCall("{Call proc_stuInfo()}");
rs = call.executeQuery();
while(rs.next()){
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
System.out.println(rs.getString(4));
System.out.println(rs.getString(5));
System.out.println(rs.getString(6));
System.out.println(rs.getString(7));
System.out.println("------------------");
}
} catch (SQLException e) {
e.printStackTrace();
}
2
SQLQuery query = session.createSQLQuery("{call proc_stuInfo()}").addEntity(StuInfo.class);
List list =query.list();
System.out.println(list.get(0));
注:若需要调用的存储过程返回查询数据,则addEntity(Clazz.class) 不能缺
3
public String companyDetail() {
String id = getRequest().getParameter("id");
this.company = (Company) baseDAO.get(Company.class, id);
List<Object> param = new ArrayList<Object>();
param.add(1);
List<Company> comlist = baseDAO.callProc("proc_company(?)", Company.class, param);
System.out.println(comlist.size());
return SUCCESS;
}
public List<T> callProc(String procName,Class<T> clazz,Object... param ){
Query q = null;
if (clazz != null) {
q = this.getCurrentSession().createSQLQuery("{Call " + procName + "}").addEntity(clazz);
}else{
q = this.getCurrentSession().createSQLQuery("{Call " + procName + "}");
}
if (param != null ) {
for (int i = 0; i < param.length; i++) {
q.setParameter(i, param[i]);
}
}
if (clazz!=null) {
return q.list();
}
else{
q.executeUpdate();
return null;
}
}
System.out.println("jdbc 调用-------------");
Connection conn = session.connection();
ResultSet rs =null;
CallableStatement call;
try {
call = conn.prepareCall("{Call proc_stuInfo()}");
rs = call.executeQuery();
while(rs.next()){
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
System.out.println(rs.getString(4));
System.out.println(rs.getString(5));
System.out.println(rs.getString(6));
System.out.println(rs.getString(7));
System.out.println("------------------");
}
} catch (SQLException e) {
e.printStackTrace();
}
2
SQLQuery query = session.createSQLQuery("{call proc_stuInfo()}").addEntity(StuInfo.class);
List list =query.list();
System.out.println(list.get(0));
注:若需要调用的存储过程返回查询数据,则addEntity(Clazz.class) 不能缺
3
public String companyDetail() {
String id = getRequest().getParameter("id");
this.company = (Company) baseDAO.get(Company.class, id);
List<Object> param = new ArrayList<Object>();
param.add(1);
List<Company> comlist = baseDAO.callProc("proc_company(?)", Company.class, param);
System.out.println(comlist.size());
return SUCCESS;
}
public List<T> callProc(String procName,Class<T> clazz,Object... param ){
Query q = null;
if (clazz != null) {
q = this.getCurrentSession().createSQLQuery("{Call " + procName + "}").addEntity(clazz);
}else{
q = this.getCurrentSession().createSQLQuery("{Call " + procName + "}");
}
if (param != null ) {
for (int i = 0; i < param.length; i++) {
q.setParameter(i, param[i]);
}
}
if (clazz!=null) {
return q.list();
}
else{
q.executeUpdate();
return null;
}
}
阅读全文
0 0
- Java调用存储过程
- Java 调用存储过程
- Java 调用存储过程
- JAVA调用存储过程
- java调用存储过程
- java调用存储过程
- Java调用存储过程
- java调用存储过程
- java调用存储过程
- java 调用存储过程
- JAVA调用存储过程
- java调用存储过程
- java调用存储过程
- java 调用存储过程
- Java调用存储过程
- java调用存储过程
- java调用存储过程
- Java调用存储过程
- unix与linux的文件移动区别
- linux 利用yum源安装mysql
- 类的初始化顺序
- Stuido 配置本地gradle
- 如何禁用和启用mysql外键约束
- java 调用存储过程
- 年老的新进程序员爬坑之路(一)
- 中国巨型机之父——慈云桂
- Flight Yesterday
- C++数值类型与string的相互转换
- MXNet ImageNet-11k
- TCP: time wait bucket table overflow的解决方法
- linux CPU Load负载详解,lscpu详解
- Python机器学习库sklearn里利用决策树模型进行回归分析的原理