1、javaweb_JavaWeb實現(xiàn)簡單查詢商品功能本實例為家分享了javaweb實現(xiàn)簡單查詢商品功能的具體代碼，供家參考，具體內容如下customerservlet.javapackage 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.serv

2、let.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 = 歡迎進管理頁+ 精確查詢:+ 模糊查詢:+ + ;/ 登錄的時候進驗證privat

3、e 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 httpservl

4、et#doget(httpservletrequest request, httpservletresponse* response)*/protected void doget(httpservletrequest request,httpservletresponse response) throws servletexception, ioexception / todo auto-generated method stubthis.dopost(request, response);/* see httpservlet#dopost(httpservletrequest request

5、, 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.getp

6、arameter(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.pri

7、ntln(登錄失?。?秒動跳轉到登錄頁 !);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 mh

8、mess = request.getparameter(mhmess);if (jqmess != null & jqmess.length() 0) try string s = sql.getjqmess(jqmess);string mess = s.split(,);string html= id號碼+ 商品名稱+ 商品價格+ 商品庫存數量+ 商品描述;string main = + + mess0 + + + mess1 + + + mess2 + + + mess3 + + + mess4+ ;string head = html+ main;pw.println(head); c

9、atch (exception e) e.printstacktrace(); else if (mhmess != null & mhmess.length() 0) try string head = ;string html= id號碼+ 商品名稱+ 商品價格+ 商品庫存數量+ 商品描述;head += html;string s = sql.getmhmess(mhmess);string m = s.split(,);for (int i = 0;i m.length; i+) string mess = mi.split(,);string main = + + mess0 + +

10、 + mess1 + + + mess2+ + + mess3 + + + mess4 + ;head += main;head += ;pw.println(head); catch (exception e) e.printstacktrace();數據庫訪問類：sqldemo.javapackage com.subing.web;import java.sql.connection;import java.sql.drivermanager;import java.sql.preparedstatement;import java.sql.resultset;public class s

11、qldemo 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&characterenco

12、ding=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 =

13、 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

14、 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.se

15、tstring(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 = r

16、s.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_numlike

17、 ?+ 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 stati