myservlet1.java

个人办公平台,用JAVA开发的TOMCAT的服务器

package com.skyhawk.control111;

import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.skyhawk.hydb.Connection1;

public class MyServlet1 extends HttpServlet{
	public void doPost(HttpServletRequest request,HttpServletResponse response){
		System.out.println("myservlet");
		String recordid=null;
		String meeting=null;
		String recordid1=null;
		String meeting1=null;
		Connection conn=null;
		Statement stm=null;
		Statement stm1=null;
		ResultSet rs=null;
		ResultSet rs1=null;
		
		try {
			request.setCharacterEncoding("GBK");
		} catch (UnsupportedEncodingException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		recordid=(String)request.getParameter("recordid");
		meeting=(String)request.getParameter("meeting");
		System.out.println(recordid);
		System.out.println(meeting);
		Connection1 con=new Connection1();
		conn=con.getConnection(request,response);
		try {			
			String starttime=null;
			String endtime=null;
			String empid=null;
			stm=conn.createStatement();
			stm1=conn.createStatement();
			rs=stm.executeQuery("select * from O_roomrecord where recordid='"+recordid+"'or meeting='"+meeting+"'");
			rs1=stm1.executeQuery("select * from O_personcon where recordid='"+recordid+"'or meeting='"+meeting+"'");
			while(rs.next()&&rs1.next()){
			starttime=rs.getString("starttime");
			endtime=rs.getString("endtime");
			recordid1=rs.getString("recordid");
			meeting1=rs.getString("meeting");
			empid=rs1.getString("empid");
			
			System.out.println(empid);
			System.out.println(starttime);
			System.out.println(endtime);
			System.out.println(meeting1);
			}
			request.setAttribute("recordid",recordid1);
			request.setAttribute("meeting",meeting1);
			request.setAttribute("starttime",starttime);
			request.setAttribute("endtime",endtime);
			request.setAttribute("empid",empid);
			
			try {
				request.getRequestDispatcher("/view_l.jsp").forward(request,response);
			} catch (ServletException e2) {
				// TODO Auto-generated catch block
				e2.printStackTrace();
			} catch (IOException e2) {
				// TODO Auto-generated catch block
				e2.printStackTrace();
			}
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		
	}

}