addmeeting.java

来自「个人办公平台,用JAVA开发的TOMCAT的服务器」· Java 代码 · 共 101 行

/*
 * Created on 2006-9-22
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package com.skyhawk.hydb;

import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.sql.Connection;
import java.sql.*;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * @author Administrator
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
public class AddMeeting {
	public void add(HttpServletRequest request,HttpServletResponse response) throws UnsupportedEncodingException{
		request.setCharacterEncoding("GBK");
		
		String meeting=request.getParameter("meeting");
		String recordid=request.getParameter("recordid");
		String empid=request.getParameter( "empid");
		String starttime=request.getParameter("starttime");
		String endtime=request.getParameter("endtime");

		System.out.println(meeting);
		System.out.println(recordid);
		System.out.println(empid);
		System.out.println(starttime);
		System.out.println(endtime);
		
		Statement stmt = null;
		Connection con=null;
		ResultSet rs=null;		
		try {
			Connection1 conn=new Connection1();
			con=Connection1.getConnection(request,response);
			stmt = con.createStatement();
			System.out.print(recordid+"::::::::::::");
			rs=stmt.executeQuery("select * from o_personcon where recordid='"+recordid+"'");
			if(rs.next()){
				System.out.println("此编号已占用");
				try {
					request.getRequestDispatcher("/alert8.jsp").forward(request,response);
				} catch (ServletException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				} catch (IOException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}
			}
		
			else{
			
		System.out.println(meeting+"wflajsdf++++");
			try {
				
				stmt.executeUpdate("insert into O_personcon values('"+recordid+"','"+meeting+"','"+empid+"')");
				stmt.executeUpdate("insert into O_roomrecord values('0','0','0',to_date('"+starttime+"','yyyy-mm-dd HH24:MI:SS'),'"+recordid+"',to_date('"+endtime+"','yyyy-mm-dd HH24:MI:SS'),'"+meeting+"','0','0')");
			} catch (SQLException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
		
			
				try {
					request.setAttribute("recordid",recordid);
					request.setAttribute("meeting",meeting);
					request.setAttribute("empid",empid);
					request.setAttribute("starttime",starttime);
					request.setAttribute("endtime",endtime);
						
					request.getRequestDispatcher("/xzhy.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 e) {
				   // TODO Auto-generated catch block
				   e.printStackTrace();
			   }
		
		}	 
}