现在的位置: 首页 > 综合 > 正文

使用jpsSmartUpload上传一个文件，并且把相应的数据写入数据库成为一条记录

2013年07月02日 ⁄ 综合 ⁄ 共 16960字 ⁄ 字号 小 中 大 ⁄ 评论关闭

PrepareInsert.jsp

----------------------------------------------------------------------------------------------------------------

<%@ page import="java.sql.*" %>
<%@ page contentType="text/html; charset=gb2312" %>

<html>
<head>
<title>计算中心资产管理系统</title>

<script>
<!--
 function checkNum(){
  //alert(product.Number.value);
    var pattern = /^(-?/d+)(/./d+)?$/;
     if(product.Number.value.match(pattern)==null){
       alert("资产数量请输入数字") ;
       product.Number.focus();
       product.Number.select();
       return false;
     }
  else if(product.price.value.match(pattern)==null){
       alert("资产价格请输入数字") ;
       product.price.focus();
       product.price.select();
       return false;
     }
     else{    
   product.submit();
     }
 }

function getNowDate()
{
   var nn=new Date();
   year1=nn.getYear();
   mon1=nn.getMonth()+1;
   date1=nn.getDate();
   var monstr1;
   var datestr1
   if(mon1<10)
    monstr1="0"+mon1;
   else
    monstr1=""+mon1;
    
   if(date1<10)
     datestr1="0"+date1;
   else
     datestr1=""+date1;
   return year1+"-"+monstr1+"-"+datestr1;
}
function getlastweekDate()
{
   var nn=new Date();
   year1=nn.getYear();
   mon1=nn.getMonth()+1;
   date1=nn.getDate();
  
   var mm=new Date(year1,mon1-1,date1);
   var tmp1=new Date(2000,1,1);
   var tmp2=new Date(2000,1,15);
   var ne=tmp2-tmp1;
   var mm2=new Date();
   mm2.setTime(mm.getTime()-ne);
  
  
   year2=mm2.getYear();
   mon2=mm2.getMonth()+1;
   date2=mm2.getDate();
   
   
     if(mon2<10)
    monstr2="0"+mon2;
   else
    monstr2=""+mon2;
    
   if(date2<10)
     datestr2="0"+date2;
   else
     datestr2=""+date2;
 
  
    return year2+"-"+monstr2+"-"+datestr2;
}

var gdCtrl = new Object();
var goSelectTag = new Array();
var gcGray   = "#808080";
//var gcToggle = "#FB8664";
var gcToggle = "#7777ff";
//var gcBG = "#e5e6ec";
var gcBG = "#ffffff";
var previousObject = null;

var gdCurDate = new Date();
var giYear = gdCurDate.getFullYear();
var giMonth = gdCurDate.getMonth()+1;
var giDay = gdCurDate.getDate();
var giHour="00";
var giMinute="00";

function fSetDate(iYear, iMonth, iDay,iHour,iMinute){
  VicPopCal.style.visibility = "hidden";
  if ((iYear == 0) && (iMonth == 0) && (iDay == 0)){
   gdCtrl.value = "";
  }else{
   iMonth = iMonth + 100 + "";
   iMonth = iMonth.substring(1);
   iDay   = iDay + 100 + "";
   iDay   = iDay.substring(1);
   iHour   = iHour + 100 + "";
   iHour   = iHour.substring(1);
   iMinute   =  iMinute + 100 + "";
   iMinute   =  iMinute.substring(1);

   if(gdCtrl.tagName == "INPUT"){
      gdCtrl.value = iYear+"-"+iMonth+"-"+iDay+" "+iHour+":"+iMinute+":00";
   }else{
      gdCtrl.innerText = iYear+"-"+iMonth+"-"+iDay+" "+iHour+":"+iMinute+":00";
   }
  }
 
  for (i in goSelectTag)
   goSelectTag[i].style.visibility = "visible";
  goSelectTag.length = 0;
 
  window.returnValue=gdCtrl.value;
  //window.close();
  //qhk add
  if (yearNameObject!=null && monthNameObject!=null && dateNameObject!=null)
  {
   if (gdCtrl.value=="")
   {
    yearNameObject.value="";
    monthNameObject.value="";
    dateNameObject.value="";
   }
   else
   {
    yearNameObject.value=gdCtrl.value.substring(0,4);
    monthNameObject.value=gdCtrl.value.substring(5,7);
    dateNameObject.value=gdCtrl.value.substring(8,10);
   }
   yearNameObject=null;
   monthNameObject=null;
   dateNameObject=null;
  }
}

