/*
* Generated by MyEclipse Struts
* Template path: templates/java/JavaClass.vtl
*/
package com.accp.struts.action;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.DispatchAction;
import org.apache.struts.upload.FormFile;
import com.accp.struts.Bean.DBConnection;
import com.accp.struts.form.ProductForm;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.OutputStream;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.Calendar;
public class ProductAction extends DispatchAction {
// 增加商品
public ActionForward addProduct(ActionMapping actionMapping,
ActionForm actionForm,
HttpServletRequest request,
HttpServletResponse response) {
ProductForm f = (ProductForm) actionForm;
ActionForward forward = new ActionForward();
//取得checkbox表单数据
// String productAddress = "";
// for(int i=0;i<agentProductForm.getProductAddress().length;i++){
// if(productAddress.equals("")){
// productAddress = agentProductForm.getProductAddress()[i] ;
// }
// else{
// productAddress =productAddress + "," + agentProductForm.getProductAddress()[i] ;
// }
// }
// System.out.println("productAddress:"+productAddress);
System.out.println("1");
//取得时间
Calendar applyDate = Calendar.getInstance();
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
String applyTime = sdf.format(applyDate.getTime());
//定义数据对象
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
/*
//保存文件到相应的目录
FormFile uploadFile = null;//定义图片文件
uploadFile = ProductForm.getUploadFile();//取得图片文件
String fileName = uploadFile.getFileName();//取得图片文件名称
//相片保存地址
String dir = servlet.getServletContext().getRealPath("/images/UserPic/");
//上传图片到相应的目录
String fileName_path = dir + "\\" + fileName;
InputStream streamIn_one = uploadFile.getInputStream();
OutputStream streamOut_one = new FileOutputStream(fileName_path);
int bytesRead1 = 0;
byte[] buffer1 = new byte[8192];
while ( (bytesRead1 = streamIn_one.read(buffer1, 0, 8192)) != -1) {
streamOut_one.write(buffer1, 0, bytesRead1);
}
streamOut_one.close();
streamIn_one.close();
System.out.println("2");
//取得最大商品ID值
int productId = 0;
conn = DBConnection.getConnection();
String sql = "select max(product_id) from product ";
System.out.println("sql:"+sql);
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
if (rs.next()) {
productId = rs.getInt(1)+1;
}
*/
System.out.println("3");
conn=DBConnection.getConnection();
//增加商品
String sql = "insert into producttable1 values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1,Integer.parseInt(f.getProduct_id()));
pstmt.setString(2, f.getProduct_name());
pstmt.setString(3, f.getNew_level());
pstmt.setFloat(4, Float.parseFloat(f.getPrice()));
pstmt.setString(5, f.getStart_date());
pstmt.setString(6, f.getEnd_date());
pstmt.setString(7, "A0");
pstmt.setString(8, f.getDescription());
pstmt.setString(9, f.getAddress_picture());
pstmt.setInt(10, Integer.parseInt(f.getStore_number()));
pstmt.setString(11, f.getShow_main());
pstmt.setString(12, f.getShow_command());
pstmt.setString(13, f.getAddress());
pstmt.setString(14, f.getMeno());
pstmt.setString(15, f.getCreate_time());
int result = pstmt.executeUpdate();
if (result > 0) {
forward = actionMapping.findForward("success");
} else {
forward = actionMapping.findForward("error");
}
} catch (Exception e) {
e.printStackTrace();
forward = actionMapping.findForward("error");
} finally {
try{
if(rs!=null)rs.close();
if(pstmt!=null)pstmt.close();
}catch(Exception ex){
System.out.println(ex);
}
}
System.out.println("forward:" + forward);
return forward;
}
//商品下架
public ActionForward updateStateProduct(ActionMapping actionMapping,
ActionForm actionForm,
HttpServletRequest request,
HttpServletResponse response) {
ProductForm agentProductForm = (ProductForm) actionForm;
ActionForward forward = new ActionForward();
//定义数据对象
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try{
//修改商品
conn = DBConnection.getConnection();
String sql = "update producttable1 set state=A2 where product_id =?";
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1,Integer.parseInt(agentProductForm.getProduct_id()));
int result = pstmt.executeUpdate();
if(result > 0){
forward = actionMapping.findForward("modifyProductSuccess");
}
else{
forward = actionMapping.findForward("failure");
}
}
catch(Exception e){
e.printStackTrace();
}
finally{
try{
if(rs!=null)rs.close();
if(pstmt!=null)pstmt.close();
}catch(SQLException ex){
System.out.println(ex);
}
}
System.out.println("forward:"+forward);
return forward;
}
/**
* 修改商品信息
* @param actionMapping ActionMapping
* @param actionForm ActionForm
* @param request HttpServletRequest
* @param response HttpServletResponse
* @return ActionForward
*/
public ActionForward modifyProduct(ActionMapping actionMapping,
ActionForm actionForm,
HttpServletRequest request,
HttpServletResponse response) {
ProductForm f = (ProductForm) actionForm;
ActionForward forward = new ActionForward();
//取得时间
Calendar applyDate = Calendar.getInstance();
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
String applyTime = sdf.format(applyDate.getTime());
//定义数据对象
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String productId = request.getParameter("product_id");//取得主键值
System.out.println("主见只为:"+productId);
try{
/*
//保存文件到相应的目录
FormFile uploadFile = null;//定义图片文件
uploadFile = f.getUploadFile();//取得图片文件
String fileName = uploadFile.getFileName();//取得图片文件名称
//相片保存地址
String dir = servlet.getServletContext().getRealPath("/images/UserPic
没有合适的资源?快使用搜索试试~ 我知道了~
Sturts-Product.rar_Eclipse_eclipse jsp_java 酒店管理系统_struts java_
共127个文件
gif:40个
jsp:22个
java:13个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 49 浏览量
2022-09-20
14:33:52
上传
评论 1
收藏 2.76MB RAR 举报
温馨提示
商品管理系统,采用jsp+struts框架开发,用eclipse工具开发!
资源推荐
资源详情
资源评论
收起资源包目录
Sturts-Product.rar_Eclipse_eclipse jsp_java 酒店管理系统_struts java_ (127个子文件)
ProductAction.class 8KB
SelectProAction.class 5KB
SelectProductAction.class 4KB
ProductForm.class 4KB
ShenHeAction.class 4KB
User.class 4KB
ShenheDownAction.class 4KB
UserBean.class 4KB
SelectUserAction.class 2KB
UserLogoAction.class 2KB
UserLogoForm.class 2KB
DBConnection.class 1KB
MyProcessor.class 894B
.classpath 1KB
silverStyle.css 3KB
css.css 1KB
Thumbs.db 67KB
Thumbs.db 9KB
42.gif 132KB
04.gif 118KB
35.gif 53KB
75.gif 41KB
08.gif 40KB
qq.gif 39KB
60.gif 23KB
53.gif 22KB
78.gif 19KB
qq1.gif 11KB
touradmin1.gif 4KB
aaa_a2.gif 4KB
aaa_a1.gif 3KB
aaa_a3.gif 3KB
TitlebarRight_Head.gif 2KB
TitlebarRight.gif 1KB
aaa_1.gif 1KB
rar.gif 1005B
delete.gif 908B
TitlebarMiddle_Head.gif 667B
update.gif 660B
icon_host.gif 636B
TitlebarMiddle.gif 630B
mslogo.gif 628B
list.gif 623B
bg.gif 425B
xx.gif 399B
BD14581_.gif 397B
qc.gif 396B
icon_mailbody.gif 365B
edit.gif 352B
friends.gif 320B
copy.gif 239B
aaa_r4.gif 183B
api.gif 169B
demo.gif 127B
TitlebarLeft_Head.gif 125B
folderstate2.gif 124B
dload.gif 102B
TitlebarLeft.gif 99B
struts.jar 531KB
antlr.jar 350KB
msbase.jar 278KB
commons-beanutils.jar 184KB
commons-digester.jar 164KB
commons-validator.jar 82KB
msutil.jar 66KB
jakarta-oro.jar 64KB
mssqlserver.jar 63KB
commons-logging.jar 37KB
commons-fileupload.jar 22KB
ProductAction.java 14KB
ProductForm.java 7KB
SelectProAction.java 5KB
User.java 4KB
SelectProductAction.java 4KB
UserBean.java 3KB
ShenHeAction.java 3KB
ShenheDownAction.java 3KB
UserLogoForm.java 2KB
SelectUserAction.java 2KB
UserLogoAction.java 1KB
DBConnection.java 766B
MyProcessor.java 503B
5.jpg 190KB
1.jpg 113KB
plant_04.jpg 96KB
18.JPG 83KB
TaskMenu.js 26KB
index.jsp 4KB
shenheDown.jsp 3KB
shenheUpLoad.jsp 3KB
queryProduct.jsp 3KB
selectProduct.jsp 2KB
updateProduct.jsp 2KB
addProduct.jsp 2KB
TaskMenu.jsp 2KB
selectPro.jsp 2KB
deleteUser.jsp 1KB
addUser.jsp 1KB
updateUser.jsp 1KB
updatePasswrod.jsp 1KB
共 127 条
- 1
- 2
资源评论
我虽横行却不霸道
- 粉丝: 72
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- 基于matlab实现夜间车牌识别程序(1).rar
- 基于matlab实现图像处理,本程序使用背景差分法对来往车辆进行检测和跟踪.rar
- 基于matlab实现视频监控中车型识别代码,自己写的,希望和大家多多交流.rar
- sdk.config
- 基于matlab实现配电网三相潮流计算方法,对几种常用的配电网潮流计算方法进行了对比分析.rar
- 基于matlab实现配电网潮流 经典33节点 前推回代法潮流计算 回代电流 前推电压 带注释.rar
- 基于matlab实现模拟退火遗传算法的车辆调度问题研究,用MATLAB语言加以实现.rar
- 基于matlab实现蒙特卡洛的的移动传感器节点定位算法仿真代码.rar
- 华中数控系统818用户说明书
- 基于matlab实现卡尔曼滤波器完成多传感器数据融合 对多个机器人的不同传感器数据进行融合估计足球精确位置.rar
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功