getuserinfoservlet.java

《j2ee应用开发祥解》一书的源代码

package com.j2ee14.ch8;

import javax.servlet.http.*;
import javax.servlet.*;
import java.io.*;
import java.sql.*;
/**
 *演示Servlet查询数据库操作
 */
public class GetUserInfoServlet  extends com.j2ee14.ch8.DatabaseServletBase
{
	/**
	 *处理Get请求
	 *获得初始参数-->把数据保存到数据库-->显示保存成功的信息
	 */
	public void doGet(HttpServletRequest request,HttpServletResponse response)
		throws javax.servlet.ServletException,java.io.IOException
	{
	    response.setContentType("text/html;charset=gb2312");
	    PrintWriter out = response.getWriter();
	    String userName=(String)request.getParameter("userName");
	    try
	    {
	        //创建执行语句，执行数据库操作
	    	Statement stmt=con.createStatement();
			ResultSet rst=stmt.executeQuery("select * from userregist where userName='"+userName+"'");
			if(rst.next())
			{
				out.println("<br>userName:"+userName);
				out.println("<br>age:"+rst.getInt("age"));
				out.println("<br>language:"+rst.getString("language"));
				out.println("<br>爱好:"+rst.getString("fav"));
			}
			else
			out.println("没有这个用户");
			rst.close();
			stmt.close();
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
	}
    /**
     *处理post请求
     */
    public void doPost(HttpServletRequest request,HttpServletResponse response)
		throws javax.servlet.ServletException,java.io.IOException
	{
		doGet(request,response);
	}	
}