使用structs上傳文件到服務器

2024-04-27 15:18:07

字體：大中小

來源：轉載

供稿：網友

Structs界面Demo：xm_ya_oper.js

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; String getslid=request.getParameter("getslid"); System.out.PRintln("aaa 界面="+getslid); %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base target="_self">//注意引用,當前窗口操作 <base href="<%=basePath%>"> <title>導入文件</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keyWords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page">  </head> <script> function tjform() { alert("上傳成功，確定要關閉界面嗎？"); window.parent.returnValue='gbym'; //把值傳遞到父類

window.close(); } </script> <body> <form id="form1" name="form1" action="importAction_importData.do" enctype="multipart/form-data" method="post"> <table> <tr> <td> <input type="hidden" id="slid" name="slid" value="<%=getslid %>"/> <input type="file" id="image" name="image" /> </td> <td> <input type="button" id="tj" name="tj" value="提交" onclick="submit();tjform();" /> //注意，這個地方一定要這么寫，1、先執(zhí)行提交方法2、執(zhí)行關閉以及傳參的方法。否則提交時候出現connetion等就是數據錄入不到數據庫的問題</td> </tr> <tr> </tr> </table> </form> </body> </html> 控制類action Domo： Operaction.java private File image; //上傳的文件 private String imageFileName; //文件名稱 private String imageContentType; //文件類型 private String slid; //注意以上屬性必須set、get 這是使用structs的一大優(yōu)勢，直接通過get取值 /** * 導入數據 * @return */ public String importData(){ HttpServletRequest request = ServletActionContext.getRequest(); String realpath = ServletActionContext.getServletContext().getRealPath("/upload");//獲取tomcat實際的真實路徑下的 System.out.println("realpath: "+realpath); if (image != null) { File savefile = new File(new File(realpath), imageFileName);//imageFileName文件名 if (!savefile.getParentFile().exists()) savefile.getParentFile().mkdirs(); try { FileUtils.copyFile(image, savefile);//執(zhí)行寫入，這句話關鍵作用 ActionContext.getContext().put("message", "文件上傳成功"); } catch (IOException e) { e.printStackTrace(); } } String filePath=realpath+"//"+imageFileName; this.operDao.insertData(filePath,id,slid);//掉用業(yè)務實現類業(yè)務實現類Demo：OperDao File file=new File(filePath); //解析字符串 String encoding="GBK"; if(file.isFile() && file.exists()){ //判斷文件是否存在 if(filePath.contains("txt")){ InputStreamReader read; try { read = new InputStreamReader(new FileInputStream(file),encoding); //這是關鍵 BufferedReader bufferedReader = new BufferedReader(read); while((lineTxt = bufferedReader.readLine()) != null){ } 整個實現類內容如下： package com.kanq.jsgt.dao; import com.kanq.jsgt.entity.Bean; import com.kanq.jsgt.util.FileUtil; import com.news.connectionPool.Tool; import java.io.BufferedInputStream; import java.io.BufferedOutputStream; import java.io.BufferedReader; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.io.InputStreamReader; import java.io.OutputStream; import java.io.UnsupportedEncodingException; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.text.DecimalFormat; import java.util.ArrayList; import java.util.List; import javax.servlet.ServletContext; import javax.servlet.http.HttpServlet; import org.apache.commons.io.FileUtils; import org.apache.struts2.ServletActionContext; import jxl.Cell; import jxl.Sheet; import jxl.Workbook; import jxl.read.biff.BiffException; public class OperDao extends HttpServlet { private Connection conn=Tool.getConnection(); private PreparedStatement pre = null ; private ResultSet rs = null; String jzds=""; String dkmj=""; String dkbh=""; String dkmc=""; String txsx=""; String tfh=""; String dkyt=""; String dlbh=""; String czf=""; String lineTxt = null; int count=0;//統計行數 String zlh="";//勘測定界資料序號,可為空 int dkcount=0;//統計地塊個數 int jcount=0;//統計每個地塊J的個數 String str="";//記錄循環(huán)第一行的數值 String kcdjcgbidbz=""; DecimalFormat df = new DecimalFormat("0.000"); double x=0.00; double y=0.00; double FSBC=0.00;//反算邊長,第一行默認0.00 private static final int BUF_SIZE = 8192; /** * 插入數據 * @param data * @return */ public String insertData(String filePath,String kcdjcgbid,String slid){ System.out.println("業(yè)務實現類方法，slid: "+slid); System.out.println(filePath);//C:/b22.txt File file=new File(filePath); //解析字符串 String encoding="GBK"; if(file.isFile() && file.exists()){ //判斷文件是否存在 if(filePath.contains("txt")){ InputStreamReader read; try { read = new InputStreamReader(new FileInputStream(file),encoding); BufferedReader bufferedReader = new BufferedReader(read); while((lineTxt = bufferedReader.readLine()) != null){ count++; if(count>=13){ //調用方法，執(zhí)行數據的錄入 insertDataOper(kcdjcgbid,slid); } } read.close(); } catch (Exception e) { e.printStackTrace(); } }else if(filePath.contains("xls")){ System.out.println("包含xls"); Workbook wb = null; lineTxt=""; // System.out.println(lineTxt); try { wb=Workbook.getWorkbook(file);//構造Workbook（工作薄）對象 } catch (BiffException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } if(wb==null){ return null; } Sheet[] sheet = wb.getSheets(); if(sheet!=null&&sheet.length>0){//對每個工作表進行循環(huán) Sheet rs = sheet[0]; //第一個工作薄 int irows = rs.getRows(); //行數 int icols = rs.getColumns(); //列數 for (int i = 4; i < irows; i++) { for (int j = 0; j < icols; j++) { Cell cell = rs.getCell(j, i); String strc11 = cell.getContents(); lineTxt+=strc11+","; //調用方法，執(zhí)行數據的錄入 } // System.out.print(lineTxt); insertDataOper(kcdjcgbid,slid); lineTxt=""; System.out.print(lineTxt); System.out.print("/n"); } } } }else{ System.out.println("找不到指定的文件"); } return ""; } public void insertDataOper(String kcdjcgbid,String slid){ System.out.println(lineTxt); // System.out.println("============================================hello"); if(lineTxt.indexOf('@')>0){//453,1573.3860,1,蒙陽鎮(zhèn)關口村、蒙頂山鎮(zhèn)蒙山村、金花村、名雅村，面,面,,@,,@ dkcount++; jcount=0;//統計每個地塊J的個數 str="";//記錄每個地塊的初始點 // Long value=Long.parseLong(kcdjcgbid)+dkcount; kcdjcgbidbz=String.valueOf(Math.random()).substring(2, 4)+dkcount; jzds=lineTxt.split(",")[0];//界址點數//26,1.3705,1,地塊1,面,H50G032071, 住宅用地,,@ dkmj=lineTxt.split(",")[1];//地塊面積 dkbh=lineTxt.split(",")[2];//地塊編號 dkmc=lineTxt.split(",")[3];//地塊名稱 txsx=lineTxt.split(",")[4];//記錄圖形屬性(點、線、面) tfh=lineTxt.split(",")[5];//圖幅號 dkyt=lineTxt.split(",")[6];//地塊用途 dlbh=lineTxt.split(",")[7];//地類編號，@的個數便是地類編號，表沒有相對應的字段，暫時不錄入 czf=lineTxt.split(",")[8];//操作符 // String @=strrow[i].split(",")[8];//地塊用途 //針對每列數據，錄入數據庫 String sql="insert into ya_kcdjcgb(kcdjcgbid,zlh,jeds,dkmj,dkbh,dkmc,txsx,tfh,dkyt) " + "values('"+kcdjcgbidbz+"','"+zlh+"','"+jzds+"','"+dkmj+"','"+dkbh+"','"+dkmc+"','"+txsx+"','"+tfh+"','"+dkyt+"')"; try { this.pre = this.conn.prepareStatement(sql); this.pre.execute(); this.pre.close(); } catch (SQLException e) { e.printStackTrace(); } //錄入關系表 String sql3="insert into ya_dk_bp(slid,sl0id,dkmc,kcdjcgbid) values('"+slid+"',oper_seq.nextval,'"+dkmc+"','"+kcdjcgbidbz+"')"; try { this.pre = this.conn.prepareStatement(sql3); this.pre.execute(); this.pre.close(); } catch (SQLException e) { e.printStackTrace(); } } //錄入每個地塊點數 if(lineTxt.contains("J")){ jcount++; int dkid=jcount;//勘測定界地塊ID String[] strcolumn=lineTxt.split(","); String JZDH=strcolumn[0];//界址點號 a列 J1,1,3330824.1090,34602293.93 String DKQH=strcolumn[1];//地塊圈號 b列 String XZB=strcolumn[2];//X坐標 c列 String YZB=strcolumn[3];//Y坐標 D列 czf=""; // System.out.println("lineTxt="+lineTxt); // System.out.println("str="+str); if(jcount<2){//如果是第一行坐標，記錄下來 FSBC=0.00;//第一個點的反算邊長固定為0，因為前面沒有點 x=Double.valueOf(XZB); y=Double.valueOf(YZB); }else{ double x2=Double.valueOf(XZB); double y2=Double.valueOf(YZB); double xchapf=(x2-x)*(x2-x);//x差平方 double ychapf=(y2-y)*(y2-y);//y差平方 double xpfh=xchapf+ychapf;//差平方合 FSBC=Math.sqrt(xpfh);//根號取值 //記錄前點坐標 x=Double.valueOf(XZB); y=Double.valueOf(YZB); } if(JZDH.equals(str)){//判斷是否與第一行J的界止點號一樣 // System.out.println("JZDH="+JZDH); czf="D"; jcount=0; } if(jcount==1){//記錄第一行J的界止點號 str=JZDH; } // System.out.println("a列="+JZDH+",b列"+YZB+",c列"+XZB+",D列"+DKQH);// //針對每列數據，錄入數據庫 String sql2="insert into ya_kcdjcgb_b(kcdjcgbid,dkid,jzdh,xzb,yzb,fsbc,dkqh,czf) values('"+kcdjcgbidbz+"',oper_seq.nextval,'"+JZDH+"','"+YZB+"','"+XZB+"','"+df.format(FSBC)+"','"+DKQH+"','"+czf+"')"; try { this.pre = this.conn.prepareStatement(sql2); this.pre.execute(); this.pre.close(); } catch (SQLException e) { e.printStackTrace(); } } } /** * 導出數據 * @param data * @return */ public List<Bean> exportData(String kcdjcgbid){ List<Bean> list = new ArrayList<Bean>(); try { //地塊 String dksql="select * from ya_kcdjcgb where kcdjcgbid='"+kcdjcgbid+"'";//地塊sql，查看點數 this.pre = this.conn.prepareStatement(dksql); this.rs=this.pre.executeQuery(); while(rs.next()){ Bean bean=new Bean(); bean.setJzds(rs.getString("jeds"));//界址點數 bean.setDkmj(rs.getString("dkmj"));//地塊面積 bean.setDkmj(rs.getString("dkmj"));//地塊編號 bean.setDkmc(rs.getString("dkmc"));//地塊名稱 bean.setTxsx(rs.getString("txsx"));//記錄圖形屬性(點、線、面) bean.setTfh(rs.getString("tfh"));//圖幅號 bean.setDkyt(rs.getString("dkyt"));//地塊用途 // bean.setDlbh(rs.getString("dlbh"));//地類編號 list.add(bean); //地塊，點數 String sql="select * from ya_kcdjcgb_b where kcdjcgbid='"+kcdjcgbid+"'"; this.pre = this.conn.prepareStatement(sql); this.rs=this.pre.executeQuery(); while(rs.next()){ bean=new Bean(); bean.setJzdh(rs.getString("jzdh"));//界址點號 a列 bean.setDkqh(rs.getString("dkqh"));//地塊圈號 b列 bean.setXzb(rs.getString("xzb"));//X坐標 c列 bean.setYzb(rs.getString("yzb"));//Y坐標 D列 bean.setFsbc(rs.getString("fsbc"));//反算邊長 list.add(bean); } } } catch (SQLException e) { e.printStackTrace(); } return list; } }