contactservlet.java

基于WEB的商品管理系统

/*
 * ContactServlet.java
 *
 * Created on 2007年10月25日, 下午3:29
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package org.me.product;

import javax.servlet.*;
import javax.servlet.http.*;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.sql.*;
import java.util.*;
import java.io.*;

/**
 *
 * @author Administrator
 */
    public class ContactServlet {
    
    /** Creates a new instance of ContactServlet */
        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="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	    String SERVANDDB="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jspdev";
	    String USER="bn";
	    String PWD="bn"; 
	    try
	    {
	    	
	    	Class.forName(CLASSFORNAME);
		con = DriverManager.getConnection(SERVANDDB,USER,PWD);
            }
            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;
	}	
    
}