java 查询_JavaWeb实现简单查询商品功能

本文实例为大家分享了JavaWeb实现简单查询商品功能的具体代码，供大家参考，具体内容如下

CustomerServlet.java

package com.subing.web;

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

@WebServlet("/CustomerServlet")

public class CustomerServlet extends HttpServlet {

private static final long serialVersionUID = 1L;

private SqlDemo sql = null;

private final static String s1 = "

欢迎进入管理页面

"

+ "精确查询:
"

+ "模糊查询:
"

+ ""

+ "

";

// 登录的时候进行验证

private boolean isLoginProv(String userinfo, String password) {

if (userinfo != null && userinfo.length() > 0 && password != null

&& password.length() > 0) {

return true;

}

return false;

}

public CustomerServlet() throws Exception {

super();

sql = new SqlDemo(); // 进行数据库访问的类

// TODO Auto-generated constructor stub

}

/**

* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse

* response)

*/

protected void doGet(HttpServletRequest request,

HttpServletResponse response) throws ServletException, IOException {

// TODO Auto-generated method stub

this.doPost(request, response);

}

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse

* response)

*/

protected void doPost(HttpServletRequest request,

HttpServletResponse response) throws ServletException, IOException {

response.setContentType("text/html;charset=gb2312");

request.setCharacterEncoding("