function HiddenDiv()
{
 var i;
  VicPopCal.style.visibility = "hidden";
 // Masked by Guozhong Zhang/Precom
  for (i in goSelectTag)
   goSelectTag[i].style.visibility = "visible";
  goSelectTag.length = 0;

}
function fSetSelected(aCell){
  var iOffset = 0;
  var iYear = parseInt(tbSelYear.value);
  var iMonth = parseInt(tbSelMonth.value);
  var iHour = parseInt(tbSelHour.value);
  var iMinute = parseInt(tbSelMinute.value);
 
  aCell.bgColor = gcBG;
  with (aCell.children["cellText"]){
   var iDay = parseInt(innerText);
   if (color==gcGray)
  iOffset = (Victor<10)?-1:1;
 iMonth += iOffset;
 if (iMonth<1) {
  iYear--;
  iMonth = 12;
 }else if (iMonth>12){
  iYear++;
  iMonth = 1;
 }
  }
  fSetDate(iYear, iMonth, iDay,iHour,iMinute);
}

function Point(iX, iY){
 this.x = iX;
 this.y = iY;
}

function fBuildCal(iYear, iMonth) {
  var aMonth=new Array();
  for(i=1;i<7;i++)
   aMonth[i]=new Array(i);
 
  var dCalDate=new Date(iYear, iMonth-1, 1);
  var iDayOfFirst=dCalDate.getDay();
  var iDaysInMonth=new Date(iYear, iMonth, 0).getDate();
  var iOffsetLast=new Date(iYear, iMonth-1, 0).getDate()-iDayOfFirst+1;
  var iDate = 1;
  var iNext = 1;

  for (d = 0; d < 7; d++)
 aMonth[1][d] = (d<iDayOfFirst)?-(iOffsetLast+d):iDate++;
  for (w = 2; w < 7; w++)
   for (d = 0; d < 7; d++)
  aMonth[w][d] = (iDate<=iDaysInMonth)?iDate++:-(iNext++);
  return aMonth;
}

function fDrawCal(iYear, iMonth, iCellHeight, sDateTextSize) {
  var WeekDay = new Array("日","一","二","三","四","五","六");
  var styleTD = " bgcolor='"+gcBG+"' bordercolor='"+gcBG+"' valign='middle' align='center' height='"+iCellHeight+"' style='font:arial "+sDateTextSize+";";            //Coded by Liming Weng(Victor Won) email:victorwon@sina.com

  with (document) {
   for (w = 1; w < 7; w++) {
  write("<tr>");
  for (d = 0; d < 7; d++) {
   write("<td id=calCell "+styleTD+"cursor:hand;' onMouseOver='this.bgColor=gcToggle' onMouseOut='this.bgColor=gcBG' onclick='fSetSelected(this)'>");
   write("<font id=cellText Victor='Liming Weng' size=2> </font>");   
   write("</td>");
   write("<TD>");

  }
  write("</tr>");
 }
  }
}

function fUpdateCal(iYear, iMonth) {
  myMonth = fBuildCal(iYear, iMonth);
  var i = 0;
  for (w = 0; w < 6; w++)
 for (d = 0; d < 7; d++)
  with (cellText[(7*w)+d]) {
   Victor = i++;
   if (myMonth[w+1][d]<0) {
    color = gcGray;
    innerText = -myMonth[w+1][d];
   }else{
    color = ((d==0)||(d==6))?"red":"black";
    innerText = myMonth[w+1][d];
   }
  }
}

