JavaWeb实现简单查询商品功能

JavaWeb实现简单查询商品功能

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

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("gb2312");

PrintWriter pw = response.getWriter();

String sub = request.getParameter("sub");

String login = request.getParameter("login");

if (login != null && login.length() > 0) {

String admin_id = request.getParameter("admin_id");

String password = request.getParameter("password");

if (isLoginProv(admin_id, password)) {

try {

if (sql.loginVerify(admin_id, password)) {

pw.println(s1);

} else {

pw.println("

response.setHeader("refresh", "2;url=login.html");

}

} catch (Exception e) {

e.printStackTrace();

}

} else {

pw.println("

response.setHeader("refresh", "5;url=login.html");

}

} else if (sub != null && sub.length() > 0) {

pw.println(s1);

String jqmess = request.getParameter("jqmess");

String mhmess = request.getParameter("mhmess");

if (jqmess != null && jqmess.length() > 0) {

try {

String s = sql.getJqMess(jqmess);

String mess[] = s.split(",");

String html = "

+ "

+ "

String main = "

+ mess[1] + "

+ "

+ "

String head = html + main;

pw.println(head);

} catch (Exception e) {

e.printStackTrace();

}

} else if (mhmess != null && mhmess.length() > 0) {

try {

String head = "";

String html = "

+ "

+ "

head += html;

String s = sql.getMhMess(mhmess);

String m[] = s.split(",,");

for (int i = 0; i < m.length; i++) {

String mess[] = m[i].split(",");

String main = "

+ "

+ "

+ mess[4] + "

head += main;

}

head += "

pw.println(head);

} catch (Exception e) {

e.printStackTrace();

}

}

}

}

}

数据库访问类：

SqlDemo.java

package com.subing.web;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

public class SqlDemo {

private Connection conn = null;

private PreparedStatement preparedStatement = null;

public SqlDemo() throws Exception {

conn = getConnection();

}

private Connection getConnection() throws Exception {

String driverClass = "com.mysql.jdbc.Driver";

String url = "jdbc:mysql:///shop?useUnicode=true&characterEncoding=gb2312";

String user = "root";

String password = "12345";

// 注册加载驱动

Class.forName(driverClass);

// 获取连接

Connection conn = DriverManager.getConnection(url, user, password);

System.out.println(conn);

return conn;

}

// 登录的时候 进行验证

public boolean loginVerify(String userinfo, String password)

throws Exception {

String sql = "select * from admin where admin_id = ?";

preparedStatement = conn.prepareStatement(sql);

preparedStatement.setString(1, userinfo);

ResultSet rs = preparedStatement.executeQuery();

if (rs.next()) {

if (rs.getString("password").equals(password)) {

System.out.println("成功！");

return true;

}

}

System.out.println("失败！");

return false;

}

public String getJqMess(String admin_id) throws Exception {

String s = "";

String sql = "select * from product1 where product_id = ? OR product_name LIKE ?"

+ "OR product_price LIKE ?"

+ "OR product_num LIKE ?"

+ "OR product_describe LIKE ?";

preparedStatement = conn.prepareStatement(sql);

preparedStatement.setString(1, admin_id);

preparedStatement.setString(2, admin_id);

preparedStatement.setString(3, admin_id);

preparedStatement.setString(4, admin_id);

preparedStatement.setString(5, admin_id);

//查询到记录的时候，返回一个resultSet，也处理了该方法查找失败的时候返回null的情况

ResultSet rs = preparedStatement.executeQuery();

while (rs.next()) {

s = rs.getInt(1) + "," + rs.getString(2) + "," + rs.getInt(3) + ","

+ rs.getInt(4) + "," + rs.getString(5);

}

return s;

}

public String getMhMess(String admin_id) throws Exception {

String mess = "";

String sql = "select * from product1 where product_id like ? OR product_name LIKE ? OR product_price LIKE ? OR product_num LIKE ?"

+ "OR product_describe LIKE ?";

preparedStatement = conn.prepareStatement(sql);

preparedStatement.setString(1, "%" + admin_id + "%");

preparedStatement.setString(2, "%" + admin_id + "%");

preparedStatement.setString(3, "%" + admin_id + "%");

preparedStatement.setString(4, "%" + admin_id + "%");

preparedStatement.setString(5, "%" + admin_id + "%");

ResultSet rs = preparedStatement.executeQuery();

while (rs.next()) {

String s = rs.getInt(1) + "," + rs.getString(2) + ","

+ rs.getInt(3) + "," + rs.getInt(4) + "," + rs.getString(5);

mess += s + ",,";

}

return mess;

}

public static void main(String[] args) throws Exception {

SqlDemo sqlDemo = new SqlDemo();

String s = sqlDemo.getMhMess("xi");

String m[] = s.split(",,");

for (int i = 0; i < m.length; i++) {

System.out.println(m[i]);

}

}

}

html文件：

login.html

账号:

密码:

数据库里面的表数据

运行效果

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。