将jsp当成servlet服务示例

sqlDataQuery.jsp页面代码如下

<%@ page language="java" import="java.util.*,java.text.SimpleDateFormat,java.util.Date,net.sf.json.JSONArray,net.sf.json.JSONObject,java.net.URLEncoder" pageEncoding="UTF-8" contentType="text/html"%>
<%@page import="java.sql.*,java.io.PrintWriter"%>
<%
    response.setContentType("text/html;charSet=UTF-8");
	request.setCharacterEncoding("UTF-8");
	String id ="";
	String dbID="";
	String secondID="";
	String dbID2="";
	if(request.getParameter("id")!=null){
		id = new String(request.getParameter("id").getBytes("ISO8859-1"), "utf-8");
	}
	if(request.getParameter("dbID")!=null){
		dbID=new String(request.getParameter("dbID").getBytes("ISO8859-1"), "utf-8");
	}
	if(request.getParameter("secondID")!=null){
		secondID=new String(request.getParameter("secondID").getBytes("ISO8859-1"), "utf-8");
	}
	
	if(request.getParameter("dbID2")!=null){
		dbID2=new String(request.getParameter("dbID2").getBytes("ISO8859-1"), "utf-8");
	}
	
	
	System.out.println("id======//======" + id);
	System.out.println("dbID======//======" + dbID);
	

	StringBuffer uiStr = new StringBuffer();//返回结果字符串

	ResultSet rs = null;
	Connection conn = null;
	PreparedStatement pstmt = null;

	String sql = "";//查询语句
	if(dbID.equals("0")){
		sql="select id,db_cnname from  DBSOURCE_LIST ";
	}else if (id.equals("0")) {
		sql = "select firstname from  DBSQL_LIST  group by firstname";
	}else if(id!=null&&!id.equals("0")&&!id.equals("")){
		sql="select secondid,secondname,sql_data from DBSQL_LIST t where firstname='"+id+"'";
	}else if(secondID!=null&&!secondID.equals("0")&&!secondID.equals("")){//前台ajax请求
		sql="select sql_data from DBSQL_LIST  where secondid='"+secondID+"'";
	}else if(dbID2!=null&&!dbID2.equals("")){
		sql="select t.db_ip,t.db_port,t.db_name,t.db_pwd,t.db_servicename,t.db_cnname from  DBSOURCE_LIST t where t.id='"+dbID2+"'";
	}

	System.out.println("sql语句======//======" + sql);
	try {
		Class.forName("oracle.jdbc.OracleDriver");
		conn = DriverManager.getConnection("jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=yes)(FAILOVER=ON)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ars)(SERVER=DEDICATED)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=10)(DELAY=5))))", "usddev","usddev");		

		 pstmt = conn.prepareStatement(sql);
		 rs=pstmt.executeQuery();
		 uiStr.append("[");
		 while(rs.next()){
			 String firstname="";
			 String secondname="";
			 String secondid="";
			 String sql_data="";
			 String db_cnname="";
			 if(dbID.equals("0")){
				 db_cnname=rs.getString(2);
				 uiStr.append("{\"id\":\""+rs.getString(1)+"\",\"text\":\""+db_cnname+"\"}");
			 }else if(id.equals("0")){
				 firstname=rs.getString(1);
				 uiStr.append("{\"id\":\""+firstname+"\",\"text\":\""+firstname+"\",\"state\":\"closed\"}");
			 }else if(id!=null&&!id.equals("0")&&!id.equals("")){
				 secondid=rs.getString(1);
				 secondname=rs.getString(2);
				 uiStr.append("{\"id\":\""+secondid+"\",\"text\":\""+secondname+"\"}");
			 }else if(secondID!=null&&!secondID.equals("0")&&!secondID.equals("")){
				 sql_data=rs.getString(1);
				 PrintWriter ou = response.getWriter(); //为ajax返回数据
				 ou.print(sql_data);
				 ou.flush();
				 ou.close();
			 }else if(dbID2!=null&&!dbID2.equals("")){
				 String hostip=rs.getString(1);
				 String db_port=rs.getString(2);
				 String db_name=rs.getString(3);
				 String db_pwd=rs.getString(4);
				 String db_servicename=rs.getString(5);
				 String dbcnname=rs.getString(6);
				 
				 String datas="hostip="+hostip+"&db_port="+db_port+"&db_name="+db_name+"&db_pwd="+db_pwd+"&db_servicename="+db_servicename+"&dbcnname="+dbcnname;
				 PrintWriter ou = response.getWriter(); //为ajax返回数据
				 ou.print(datas);
				 ou.flush();
				 ou.close();
				 
			 }
			 
			 uiStr.append(",");
		 }
		 String ch="";
		 ch=String.valueOf(uiStr.charAt(uiStr.length()-1));
		 if(ch.equals(",")){
			 uiStr.delete(uiStr.length()-1,uiStr.length());//除去最后一个“,”
	         }
		 
		 uiStr.append("]");
		 
		 response.getWriter().write(uiStr.toString());//返回结果
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		 rs.close();
		 pstmt.close();
		 conn.close();
	}
%>