function fSetYearMon(iYear, iMon){
  tbSelMonth.options[iMon-1].selected = true;
  for (i = 0; i < tbSelYear.length; i++)
 if (tbSelYear.options[i].value == iYear)
  tbSelYear.options[i].selected = true;
  fUpdateCal(iYear, iMon);
}

function fPrevMonth(){
  var iMon = tbSelMonth.value;
  var iYear = tbSelYear.value;
 
  if (--iMon<1) {
   iMon = 12;
   iYear--;
  }
 
  fSetYearMon(iYear, iMon);
}

function fNextMonth(){
  var iMon = tbSelMonth.value;
  var iYear = tbSelYear.value;
 
  if (++iMon>12) {
   iMon = 1;
   iYear++;
  }
 
  fSetYearMon(iYear, iMon);
}

function fToggleTags(){
  with (document.all.tags("SELECT")){
  for (i=0; i<length; i++)
   if ((item(i).Victor!="Won")&&fTagInBound(item(i))){
    item(i).style.visibility = "hidden";
    goSelectTag[goSelectTag.length] = item(i);
   }
  }
}

function fTagInBound(aTag){
  with (VicPopCal.style){
   var l = parseInt(left);
   var t = parseInt(top);
   var r = l+parseInt(width);
   var b = t+parseInt(height);
 var ptLT = fGetXY(aTag);
 return !((ptLT.x>r)||(ptLT.x+aTag.offsetWidth<l)||(ptLT.y>b)||(ptLT.y+aTag.offsetHeight<t));
  }
}

function fGetXY(aTag){
  var oTmp = aTag;
  var pt = new Point(0,0);
  do {
   pt.x += oTmp.offsetLeft;
   pt.y += oTmp.offsetTop;
   oTmp = oTmp.offsetParent;
  } while(oTmp.tagName!="BODY");
  return pt;
}

// Main: popCtrl is the widget beyond which you want this calendar to appear;
//       dateCtrl is the widget into which you want to put the selected date.
// i.e.: <input type="text" name="dc" style="text-align:center" readonly><INPUT type="button" value="V" onclick="fPopCalendar(dc,dc);return false">
function fPopCalendar(popCtrl, dateCtrl,strDate){
  if (popCtrl == previousObject){
    if (VicPopCal.style.visibility == "visible"){
    HiddenDiv();
    return true;
   }
   
  }
  previousObject = popCtrl;
  gdCtrl = dateCtrl;
  fInitialDate(strDate);
  fSetYearMon(giYear, giMonth);
  var point = fGetXY(popCtrl);
  with (VicPopCal.style) {
   left = point.x;
 top  = point.y+popCtrl.offsetHeight;
 width = VicPopCal.offsetWidth;
 width = 295;
 height = VicPopCal.offsetHeight;
 fToggleTags(point);  
 visibility = 'visible';
  }
}
//已经使用三个input(或select)项作为日期输入的程序，不想进行action修改，可调用以下函数，将日期作为隐藏域
var yearNameObject;
var monthNameObject;
var dateNameObject;
function newfPopCalendar(popCtrl,dateCtrl,yearName,monthName,dateName,strDate)
{
 fPopCalendar(popCtrl,dateCtrl,strDate);
 if (document.all.item(yearName).length==null)
 {
  yearNameObject=document.all.item(yearName);
  monthNameObject=document.all.item(monthName);
  dateNameObject=document.all.item(dateName);
 }
 else
 {
  yearNameObject=document.all.item(yearName)[document.all.item(yearName).length-1];
  monthNameObject=document.all.item(monthName)[document.all.item(monthName).length-1];
  dateNameObject=document.all.item(dateName)[document.all.item(dateName).length-1];
 }
}
//qhk --end
// Added by Danian Zhang/SUI
function fInitialDate(strDate){
 if( strDate == null || strDate.length != 10 )
  return false;

 var sYear  = strDate.substring(0,4);
 var sMonth = strDate.substring(5,7);
 var sDay   = strDate.substring(8,10);

 if( sMonth.charAt(0) == '0' ) { sMonth = sMonth.substring(1,2); }
 if( sDay.charAt(0)   == '0' ) { sDay   = sDay.substring(1,2);   }

 var nYear  = parseInt(sYear );
 var nMonth = parseInt(sMonth);
 var nDay   = parseInt(sDay  );
 
 if ( isNaN(nYear ) ) return false;
 if ( isNaN(nMonth) ) return false;
 if ( isNaN(nDay  ) ) return false;

 var arrMon = new Array(12);
 arrMon[ 0] = 31; arrMon[ 1] = nYear % 4 == 0 ? 29:28;
 arrMon[ 2] = 31; arrMon[ 3] = 30;
 arrMon[ 4] = 31; arrMon[ 5] = 30;
 arrMon[ 6] = 31; arrMon[ 7] = 31;
 arrMon[ 8] = 30; arrMon[ 9] = 31;
 arrMon[10] = 30; arrMon[11] = 31;

 if ( nYear  < 1900 || nYear > 2100 )   return false;
 if ( nMonth < 1 || nMonth > 12 )    return false;
 if ( nDay < 1 || nDay > arrMon[nMonth - 1] ) return false;

 giYear  = nYear;
 giMonth = nMonth;
 giDay   = nDay;
 return true;
}

