refermeetrecord.java

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

/*
 * Created on 2006-9-26
 *
 * 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.HttpServlet;
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 ReferMeetRecord extends HttpServlet {
	public void refer(HttpServletRequest request,HttpServletResponse response){
		 System.out.println("refer");
		 String meetrecord=null;
		 String recordid=null;
	     Statement stmt=null;
	     Connection con=null;
		 ResultSet rs=null;
		 meetrecord=request.getParameter("meetrecord");
		 recordid =request.getParameter("recordid");
		 System.out.println(meetrecord+"++++");
		 System.out.println(recordid+"++hao++");
	     Connection1 conn=new Connection1();
	     con=Connection1.getConnection(request,response);
	     try {
			stmt=con.createStatement();
		     } catch (SQLException e) {
			// TODO Auto-generated catch block
		  	e.printStackTrace();
		     }
        System.out.println(meetrecord+"jkkkk");
		try {
			rs=stmt.executeQuery("select * from O_joinname where recordid='"+recordid+"'");
		    } catch (SQLException e3) {
			// TODO Auto-generated catch block
			e3.printStackTrace();
		    }
	
		try {
			if(rs.next()){
			System.out.println("此编号已占用++++++");
			try {
				request.getRequestDispatcher("/alert8.jsp").forward(request,response);
			} catch (IOException e1) {
				// TODO Auto-generated catch block
				e1.printStackTrace();
			}
			}
			else{
				try {
						stmt.executeUpdate("insert into O_joinname values('"+recordid+"','"+meetrecord+"')");
				} catch (SQLException e) {
			// TODO Auto-generated catch block
					e.printStackTrace();
			}
					
						
			    try {
			    	request.setAttribute("recordid",recordid);
			    	request.setAttribute("meetrecord",meetrecord);
					request.getRequestDispatcher("/tijiao.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();
		}
	}
	
}