amendmeeting.java

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

/*
 * 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.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

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 AmendMeeting {
  public void amend(HttpServletRequest request,HttpServletResponse response) {
	String meeting=request.getParameter("meeting1");
	System.out.println(meeting+"====lily=====");
    String recordid=request.getParameter("recordid1");
    String empid=request.getParameter("empid1");
    String starttime=request.getParameter("starttime1");
    String endtime=request.getParameter("endtime1");
	System.out.println(meeting+"121");
	System.out.println(recordid+"121");
	System.out.println(empid);
	System.out.println(starttime);
	System.out.println(endtime);
	Connection con=null;
	Statement stmt = null;
	ResultSet rs=null;	
	Connection1 conn=new Connection1();
	con=Connection1.getConnection(request,response);
	System.out.println("lail ai ++-----");
	System.out.println(con);
	try {
		stmt = con.createStatement();
	} catch (SQLException e2) {
		// TODO Auto-generated catch block
		e2.printStackTrace();
	}
	System.out.print(meeting+"+++++++");
	try {
		rs=stmt.executeQuery("select * from o_personcon where meeting='"+meeting+"'");
	} catch (SQLException e3) {
		// TODO Auto-generated catch block
		e3.printStackTrace();
	}
	
		try {
			if(!rs.next()){
			System.out.println("此名称已存在++++++");
			try {
				request.getRequestDispatcher("/alert1.jsp").forward(request,response);
			} catch (IOException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
			}
			else{
			
			try {
			
				System.out.println(meeting+"meeting");
				stmt.executeUpdate(
					"update O_personcon set meeting='"+meeting+"',recordid='"+recordid+"',empid='"+empid+"' where meeting='"+meeting+"'");
				stmt.executeUpdate(	                     
				    "update O_roomrecord set starttime=to_date('"+starttime+"','yyyy-mm-dd HH24:MI:SS'),recordid='"+recordid+"',endtime=to_date('"+endtime+"','yyyy-mm-dd HH24:MI:SS'),meeting='"+meeting+"' where meeting='"+meeting+"'"); 
				    System.out.println("gai dfsdf");   
				} catch (SQLException e) {
				// TODO Auto-generated catch block
						e.printStackTrace();
				}
			System.out.println(meeting);		
			try {
				request.setAttribute("recordid",recordid);
				request.setAttribute("meeting",meeting);
				request.setAttribute("empid",empid);
				request.setAttribute("starttime",starttime);
				request.setAttribute("endtime",endtime);
				request.getRequestDispatcher("/xghy.jsp").forward(request,response);
			} catch (ServletException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			} catch (IOException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
			
					 }
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ServletException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
}