cpuservlet.java

来自「一个AJax的过滤效果 淡入和淡出 不影响整体的美观 很实用 适合新人」· Java 代码 · 共 85 行

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
import java.util.*;
import javax.naming.*;
import javax.sql.*;


public class CpuServlet extends HttpServlet
{
	public  void doGet(HttpServletRequest req,
                     HttpServletResponse resp)
              throws ServletException,
                     java.io.IOException
    {
    	this.doPost(req,resp);
    }
    
	public  void doPost(HttpServletRequest req,
                     HttpServletResponse resp)
              throws ServletException,
                     java.io.IOException
    { 	
    	
      try
      {
   	    String id=req.getParameter("id");
   	    st.setString(1,id.trim());
   	    ResultSet rs=st.executeQuery();
   	        	
    	if(rs.next())
    	{
	    	resp.setContentType("application/xml");
	        resp.setCharacterEncoding("GBK");        
	        
	    	PrintWriter out=resp.getWriter();    	
	    	StringBuilder result=new StringBuilder();
	    	result.append("<?xml version=\"1.0\" encoding=\"gbk\" ?>");
	    	result.append("<dcinfo>");
	    	result.append("<id>"+rs.getString(6)+"</id>");
	    	result.append("<name>"+new String(rs.getString(1).getBytes("ISO-8859-1"),"GBK")+"</name>");
	    	result.append("<price>"+rs.getString(2)+"</price>");
	    	
	    	result.append("<parameterlist>");
	    	String parameter=new String(rs.getString(3).getBytes("ISO-8859-1"),"GBK");
	    	String[] pa=parameter.split("\\|");
	    	for(String temps:pa)
	    	{
	    		result.append("<parameter>"+temps+"</parameter>");
	    	}
	    	result.append("</parameterlist>");
	    	
	    	result.append("<imgpre>"+rs.getString(4)+"</imgpre>");
	    	result.append("<imgcount>"+rs.getString(5)+"</imgcount>");
	    	result.append("</dcinfo>");
	    	
	    	out.println(result);   		
    	}         	
      }
      catch(Exception e)
      {
      	e.printStackTrace();
      }
    }   
    
    private PreparedStatement st;
    public void init()
    {
    	try
    	{
    	  Context initial = new InitialContext();    
     	  DataSource ds = (DataSource)initial.lookup("java:comp/env/jdbc/cpuds");
          Connection con=ds.getConnection();
          st=con.prepareStatement("select name,price,parameter,imgpre,imgcount,id from dcinfo where id=?");    		
    	}
    	catch(Exception e)
    	{
    		e.printStackTrace();
    	}

    }    

	
}