<%@ page contentType="text/html;charset=GB2312" %>
<%@ include  file="check.jsp" %>
<%@ page import="java.util.*" %>        
<script language=javascript src="mouse.js"></script>

<%      
	Calendar now = Calendar.getInstance();
	String sj = now.get(Calendar.YEAR)+"-"+(now.get(Calendar.MONTH)+1)+"-"+now.get(Calendar.DAY_OF_MONTH)+" "+now.get(Calendar.HOUR_OF_DAY)+":"+now.get(Calendar.MINUTE)+":"+now.get(Calendar.SECOND);

	String tmp = String.valueOf(session.getAttribute("Uid"));
	String path = request.getRealPath("userphoto");
	//out.println(path);
        
	myUpload.setSavePath(path);
	myUpload.setNewname(tmp);
	myUpload.doUpload(request,response);
	String ext = myUpload.getFileext();
	String filename= "userphoto/"+tmp+"."+ext;
	String fname = path+"/"+tmp+"."+ext;
	//out.println(filename);
	int ID = Integer.parseInt(myUpload.getFieldValue("tid"));
        
	String type = "image/jpeg";
	if(ext.toLowerCase().indexOf("jp")!=-1) type = "image/jpeg";
	if(ext.toLowerCase().indexOf("gif")!=-1) type = "image/gif";    
	String sql="";
        
	if(myUpload.isUpload()){        
		tosql.fileToSql(fname,"userinfo","photo1",ID);
		sql = "update userinfo set Ltime='"+sj+"',havephoto=1,photo='"+filename+"' where userid="+session.getAttribute("Uid");
		sqlbean.executeUpdate(sql);	        
		sqlbean.close();
	}else{
		out.println("圖片沒有上載成功！");
	}       
//	  out.println(sql);
	out.println(sqlbean.showMsg("javascript:history.back();","圖片已經上載,正在返回","系統提示"));  
%>