contactservlet.java

ＳＴＲＵＴＳ眶架下做的一个商品管理小例子源码 解压后直接到入ＭＹＥＣＬＩＰＳＥ里就可以 看 请战长快一点审核我的代码 我现在正在学习ＢＲＥＷ手机 开发急需质料

package com.jspdev.ch12;

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

public class ContactServlet extends HttpServlet
{

    Connection con;
	public void doGet(HttpServletRequest request,
                      HttpServletResponse response)
        throws IOException, ServletException
    {
       request.setCharacterEncoding("gb2312");
        response.setContentType("text/html;charset=gb2312");
        PrintWriter out = response.getWriter();
        String action=(String)request.getParameter("action");
        String userName=(String)request.getParameter("userName");
        if(action.equals("delete"))
        {
        	try
        	{
        		deleteContact(userName);
        		out.println("成功删除！"+userName);
        	}
        	catch(Exception e)
        	{
        		out.println("删除失败或者没有这个信息:"+userName);
        	}
        	
        }
        else
        {
        	ResultSet rst=getContact(userName);
        	out.println("<table border=1><tr><td>姓名</td><td>手机</td><td>电话</td><td>email</td><td>最后的联系时间</td><td>备注</td></tr>");
        	try
        	{
        		while(rst.next())
	            {
			        out.println("<tr>");
				    out.println("<td>"+rst.getString("userName")+"</td>");
				    out.println("<td>"+rst.getInt("mobile")+"</td>");
				    out.println("<td>"+rst.getString("phone")+"</td>");
				    out.println("<td>"+rst.getString("mail")+"</td>");
				    out.println("<td>"+rst.getDate("lastcontact")+"</td>");
				    out.println("<td>"+rst.getString("mem")+"</td>");
				    out.println("</tr>");
				 }
				 out.println("</table>");
				 rst.close();
		    }
		    catch(Exception e)
		    {
		    }
		
        }        
       
	}
	public void doPost(HttpServletRequest request,
	                      HttpServletResponse response)
	        throws IOException, ServletException
	 {
	    	doGet(request,response);
	}
	
	//创建一个Connection对象，用于执行数据库操作。    
    public   ContactServlet()
    {
    	String CLASSFORNAME="sun.jdbc.odbc.JdbcOdbcDriver";
	    String SERVANDDB="jdbc:odbc:ssdb";
	    try
	    {
	    	
	    	Class.forName(CLASSFORNAME);
			con = DriverManager.getConnection(SERVANDDB);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	
		//在数据库中添加信息
	public void deleteContact(String userName)throws Exception
	{
		try
		{
		    Statement stmt=con.createStatement();
		    stmt.execute("delete from contact where userName='"+userName+"'");
		    stmt.close();	
		}
		catch(Exception e)
		{
			e.printStackTrace();
			throw e;
		}
	}
	//查询数据库
	public  ResultSet getContact(String userName)
	{
		try
		{
			Statement stm=con.createStatement();
			ResultSet result=stm.executeQuery("select * from contact where userName='"+userName+"'");
			return result;
		}
		catch(Exception e)
		{
		}
		return null;
	}	
	
}