try {
DiskFileItemFactory factory = new DiskFileItemFactory();
ServletFileUpload servletFileUpload = new ServletFileUpload(factory);
List<String> cplist = new ArrayList<String>();
String name = null;
//servletFileUpload.setFileSizeMax(1024*1024*8);
//判断当前的request是否是文件上传的格式
if(servletFileUpload.isMultipartContent(request)) {
//获取前端的内容
List<FileItem> list = servletFileUpload.parseRequest(request);
//遍历
for (FileItem fileItem : list) {
//判断当前的fileItem是否是普通表单域
if(fileItem.isFormField()) {
String fieldName = fileItem.getFieldName();
String value = fileItem.getString("UTF-8");
// String name = fileItem.getName();
// System.out.println(name);
//输出内容
System.out.println(fieldName+"---"+value);
cplist.add(value);
System.out.println(cplist);
}else {
String fieldName = fileItem.getFieldName();
name = fileItem.getName();
//System.out.println(fieldName+"----"+name);
if (!"".equals(name)) {
//上传文件的名称
name=UUID.randomUUID().toString().replaceAll("-", "")+"+"+name;
String realPath = "E:\\workspace\\xxxxxx";
File file = new File(realPath);
if(!file.exists()) {
file.mkdir();
}
//将当前的文件存储到你指定的地方
fileItem.write(new File(file, name));
}
}
}
}
caipinService.addcpList(cplist,name);
System.out.println(name);
//跳转页面
request.getRequestDispatcher("/sys/board/foodList.jsp").forward(request, response);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
//连接数据库
public void addcpList( List<String> cplist, String name ) {
// TODO Auto-generated method stub
Connection connection=null;
PreparedStatement pst=null;
ResultSet rs=null;
//添加的SQl语句
String sql="insert into caipin(caixi,number,name,price,membership,url) values(?,null,?,?,?,?)";
try {
connection=JDBCUtil.getConnection();
pst=connection.prepareStatement(sql);
//植入前端获取内容
pst.setInt(1, Integer.parseInt(cplist.get(0)));
pst.setString(2, cplist.get(2));
pst.setInt(3, Integer.parseInt(cplist.get(3)));
pst.setInt(4, Integer.parseInt(cplist.get(4)));
pst.setString(5, name);
pst.executeUpdate();
} catch (SQLException e) {
// TODO: handle exception
e.printStackTrace();
}finally {
JDBCUtil.close(rs, pst, connection);
}
}
//前端页面内容
<form action="<%=contextPath %>/caipinServlet?method=addcpList" method="post" >
<!-- 本段标题(分段标题) -->
<div class="ItemBlock_Title">
<img width="4" height="7" border="0" src="<%=contextPath %>/style/images/item_point.gif"> 菜品信息
</div>
<!-- 本段表单字段 -->
<div class="ItemBlockBorder">
<div class="ItemBlock">
<div class="ItemBlock2">
<table cellpadding="0" cellspacing="0" class="mainForm">
<tr>
<td width="80px">菜系</td>
<td>
<select name="cid" style="width:80px">
<option value="1" >粤菜</option>
<option value="2" >川菜</option>
<option value="3" >湘菜</option>
<option value="4" >东北菜</option>
</select>
<input type="hidden" name="id" value="" /></td>
</tr>
<tr>
<td width="80px">菜名</td>
<td><input type="text" name="foodName" class="InputStyle" value=""/></td>
</tr>
<tr>
<td>价格</td>
<td><input type="text" name="price" class="InputStyle" value=""/></td>
</tr>
<tr>
<td>会员价格</td>
<td><input type="text" name="mprice" class="InputStyle" value=""/></td>
</tr>
<tr>
<td>简介</td>
<td><textarea name="introduce" class="TextareaStyle"></textarea></td>
</tr>
<tr>
<td width="80px">菜品图片</td>
<td>
<input type="file" name="imageUrl"/>
</td>
</tr>
</table>
</div>
</div>
</div>
<!-- 表单操作 -->
<div id="InputDetailBar">
<input type="submit" value="添加" class="FunctionButtonInput">
<a href="javascript:history.go(-1);" class="FunctionButton">返回</a>
</div>
</form>