基于JavaWeb实现的化妆品销售网站源码(课程大作业).zip资源-CSDN文库

共52个文件

java：11个

class：11个

jsp：10个

版权申诉

javaweb

毕业设计

程序设计

化妆品销售网站

201 浏览量 2023-08-21 14:39:16 上传评论收藏 8.99MB ZIP 举报

资源推荐

资源详情

资源评论

收起资源包目录

基于JavaWeb实现的化妆品销售网站源码(课程大作业).zip （52个子文件）

.classpath 612B

.settings

org.eclipse.wst.jsdt.ui.superType.name 6B

org.eclipse.jdt.core.prefs 357B

org.eclipse.core.resources.prefs 76B

.jsdtscope 488B

org.eclipse.wst.common.component 471B

org.eclipse.wst.common.project.facet.core.xml 245B

org.eclipse.wst.jsdt.ui.superType.container 49B

.mymetadata 308B

src

mybean

data

DataByPage.java 888B

myservlet

control

QueryAllRecord.java 3KB

HandleLogin.java 4KB

HandleRegister.java 4KB

HandleBuyGoods.java 4KB

HandleDelete.java 2KB

PutGoodsToCar.java 3KB

HandleExit.java 980B

SearchByCondition.java 4KB

WebRoot

WEB-INF

classes

mybean

data

DataByPage.class 1KB

myservlet

control

SearchByCondition.class 5KB

HandleBuyGoods.class 5KB

PutGoodsToCar.class 4KB

HandleDelete.class 2KB

HandleRegister.class 4KB

QueryAllRecord.class 3KB

HandleLogin.class 5KB

HandleExit.class 1KB

lib

mysql-connector-java-5.0.8-bin.jar 528KB

web.xml 3KB

index.jsp 428B

lookShoppingCar.jsp 2KB

image

lan2.jpg 132KB

est1.jpg 105KB

back.jpg 1.1MB

login_back.jpg 1.42MB

welcome.jpg 5.09MB

lan1.jpg 681KB

SQLFile

shop.sql 4KB

showDetail.jsp 3KB

lookOrderForm.jsp 2KB

head.jsp 822B

byPageShow.jsp 5KB

lookCosmetic.jsp 1KB

searchCosmetic.jsp 1KB

inputRegisterMess.jsp 2KB

META-INF

MANIFEST.MF 36B

.project 2KB

package myservlet.control; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import javax.servlet.ServletConfig; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import mybean.data.DataByPage; import sun.print.resources.serviceui; import com.sun.rowset.CachedRowSetImpl; /** * 功能：查询化妆品 */ public class SearchByCondition extends HttpServlet { CachedRowSetImpl rowSet=null; public void init(ServletConfig config) throws ServletException { super.init(config); try{ Class.forName("com.mysql.jdbc.Driver"); }catch(Exception e){} } public void destroy() { super.destroy(); } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("utf-8"); String searchMess=request.getParameter("searchMess"); String radioMess=request.getParameter("radio"); if(searchMess==null||searchMess.length()==0){ fail(request,response,"没有查询信息，无法查询"); return; } String condition=""; if(radioMess.equals("cosmetic_number")){ condition="select * from cosmeticForm where cosmetic_number='"+searchMess+"'"; }else if(radioMess.equals("cosmetic_name")){ condition="select * from cosmeticForm where cosmetic_name like '%"+searchMess+"%'"; }else if(radioMess.equals("cosmetic_price")){ double max=0,min=0; String regex="[^0123456789.]"; String[] priceMess=searchMess.split(regex); if(priceMess.length==1){ max=min=Double.parseDouble(priceMess[0]); }else if(priceMess.length==2){ min=Double.parseDouble(priceMess[0]); max=Double.parseDouble(priceMess[1]); if(max<min){ double t=max; max=min; min=t; } }else{ fail(request,response,"输入的价格格式有错误"); return; } condition="select * from cosmeticForm where"+"cosmetic_price<="+max+"and cosmetic_price>="+min; } HttpSession session=request.getSession(true); Connection con=null; DataByPage dataBean=null; try{ dataBean=(DataByPage) session.getAttribute("dataBean"); if(dataBean==null){ dataBean=new DataByPage(); session.setAttribute("dataBean", dataBean); } }catch(Exception e){ dataBean=new DataByPage(); session.setAttribute("dataBean", dataBean); } String uri="jdbc:mysql://127.0.0.1/shop?"+"user=root&password=dpl1215&characterEncoding=utf-8"; try{ con=DriverManager.getConnection(uri); Statement sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); ResultSet rs=sql.executeQuery(condition); rowSet=new CachedRowSetImpl();//创建行集对象 rowSet.populate(rs);//填充结果集 dataBean.setRowSet(rowSet);//行集数据存储在dataBean中 con.close(); }catch(Exception e){} response.sendRedirect("byPageShow.jsp"); } private void fail(HttpServletRequest request, HttpServletResponse response, String backNews) { response.setContentType("text/html;charset=utf-8"); try{ PrintWriter out=response.getWriter(); out.println("<html><body background='image/back.jpg' style='color:white'>"); out.println("<h2>"+backNews+"</h2>"); out.println("返回："); out.println("<a href='searchCosmetic.jsp'>查询化妆品</a>"); out.println("</body></html>"); }catch(Exception e){} } }

评论收藏

内容反馈

版权申诉