deletemeeting.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 DeleteMeeting {
	public void delete(HttpServletRequest request,HttpServletResponse response){
		String recordid=request.getParameter("recordid1");
		System.out.println(recordid);
		Connection con=null;
		Statement stmt = null;
		ResultSet rs=null;
		
	try {
		Connection1 conn=new Connection1();
		con=Connection1.getConnection(request,response);
		System.out.println("lily ++-----");
			System.out.println(con);
	    stmt = con.createStatement();		
		} catch (SQLException e) {
	// TODO Auto-generated catch block
		e.printStackTrace();
		}
	System.out.println(recordid);
	try {
			rs=stmt.executeQuery("select * from o_personcon where recordid='"+recordid+"'");
		} catch (SQLException e3) {
			// TODO Auto-generated catch block
			e3.printStackTrace();
		}
	
			try {
				if(!rs.next()){
				System.out.println("没有此次会议++++++");
				try {
					request.getRequestDispatcher("/alert7.jsp").forward(request,response);
				} catch (IOException e1) {
					// TODO Auto-generated catch block
					e1.printStackTrace();
				}
				}
				else{
	try {
		stmt.executeUpdate(" delete from O_personcon where recordid like'"+recordid+"'");
		stmt.executeUpdate(" delete from O_roomrecord where recordid like'"+recordid+"'");
		stmt.executeUpdate(" delete from O_joinname where recordid like'"+recordid+"'");
		} catch (SQLException e3) {
		// TODO Auto-generated catch block
		e3.printStackTrace();
		}
		try {
		request.setAttribute("recordid",recordid);
		request.getRequestDispatcher("/scxx.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();
		}
	}
	
}