<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
response.setContentType("text/html; charset=utf-8");
%>
日志
<%@include file="anquanma.jsp"%>
<%
String shuzu = "[";
String kaishi = "";
String jieshu = "";
String xiangmu = "";
%>
<%
if (request.getParameter("kaishi") != null) {
kaishi = request.getParameter("kaishi");
}
if (request.getParameter("jieshu") != null) {
jieshu = request.getParameter("jieshu");
}
if (request.getParameter("xiangmu") != null) {
xiangmu = request.getParameter("xiangmu");
}
//查询
//装载一个类并且对其进行实例化的操作
Class.forName(driverClass);{
Connection con1=DriverManager.getConnection( url3,user,password);
CallableStatement cs = con1.prepareCall("{call rizhichaxun(?,?,?,?,?)}");
cs.setString(1, kaishi);
cs.setString(2, jieshu);
cs.setString(3, xiangmu);
cs.setString(4, request.getParameter("adminid"));
cs.setString(5, request.getRemoteAddr());
ResultSet rs = cs.executeQuery();
int i = 1;
while (rs.next()) {
shuzu += "{xuhao:'" + i + "'," + "lie1:\""
+ rs.getString(1).toString().replaceAll("\n|\r\t|", "") + "\"," + "lie2:'" + rs.getString(2) + "',"
+ "lie3:'" + rs.getString(3) + "'," + "lie4:'" + rs.getString(4) + "'," + "lie5:'"+ rs.getString(5) + "'," + "lie6:'"
+ rs.getString(6) + "'," + "lie7:'" + rs.getString(7) + "'," + "trShow:true},";
i++;
}
kaishi = cs.getString(1);
jieshu = cs.getString(2);
xiangmu = cs.getString(3);
if (xiangmu.equals("n*")) {
xiangmu = "";
}
if (shuzu.length() > 1) {
shuzu = shuzu.substring(0, shuzu.length() - 1) + ']';
} else {
shuzu = "[]";
}
con1.close();
}
%>