/**
* 调用存储过程p_dtsgdttj_getsql_top:
* 返回sql语句
* sql功能描述: 返回报表表头
* @param startDate 开始日期
* @param endDate 结束日期
* @return String 类型
* 其中:String:sql语句
*
* @throws DAOException 数据访问异常
*/
private static String getTitleSql(String startDate,
String endDate) throws DAOException {
DBconn db = null;
String sql = null; //须返回的sql语句
ResultSet rs = null;
Connection con = null;
CallableStatement call = null;
try {
db = new DBconn();
con = db.getConnection();
call = con.prepareCall("{call p_dtsgdttj_getsql_top(?,?,?,?)}"); //调用存储过程
call.registerOutParameter(3, java.sql.Types.VARCHAR); //登记输出参数为字符串(out)
call.registerOutParameter(4, java.sql.Types.INTEGER); //登记输出参数为数字(out) call.setString(1, startDate); //为in参数赋值
call.setString(2, endDate); //为in参数赋值
rs = call.executeQuery(); //置入结果集中
sql = call.getString(3); //取出字符串
}
catch (ConnectionException e) {
throw new DAOException(e, "统计失败!");
}
catch (SQLException e) {
throw new DAOException(e);
}
* 调用存储过程p_dtsgdttj_getsql_top:
* 返回sql语句
* sql功能描述: 返回报表表头
* @param startDate 开始日期
* @param endDate 结束日期
* @return String 类型
* 其中:String:sql语句
*
* @throws DAOException 数据访问异常
*/
private static String getTitleSql(String startDate,
String endDate) throws DAOException {
DBconn db = null;
String sql = null; //须返回的sql语句
ResultSet rs = null;
Connection con = null;
CallableStatement call = null;
try {
db = new DBconn();
con = db.getConnection();
call = con.prepareCall("{call p_dtsgdttj_getsql_top(?,?,?,?)}"); //调用存储过程
call.registerOutParameter(3, java.sql.Types.VARCHAR); //登记输出参数为字符串(out)
call.registerOutParameter(4, java.sql.Types.INTEGER); //登记输出参数为数字(out) call.setString(1, startDate); //为in参数赋值
call.setString(2, endDate); //为in参数赋值
rs = call.executeQuery(); //置入结果集中
sql = call.getString(3); //取出字符串
}
catch (ConnectionException e) {
throw new DAOException(e, "统计失败!");
}
catch (SQLException e) {
throw new DAOException(e);
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货