📄 viewreport.java
字号:
package servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
/**
* Servlet implementation class for Servlet: searchroom
*
*/
public class viewReport extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
static final long serialVersionUID = 1L;
private String price="0",typ="default";
private int pr=0,dlp=0,ulp=0;
/*
* (non-Java-doc)
*
* @see javax.servlet.http.HttpServlet#HttpServlet()
*/
public viewReport() {
super();
}
/*
* (non-Javadoc)
*
* @see javax.servlet.Servlet#destroy()
*/
public void destroy() {
// TODO Auto-generated method stub
super.destroy();
}
/*
* (non-Java-doc)
*
* @see javax.servlet.http.HttpServlet#doGet(HttpServletRequest request,
* HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
}
/*
* (non-Java-doc)
*
* @see javax.servlet.http.HttpServlet#doPost(HttpServletRequest request,
* HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html;");
PrintWriter out=response.getWriter();
HttpSession session=request.getSession(true);
roomBean rmb = (roomBean)session.getAttribute("rmb");
userBean uber = (userBean)session.getAttribute("uber");// get session
bookBean bb=(bookBean)session.getAttribute("bb"); // bean
if (rmb == null) { rmb = new roomBean(); }// set a new bean object
else ;
if (uber == null) { response.sendRedirect("memberZone.jsp"); }// set a new bean object
else ;
String userName=uber.getUsername();
String userID=uber.getId();
String query="default";
String operator=request.getParameter("operator");
String searchType="none";
query = "select * from Report where processor='"+operator+"';";
//determine search type: res,pay,bill,other...
try
{
int rowNum=0;
ServletContext context = getServletContext();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String appDirRoot = context.getRealPath("/");
String driver = "Driver={Microsoft Access Driver (*.mdb)}";
String dbq = "DBQ=E:\\Java\\Tomcat 6.0\\webapps\\ROOT\\database\\HRSDB.mdb";
String connectionString = "jdbc:odbc:"+driver+";"+dbq;
Connection conn = DriverManager.getConnection(connectionString);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery(query); //execute query
ResultSetMetaData rm=rs.getMetaData();
int colNum=rm.getColumnCount();
int lp=1;
int lop=1;
if (!rs.wasNull())
{
if (rs.next())
{
for (rs.first(); !rs.isAfterLast(); rs.next())
{
rowNum++;
}// get row number
}
}//determine whether or not the result set is null
String data[][]=new String[rowNum+2][colNum+1];
for (int i=0;i<(colNum);i++)
{
data[0][i]=rm.getColumnName(i+1);
}//get column name
for (rs.first();!rs.isAfterLast();rs.next())
{
for (int i=0;i<(colNum);i++)
{
data[lop][i]=rs.getString(i+1);
}
lop++;
}
out.println("<html><head><title>Search Result</title>");
out.println("<script src=\"inc/back.js\" type=\"text/javascript\"> var bLoadComplete = false;window.onload = f_iframeResize; </script>");
out.println("<style type=\"text/css\"><!--body {font-family: Arial, Helvetica, sans-serif;font-size: 12px;");
out.println("color: #0099FF;text-decoration: blink;background-color: transparent;border: none;");
out.println("} td {text-align:center;width:25%;}i {text-decoration:inherit;table-layout:auto;}tr.title {font-size:18px;}");
out.println("tr.column{font-size:16px;}.column{border-bottom-color:#990099;border-bottom-style:solid;}--></style>");
out.println("</head>");
out.println("<body>");
out.println("<table style=\"width:100%;\">");
out.println("<tr class=\"title\"><td colspan=\""+colNum+"\"><i>History Details</i></td></tr>");
out.println("<tr class=\"column\">");
for(int i=0;i<(colNum+1);i++)
{
out.println("<td>"+data[0][i]+"</td>");
}
out.println("</tr>");
out.println("<tr><td colspan=\""+colNum+"\"><hr class=\"column\" /></td></tr><tr>");
for (int i=1;i<(rowNum+1);i++)
{
for (int k=0;k<colNum;k++)
{
out.println("<td>");
out.println(data[i][k]);
out.println("</td>");
}
out.println("<td><a href=\"./XML/"+data[i][colNum-1]+"\">Detail...</a>");
out.println("</td>");
out.println("</tr>");
}//output all data
out.println("</table>");
out.println("<input type=\"button\" value=\"Back...\" onClick=\"history.back()\" />");
out.println("</body></html>");
//output page
rs.close();
stmt.close();
conn.close();
}
catch(SQLException e)
{
out.println("<html><head><title>Search Result</title>");
out.println("<script src=\"inc/back.js\" type=\"text/javascript\"></script>");
out.println("<script language=\"javascript\" type=\"text/javascript\"> var bLoadComplete = false;window.onload = f_iframeResize; </script>");
out.println("<style type=\"text/css\"><!--body {font-family: Arial, Helvetica, sans-serif;font-size: 12px;");
out.println("color: #0099FF;text-decoration: blink;background-color: transparent;border: none;");
out.println("}--></style>");
out.println("</head>");
out.println("<body>");
out.println("Sorry,there is no more History available... ");
out.println("<input type=\"button\" value=\"Back...\" onClick=\"history.back()\" />");
out.println("</body></html>");
//go to null result set page
}
catch (Exception e) {
out.println("Other: Error occur!"+e.getCause());
out.println("Details: "+e.getStackTrace());
} //other error detector
}
/*
* (non-Javadoc)
*
* @see javax.servlet.GenericServlet#init()
*/
public void init() throws ServletException {
// TODO Auto-generated method stub
super.init();
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -