servlet1.java~2~

宠物医院

package servlet;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.PreparedStatement;
import bean.JDBCBean;
import java.sql.ResultSet;
import java.sql.Connection;

public class Servlet1
    extends HttpServlet {
  private static final String CONTENT_TYPE = "text/html; charset=GBK";

  //Initialize global variables
  public void init() throws ServletException {
  }

  //Process the HTTP Get request
  public void doGet(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    response.setContentType(CONTENT_TYPE);
    PrintWriter out = response.getWriter();
    JDBCBean jdbc=new JDBCBean();
   Connection con=jdbc.getCon();
   PreparedStatement pstm=null;
   ResultSet rs=null;
   Vector vc=new Vector();
  String sql;
try
  {
    sql="insert into vets (name) values (?)";
    pstm=con.prepareStatement(sql);
  }
  catch(Exception e)
  {
    e.printStackTrace();
  }

  }

  //Process the HTTP Post request
  public void doPost(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    doGet(request, response);
  }

  //Clean up resources
  public void destroy() {
  }
}