本文实例为大家分享了javaweb实现简单查询商品功能的具体代码，供大家参考，具体内容如下
customerservlet.java
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
|
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 = "<h1>欢迎进入管理页面</h1><form action='customerservlet' method='post'> "
+ "精确查询:<input type='text' name='jqmess'/><br>"
+ "模糊查询:<input type='text' name='mhmess'/><br>"
+ "<input type='submit' value='提交' name='sub'/>"
+ "</form>";
// 登录的时候进行验证
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("<h1>登录失败！</h2>2秒自动跳转到登录页面!");
response.setheader("refresh", "2;url=login.html");
}
} catch (exception e) {
e.printstacktrace();
}
} else {
pw.println("<h1>登录失败！</h2>5秒自动跳转到登录页面!");
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 = "<table border='5'>" + "<tr>" + "<th>id号码</th>"
+ "<th>商品名称</th>" + "<th>商品价格</th>"
+ "<th>商品库存数量</th>" + "<th>商品描述</th>";
string main = "<tr>" + "<td>" + mess[0] + "</td>" + "<td>"
+ mess[1] + "</td>" + "<td>" + mess[2] + "</td>"
+ "<td>" + mess[3] + "</td>" + "<td>" + mess[4]
+ "</td></tr></table>";
string head = html + main;
pw.println(head);
} catch (exception e) {
e.printstacktrace();
}
} else if (mhmess != null && mhmess.length() > 0) {
try {
string head = "";
string html = "<table border='5'>" + "<tr>" + "<th>id号码</th>"
+ "<th>商品名称</th>" + "<th>商品价格</th>"
+ "<th>商品库存数量</th>" + "<th>商品描述</th>";
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 = "<tr>" + "<td>" + mess[0] + "</td>"
+ "<td>" + mess[1] + "</td>" + "<td>" + mess[2]
+ "</td>" + "<td>" + mess[3] + "</td>" + "<td>"
+ mess[4] + "</td></tr>";
head += main;
}
head += "</table>";
pw.println(head);
} catch (exception e) {
e.printstacktrace();
}
}
}
}
}
|
数据库访问类：
sqldemo.java
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
|
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
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
<!doctype html public "-//w3c//dtd html 4.01 transitional//en" "http://www.w3.org/tr/html4/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<title>insert title here</title>
</head>
<body>
<h1>登录</h1>
<form action="customerservlet" method="post">
账号:<input type="text" name="admin_id"/>
密码:<input type="password" name="password"/>
<input type="submit" value="登录" name="login"/>
</form>
</body>
</html>
|
数据库里面的表数据
运行效果
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持服务器之家。
原文链接：https://blog.csdn.net/ACM_TH/article/details/50066287