%@ page contentType="text/html;charset=gb2312" %>
<%@ page import = "java.util.*" %>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<%@ page import="java.util.Date" %>
<%@ page import="AspToJsp.*"%>
<%
String sqlStr1="select countNum from cinfo_counter where belong='english'";
String sqlStr2="select countNum from cinfo_counter where belong='Program'";
MyExeSQL exeSql2 = null;
exeSql2 = new MyExeSQL();
Vector rstVector3 = null;
rstVector3 = exeSql2.execQuery(sqlStr1);
String[] tempArray1 = (String[])rstVector3.elementAt(1);
//out.print("counterNum:"+tempArray1[0]);
int theCounter=0;
theCounter=Integer.parseInt(tempArray1[0])+1;
rstVector3 = exeSql2.execQuery(sqlStr2);
String[] tempArray2 = (String[])rstVector3.elementAt(1);
int theCounter1=0;
theCounter1=Integer.parseInt(tempArray2[0])+1;
Date today=new Date();
String submit_time_now=current.getDate(today);
String sqlModify="update cinfo_counter set countNum="+theCounter+",submitTime=to_date('"+submit_time_now+"','YYYY-MM-DD HH24:MI:SS') where belong='english'";
String sqlModify1="update cinfo_counter set countNum="+theCounter1+",submitTime=to_date('"+submit_time_now+"','YYYY-MM-DD HH24:MI:SS') where belong='Program'";
//out.print(sqlModify);
db.executeUpdate(sqlModify);
db.executeUpdate(sqlModify1);
%>
中国儿童信息中心
| <%@ include file="/common/head.jsp"%> |
| <%@ include file="/common/foot.jsp"%> |