var gMonths = new Array("一月","二月","三月","四月","五月","六月","七月","八月","九月","十月","十一月","十二月");

with (document) {
write("<Div id='VicPopCal' style='OVERFLOW:hidden;POSITION:absolute;VISIBILITY:hidden;border:2px ridge;z-index:100;font-size:8px'>");
write("<table border='0' bgcolor='#cccccc'>");
write("<TR>");
write("<td valign='middle' align='center'><input type='button' name='PrevMonth' value='<' style='height:20;width:20;FONT:bold' onClick='fPrevMonth()'>");
write("<SELECT name='tbSelYear' onChange='fUpdateCal(tbSelYear.value, tbSelMonth.value)' Victor='Won'>");
for(i=2000;i<2015;i++)
 write("<OPTION value='"+i+"'>"+i+" 年</OPTION>");
write("</SELECT>");
write("<select name='tbSelMonth' onChange='fUpdateCal(tbSelYear.value, tbSelMonth.value)' Victor='Won'>");
for (i=0; i<12; i++)
 write("<option value='"+(i+1)+"'>"+gMonths[i]+"</option>");
write("</SELECT>");
write("<input type='button' name='PrevMonth' value='>' style='height:20;width:20;FONT:bold' onclick='fNextMonth()'>");
write("</td>");
write("</TR><TR>");

write("<TD align='center'>");
write("<TABLE width='100%'><TR>");
  var WeekDay2 = new Array("日","一","二","三","四","五","六");
 for(i=0; i<7; i++){
  write("<td color:#000000' style='font:bold arial'>");
 // Added by Guozhong Zhang/Precom
 write("<font size=2>");   
  write( WeekDay2[i]);
 // Added by Guozhong Zhang/Precom
 write("</font>");   
  write("</td>");
 }
write("</tr></table>");
write("</TD></TR>");

write("<td align='center'>");
 // Modified by Guozhong Zhang/Precom
    //write("<DIV style='background-color:teal'><table width='100%' border='0'>");
write("<DIV style='background-color:white'><table width='100%' border='0'>");
fDrawCal(giYear, giMonth, 18, '12');
write("</table></DIV>");
write("</td>");
write("</TR><TR><TD align='center'>");
write("<TABLE width='100%'><TR><TD align='center'>");
write("<B style='cursor:hand' onclick='fSetDate(0,0,0,0,0)' onMouseOver='this.style.color=gcToggle' onMouseOut='this.style.color=0'><font size=2>清空</font></B>");
write("</td><td align='center'>");
write("<B style='cursor:hand' onclick='fSetDate(giYear,giMonth,giDay,0,0)' onMouseOver='this.style.color=gcToggle' onMouseOut='this.style.color=0'><font size=2>今天: "+giYear+"-"+giMonth+"-"+giDay+"</font></B>");
write("</td></tr></table>");
write("</TD>");

write("<TD style='color:gcToggle' width='605px'><span style='top:50;position:absolute;font-size:12px' width='60px'>");
var gHour = new Array("0","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23");
write("&nbsp;<select name='tbSelHour' Victor='Won'>");
for (i=0; i<24; i++){
 var now = new Date();
 var hours = now.getHours();
 if(gHour[i]==hours){
 write("<option SELECTED value='"+gHour[i]+"'>"+gHour[i]+"</option>");
  }
 else{
  write("<option value='"+gHour[i]+"'>"+gHour[i]+"</option>");
 }
}

write("</select>点<br><br><br>");

var gMinute = new Array("0","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","32","33","34","35","36","37","38","39","40","41","42","43","44","45","46","47","48","49","50","51","52","53","54","55","56","57","58","59");
write("&nbsp;<select name='tbSelMinute' onChange='fUpdateCal(tbSelYear.value, tbSelMonth.value)'  Victor='Won' style='width:40px'>");

for (i=0; i<60; i++){
 var now = new Date();
 var minutes = now.getMinutes();
 write("<option value='"+gMinute[i]+"'>"+gMinute[i]+"</option>");
 if(gMinute[i]==minutes){
  write("<option SELECTED value='"+gMinute[i]+"'>"+gMinute[i]+"</option>");
 }

}
write("</select>分");

write("</span></TD>");
write("</TR>");

write("</TABLE></Div>");
}
-->
</script>
</head>
<body>
<input type="button" value="返回列表" onclick="window.open('./search.jsp','_self','')">
<hr>
<b>请您录入需要添加的资产</b><br>
<form METHOD="POST" ACTION="/test/Insert.jsp" NAME="product" ENCTYPE="multipart/form-data">

