selectmeetrecord.java

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

                                                                                                                                                                                                                                                                                                                                                                                                 /*
 * Created on 2006-9-27
 *
 * 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 SelectMeetRecord extends HttpServlet {
	
	public void select(HttpServletRequest request,HttpServletResponse response){
	
		
		String  recordid =request.getParameter("recordid");

		System.out.println(recordid+"=======++++====");
		Statement stmt=null;
		Statement stmt1=null;
		Connection con=null;
		ResultSet rs=null;
		ResultSet rs1=null;
		Connection1 conn=new Connection1();
		String meetrecord=null;
		String recordid1=null;
		con=Connection1.getConnection(request,response);
		try {
			stmt=con.createStatement();
			
			stmt1=con.createStatement();
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		try {
				rs1=stmt1.executeQuery("select * from O_joinname where recordid='"+recordid+"'");
			} catch (SQLException e3) {
				// TODO Auto-generated catch block
				e3.printStackTrace();
			}
	
				try {
					if(!rs1.next()){
					System.out.println("没有此编号的记录++++++");
					try {
						request.getRequestDispatcher("/alert7.jsp").forward(request,response);
					} catch (IOException e1) {
						// TODO Auto-generated catch block
						e1.printStackTrace();
						System.out.println("++++++++");
					}
					}
					
				else{
		
		try {
			rs=stmt.executeQuery("select * from O_joinname where recordid='"+recordid+"'");
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		
					try {
						while(rs.next()){
						meetrecord=rs.getString("meetrecord");
						recordid1=rs.getString("recordid");
						System.out.println(meetrecord);
						System.out.println(recordid);
						}
					} catch (SQLException e3) {
						// TODO Auto-generated catch block
						e3.printStackTrace();
					}
					try {
								request.setAttribute("recordid",recordid1);
								request.setAttribute("meetrecord",meetrecord);
			
								request.getRequestDispatcher("/jl.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();
			}
		}
	
	}