内江师范学院本科毕业论文（设计）
}
public void setUrl(String url) { }
public void setUserName(String userName) { }
private Connection getConnection() throws Exception { }
public ResultSet query(String sql) throws Exception { }
public int update(String sql) throws Exception { }
public void release(){
try{
if(rs!=null)
rs.close();
con=getConnection(); stm=con.createStatement(); return stm.executeUpdate(sql); con=getConnection(); stm=con.createStatement(); rs=stm.executeQuery(sql); return rs;
Class.forName(driver);
con=DriverManager.getConnection(url,userName,password); return con;
this.userName = userName; this.url = url;
stm.close(); con.close();
}catch(Exception e){
e.printStackTrace();
26
内江师范学院本科毕业论文（设计）
}
}
}
商品添加模块
protected void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {
//检查是否有文件上传的请求 boolean isUpload =
ServletFileUpload.isMultipartContent(request); ();
//设置工厂约束: //1.设置文件存放的路径
File path = new File(this.getServletContext
//创建一个基于磁盘文件项的工厂
DiskFileItemFactory factory = new DiskFileItemFactory
().getRealPath(\
+ \
factory.setRepository(path); //2.设置最大内存大小 factory.setSizeThreshold(1024); //创建一个新的文件上传处理对象
ServletFileUpload upload = new ServletFileUpload
(factory);
//设置最大上传文件大小
upload.setSizeMax(1024 * 1024*100); int a=0; try {
//解析请求
List items = upload.parseRequest(request); Iterator ite = items.iterator();
27
内江师范学院本科毕业论文（设计）
String proName=\String truePrice=\String herePrice=\String onTime=\String explain=\String typeID=\String imgPath=\while (ite.hasNext()) {
//集合中的每一个元素是FileItem对象 FileItem item = (FileItem) ite.next(); if (item.isFormField()) {//一般表单字段
if(\ }
else if(\ }
else if(\ }
else if(\ }
else if(\ }
else if(\ }
} else {//文件
//保存文件到指定目录 typeID=item.getString(\explain=item.getString(\onTime=item.getString(\herePrice=item.getString(\truePrice=item.getString(\proName=item.getString(\
28
内江师范学院本科毕业论文（设计）
System.out.println( new String(
item.getName().getBytes(), \
File tempFile = new File( new
String( item.getName().getBytes(), \
imgPath=tempFile.getName(); System.out.println(imgPath); File target = new File
(factory.getRepository(),tempFile.getName());
}
System.out.println
item.write(target); }
(proName+\
AdminDAO dao=new AdminDAO();
a=dao.addproduct(proName, typeID, imgPath,
explain, onTime, truePrice, herePrice);
} catch (FileUploadException e) {
e.printStackTrace();
} catch (Exception e) { } if(a==1){ }
//返回成功消息
RequestDispatcher rd=request.getRequestDispatcher
String msg = \商品添加成功!\request.setAttribute(\e.printStackTrace();
(\
}
protected void doPost(HttpServletRequest request,
rd.forward(request, response);
29
内江师范学院本科毕业论文（设计）
HttpServletResponse response)throws ServletException, IOException { }
}
this.doGet(request, response);
30