<table border="1px">
 <tr>
  <td>资产名称</td>
  <td><input name="product_name"></td>
 </tr>
 <tr>
  <td>资产生产单位</td>
  <td><input name="producer"></td>
 </tr>
 <tr>
  <td>资产型号</td>
  <td><input name="type"></td>
 </tr>
 <tr>
  <td>资产数量</td>
  <td><input name="Number"></td>
 </tr>
 <tr>
  <td>资产价格</td>
  <td><input name="price"></td>
 </tr>
 <tr>
  <td>资产购买日期</td>
  <td>
   <input name="buying_date">
   <img src="./images/datetime.gif" width="16" height="16" onClick="fPopCalendar(buying_date,buying_date);return false;">
  </td>
 </tr>
 <tr>
  <td>固定资产编号</td>
  <td><input name="gdzc_id"></td>
 </tr>
 <tr>
  <td>产品编号</td>
  <td><input name="product_id"></td>
 </tr>
 <tr>
  <td>资产图片</td>
  <td>
   <input type="FILE" name="FILE1" size="30">
  </td>
 </tr>
  <tr>
  <td>资产发票图片</td>
  <td>
   <input type="FILE" name="FILE2" size="30">
  </td>
 </tr>
 <tr>
  <td colspan="2" align="right">
   <input type="button" value="提交"  onclick="return checkNum();">&nbsp;&nbsp;
  </td>
 </tr>
</table>
</form>
</body>
</html>

Insert.jsp

---------------------------------------------------------------------------------------------------------------------

