import java.sql.*;
public class TestOrcalPage {
/**
* @param args
*/
public static void main(String[] args) {
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
String user = "cms_02";
String password = "cms_02";
//连接数据库执行存储过程
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user,password);
String sql = "{call fenye(?,?,?,?,?,?)}";
CallableStatement st = conn.prepareCall(sql);
//赋值
st.setString(1, "book");
st.setInt(2, 5);
st.setInt(3, 1);
//注册总记录数
st.registerOutParameter(4, oracle.jdbc.OracleTypes.INTEGER);
//注册总页数
st.registerOutParameter(5, oracle.jdbc.OracleTypes.INTEGER);
//注册返回的结果集
st.registerOutParameter(6, oracle.jdbc.OracleTypes.CURSOR);
//执行
st.execute();
//取出总记录数
int rowNum = st.getInt(4);
//取出总页数
int pageCount = st.getInt(5);
//得到结果集
ResultSet rs = (ResultSet)st.getObject(6);
//测试结果
System.out.println("rowNum=" + rowNum);
System.out.println("pageCount=" + pageCount);
while(rs.next()){
System.out.println("图书编号:" + rs.getInt(1) + " 图书名称:" + rs.getString(2) + " 出版社:" + rs.getString(3));
}
st.close();
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
package com.sp;
import java.sql.*;
public class TestOrcal {
/**
* @param args
*/
public static void main(String[] args) {
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
String user = "cms_02";
String password = "cms_02";
//连接数据库执行存储过程
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user,password);
String sql = "{call TESTC(?,?)}";
CallableStatement statement = conn.prepareCall(sql);
statement.setInt(1, 20);
statement.registerOutParameter(2, oracle.jdbc.OracleTypes.CURSOR);
statement.execute();
//执行得到结果集
ResultSet rs = (ResultSet)statement.getObject(2);
while(rs.next()){
System.out.println(" " + rs.getInt(1) + " " + rs.getString(2) + " " + rs.getString(3));
}
statement.close();
conn.close();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@page import="java.sql.CallableStatement"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.SQLException"%>
<%@page import="java.text.DateFormat"%>
<%@page import="java.text.ParseException"%>
<%@page import="java.text.SimpleDateFormat"%>
<%@page import="java.util.Calendar"%>
<%@page import="java.util.Date"%>
<%
DateFormat sdf = new SimpleDateFormat("yyyyMMdd");
String startTime = request.getParameter("startTime");
String endTime = request.getParameter("endTime");
System.out.println("开始时间:" + startTime);
System.out.println("结束时间:" + endTime);
int days = 0;
Date startDate = null;
Date endDate = null;
try {
startDate = sdf.parse(startTime);
endDate = sdf.parse(endTime);
days = (int) ((endDate.getTime() - startDate.getTime()) / 1000 / 60 / 60 / 24);
System.out.println(">>>>>>>>>>>>>>>FOR循环总天数:" + days);
} catch (ParseException e) {
e.printStackTrace();
}
Date dateEnd = startDate;
Calendar c = Calendar.getInstance();
c.setTime(startDate);
c.add(Calendar.DATE, -1);
Date dateStart = c.getTime();
System.out.println("-----------开始时间--------:"+ sdf.format(dateStart));
Date dateStart1 = dateStart;
for (int i = 0; i <= days; i++) {
Calendar csta = Calendar.getInstance();
csta.setTime(dateStart1);
csta.add(Calendar.DATE, 1);
dateStart1 = csta.getTime();
String dateStart_or = sdf.format(dateStart1) + "00:00:00";
System.out.println("=========start=======:"+ sdf.format(dateStart1));
Calendar cend = Calendar.getInstance();
cend.setTime(dateEnd);
cend.add(Calendar.DATE, 1);
dateEnd = cend.getTime();
String dateEnd_or = sdf.format(dateEnd) + "00:00:00";
System.out.println("=========end=======:" + sdf.format(dateEnd));
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@10.141.2.102:1521:portal1";
String user = "cms_02";
String password = "free100%ok";
//连接数据库执行存储过程
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user,password);
String sql = "{call publish_article_count_CS(?,?)}";
CallableStatement statement = conn.prepareCall(sql);
statement.setString(1, dateStart_or);
statement.setString(2, dateEnd_or);
statement.execute();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
//每天执行完,延迟1秒
try {
Thread.sleep(1000);
} catch (InterruptedException e) {
e.printStackTrace();
}
}
StringBuffer json = new StringBuffer();
json.append("{");
json.append("\"flag\":\"");
json.append("1");
json.append("\"");
json.append("}");
//执行结果
out.print(json);
%>