在前台页面,需要一些值来显示,这些值在数据库写了存储方法,下面是我的代码,有些问题,想求教各位!
<%@ page language="java" contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.util.*,java.text.*,java.sql.*" %>
<jsp:useBean id="sqlCon" class="resources.bea.bean.DBBean" scope="page"/>
<%
String i_tjny = "200501";
int o_hjsb = 0;
int o_beijingsb = 0;
int o_tianjinsb = 0;
int o_hebeisb = 0;
int o_shanxisb = 0;
int o_neimengsb = 0;
int o_liaoningsb= 0;
int o_daliansb = 0;
int o_jilinsb = 0;
int o_helongjiangsb = 0;
int o_gansuqf = 0;
int o_qinghaiqf = 0;
int o_ningxiaqf = 0;
int o_xinjiangqf = 0;
String strSQL = "";
java.sql.ResultSet sqlRst; //结果集对象
//准备SQL语句
strSQL = "{call PRO_FGD(i_tjny, o_hjsb, o_beijingsb, o_tianjinsb, o_hebeisb, o_shanxisb, o_neimengsb, o_liaoningsb, o_daliansb,o_jilinsb,o_helongjiangsb, ";
strSQL =strSQL+ " o_gansuqf,o_qinghaiqf,o_ningxiaqf,o_xinjiangqf)}";
%>
<html lang="zh"> <head>
<meta name="generator" content="Adobe GoLive">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>JSP数据库操作例程 - 存储过程</title>
<style type="text/css" media="screen">
<!--
table td { line-height: 20px }
.titles { line-height: 24px ; font-weight:bold;color:#FFFFFF; text-align:center;}
-->
</style>
</head>
<%
//准备可调用语句对象
sqlRst = sqlCon.executeQuery(strSQL); //设置输入参数
sqlRst.setString(2,o_hjsb); //登记输出参数
sqlRst.registerOutParameter(1,java.sql.Types.VARCHAR);
sqlRst.registerOutParameter(3,java.sql.Types.INTEGER); //执行该存储过程并返回结果集
sqlRst = sqlCon.executeQuery();
//获取来自结果集中的数据
sqlRst.next();
i_tjny = sqlRst.getString(1);
//获取输出参数的值
o_beijingsb = sqlCon.getString(3); //获取返回值
o_hjsb = sqlRst.getInt(2);
out.print("<td nowrap align='center'>"+o_beijingsb+"</td>");
out.print("<td nowrap align='center'>"+o_hjsb+"</td>");
//关闭记录集
sqlRst.close(); //关闭可调用语句对象
sqlRst.close(); //关闭数据库对象
sqlCon.closeConnection();
%> <body bgcolor="#ffffff">
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#000000">
<tr>
<td rowspan="2" nowrap bgcolor="#0099ff" class="titles">地区</td>
<td height="22" nowrap bgcolor="#0099ff" class="titles">本月上报数据条数</td>
<td height="22" nowrap bgcolor="#0099ff" class="titles">本月清分数据条数</td>
</tr>
<tr>
<td nowrap bgcolor="#0099ff" class="titles">1</td>
<td nowrap bgcolor="#0099ff" class="titles">2</td>
</tr>
</table>
</body>
</html>
<%@ page language="java" contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.Connection"%>
<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.util.*,java.text.*,java.sql.*" %>
<jsp:useBean id="sqlCon" class="resources.bea.bean.DBBean" scope="page"/>
<%
String i_tjny = "200501";
int o_hjsb = 0;
int o_beijingsb = 0;
int o_tianjinsb = 0;
int o_hebeisb = 0;
int o_shanxisb = 0;
int o_neimengsb = 0;
int o_liaoningsb= 0;
int o_daliansb = 0;
int o_jilinsb = 0;
int o_helongjiangsb = 0;
int o_gansuqf = 0;
int o_qinghaiqf = 0;
int o_ningxiaqf = 0;
int o_xinjiangqf = 0;
String strSQL = "";
java.sql.ResultSet sqlRst; //结果集对象
//准备SQL语句
strSQL = "{call PRO_FGD(i_tjny, o_hjsb, o_beijingsb, o_tianjinsb, o_hebeisb, o_shanxisb, o_neimengsb, o_liaoningsb, o_daliansb,o_jilinsb,o_helongjiangsb, ";
strSQL =strSQL+ " o_gansuqf,o_qinghaiqf,o_ningxiaqf,o_xinjiangqf)}";
%>
<html lang="zh"> <head>
<meta name="generator" content="Adobe GoLive">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>JSP数据库操作例程 - 存储过程</title>
<style type="text/css" media="screen">
<!--
table td { line-height: 20px }
.titles { line-height: 24px ; font-weight:bold;color:#FFFFFF; text-align:center;}
-->
</style>
</head>
<%
//准备可调用语句对象
sqlRst = sqlCon.executeQuery(strSQL); //设置输入参数
sqlRst.setString(2,o_hjsb); //登记输出参数
sqlRst.registerOutParameter(1,java.sql.Types.VARCHAR);
sqlRst.registerOutParameter(3,java.sql.Types.INTEGER); //执行该存储过程并返回结果集
sqlRst = sqlCon.executeQuery();
//获取来自结果集中的数据
sqlRst.next();
i_tjny = sqlRst.getString(1);
//获取输出参数的值
o_beijingsb = sqlCon.getString(3); //获取返回值
o_hjsb = sqlRst.getInt(2);
out.print("<td nowrap align='center'>"+o_beijingsb+"</td>");
out.print("<td nowrap align='center'>"+o_hjsb+"</td>");
//关闭记录集
sqlRst.close(); //关闭可调用语句对象
sqlRst.close(); //关闭数据库对象
sqlCon.closeConnection();
%> <body bgcolor="#ffffff">
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#000000">
<tr>
<td rowspan="2" nowrap bgcolor="#0099ff" class="titles">地区</td>
<td height="22" nowrap bgcolor="#0099ff" class="titles">本月上报数据条数</td>
<td height="22" nowrap bgcolor="#0099ff" class="titles">本月清分数据条数</td>
</tr>
<tr>
<td nowrap bgcolor="#0099ff" class="titles">1</td>
<td nowrap bgcolor="#0099ff" class="titles">2</td>
</tr>
</table>
</body>
</html>
解决方案 »
- 数组存数的顺序问题,,
- eclipse中创建web工程,为什么我把编译器改成 1.5后在项目名上就会出错
- 有一字符串“asdfghjkOKdddddrwertyrt”我想获取“OK”字符前的所有字符如何处理呀,请高手帮忙。
- 紧急求助!如何对数据库中读出的记录list进行手工排序?
- 请问各位是否有类似CSDN的校验码代码,谢谢!(JAVA版)
- 怎样在网页中实现在文本框内光标闪烁处,点击按钮插入一个固定的字符串?
- 在Eclipse+Tomcat下如何建一个hello. Jsp啊.工程新建成哪种?
- ——批评有分——ResultSet的弊病,自写Bean_没信息_大家PP__——
- servlet--页面显示空白
- 函数调用问题!有数据库!3x!
- 求助!子窗口翻页时向父窗口的传值问题
- 怎么在web里用log4j?
CallableStatement stmt=con.prepareCall("{call 存储过程名(?,?,?......)}");
stmt.setString(1,变量);
................