<%@ page language="java" import="java.util.*,com.jspsmart.upload.*,java.sql.*"%>
<jsp:useBean id="myUpload" scope="page" class="com.jspsmart.upload.SmartUpload" />
<HTML>
<BODY BGCOLOR="white">
<H1>jspSmartUpload : Sample 5</H1>
<HR>
<%
 myUpload.initialize(pageContext);
 myUpload.upload();  

 out.println("<BR><BR><STRONG>Display information about Requests</STRONG><BR>");

 // Retreive Requests' names
 java.util.Enumeration e = myUpload.getRequest().getParameterNames();
 String[] values=null;
 
 values = myUpload.getRequest().getParameterValues("product_name");
 String product_name = values[0];
 //out.print(product_name);
 if(product_name==null){
  product_name="";
 }
 
 values = myUpload.getRequest().getParameterValues("producer");
 String producer = values[0];
 out.print(producer);
 if(producer==null){
  producer="";
 } 
 
 values = myUpload.getRequest().getParameterValues("type");
 String type = values[0];
 out.print(type);
 if(type==null){
  type="";
 }
 
 values = myUpload.getRequest().getParameterValues("Number");
 String Number = values[0];
 out.print(Number);
 if(Number==null){
  Number="";
 } 
 
 values = myUpload.getRequest().getParameterValues("price");
 String price = values[0];
 out.print(price);
 if(price==null){
  price="";
 }
 
 values = myUpload.getRequest().getParameterValues("buying_date");
 String buying_date = values[0];
 out.print(buying_date);
 if(buying_date==null){
  buying_date="";
 }
 
 values = myUpload.getRequest().getParameterValues("gdzc_id");
 String gdzc_id = values[0];
 out.print(gdzc_id);
 if(gdzc_id==null){
  gdzc_id="";
 }
 
 values = myUpload.getRequest().getParameterValues("product_id");
 String product_id = values[0];
 out.print(product_id);
 if(product_id==null){
  product_id="";
 }
 
 
 
 String url = "jdbc:odbc:test";
 Connection con;
 Statement stmt;

 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 String Insert= "insert into product(product_name,producer,type,count,price,buying_date,product_id,gdzc_id) values('"+product_name+"','"+producer+"','"+type+"','"+Number+"','"+price+"','"+buying_date+"','"+product_id+"','"+gdzc_id+"');";
 String InsertStr = new String(Insert.getBytes("ISO8859_1"),"gb2312");
 out.println("<br>"+InsertStr);
 con = DriverManager.getConnection(url, "admin", "");
 stmt = con.createStatement();
 stmt.executeUpdate(InsertStr);

 String id = "";
 String query = "select max(id) from Product";
 ResultSet rs = stmt.executeQuery(query);
 while(rs.next()){
  id = rs.getString(1);
 }
 
 out.println("1---id-------------------------"+id);

 
 //
 // Files
 //

 out.println("<BR><STRONG>Display information about Files</STRONG><BR>");

 out.println("Number of files = " + myUpload.getFiles().getCount() + "<BR>");
 //out.println("Total size (bytes) = " + myUpload.getFiles().getSize() +"<BR>");
 
 String ImageName = "";
 com.jspsmart.upload.File image = myUpload.getFiles().getFile(0);
 if (!image.isMissing()){
  ImageName =  id + "." +image.getFileExt();
  image.saveAs("/test/upload/" + ImageName,myUpload.SAVE_VIRTUAL);
 }
 
 String Fapiao = "";
 com.jspsmart.upload.File fapiao = myUpload.getFiles().getFile(1);
 if (!fapiao.isMissing()){
  Fapiao = id + "_fapiao." +image.getFileExt();
  image.saveAs("/test/upload/" + Fapiao,myUpload.SAVE_VIRTUAL);
 }
 for (int i=0;i<myUpload.getFiles().getCount();i++){
  out.print(myUpload.getFiles().getFile(i).getFieldName());
  if (!myUpload.getFiles().getFile(i).isMissing())
   out.print(" = " + myUpload.getFiles().getFile(i).getFileName() + " (" + myUpload.getFiles().getFile(i).getSize() + ")");
  else
   out.print(" = vide");  
  out.println("<BR>");
 }
  
 String UpdateString = "update product set image_url='"+ImageName+"', fapiao_url='"+Fapiao+"' where id="+id+";";
 UpdateString  = new String(UpdateString .getBytes("ISO8859_1"),"gb2312");
 out.println("<br>"+UpdateString);
 stmt = con.createStatement();
 stmt.executeUpdate(UpdateString);

 
 stmt.close();
 con.close();
 response.sendRedirect("./search.jsp");
%>
</BODY>
</HTML>

返回
【上篇】
【下篇】

作者:

抱歉!评论已关闭.

返回首页

Copyright © 2013-2018 学步园  保留所有权利.
软文销售 QQ客服：2265327166 点击这里给我发消息（其他合作也可洽谈）
必威体育
必威电竞