package com.database;

import java.sql.*;
import java.util.*;
import java.io.*;
import javax.servlet.http.HttpServletRequest;

public class dbVipUserMsg extends DataBase{
	private vipUserMsg vipUser=new vipUserMsg();//創建新的用戶對象
	private HttpServletRequest request;//建立頁面請求	
	private String message="";	//聲明出錯信息提示	
	//private String id="";		//注冊后返回的用戶ID
	private Calendar MyDate = Calendar.getInstance();
	
	public dbVipUserMsg() throws Exception{
		super();
	}
	
	public String getGbk(String str){
		//try{
		//	return new String(str.getBytes("gb2312"));
		//}catch(Exception e){
			return str;
		//}
	}	
//	將頁面表單傳來的資料分解
	public boolean getRequest(HttpServletRequest newrequest){
		boolean flag=false;
		try{
			request=newrequest;
//			獲取Id參數			
			String Id=request.getParameter("Id");
			if(Id==null||Id.equals("")){
				Id="";
				message=message+"會員帳號為空";
			}
			vipUser.setId(getGbk(Id));			
//			獲取nickName參數
			String userName=request.getParameter("userName");
			if(userName==null||userName.equals("")){
				userName="";
				message=message+"真實姓名為空";
			}
			vipUser.setUserName(getGbk(userName));
//			獲取passQuestion參數
			String passQuestion=request.getParameter("passQuestion");
			if(passQuestion==null||passQuestion.equals("")){
				passQuestion="";
				message=message+"密碼提示問題為空";
			}
			vipUser.setPassQuestion(getGbk(passQuestion));
//			獲取passAnswer參數
			String passAnswer=request.getParameter("passAnswer");
			if(passAnswer==null||passAnswer.equals("")){
				passAnswer="";
				message=message+"密碼提示答案為空";
			}
			vipUser.setPassAnswer(getGbk(passAnswer));
//			獲取introduction參數
			String introduction=request.getParameter("introduction");
			if(introduction==null||introduction.equals("")){
				introduction="";
				message=message+"自我介紹";
			}
			vipUser.setIntroduction(getGbk(introduction));		
//			獲取eduStatus參數
			String eduStatus=request.getParameter("eduStatus");
			if(eduStatus==null||eduStatus.equals("")){
				eduStatus="";
				message=message+"教育程度為空";
			}
			vipUser.setEduStatus(getGbk(eduStatus));		
//			獲取graduTime參數
			String year=request.getParameter("year");
			String month=request.getParameter("month");
			String graduTime=year+"."+month;
			if(graduTime==null||graduTime.equals("")){
				graduTime="";
				message=message+"畢業時間為空";
			}
			vipUser.setGraduTime(getGbk(graduTime));
//			獲取graduSchool參數
			String graduSchool=request.getParameter("graduSchool");
			if(graduSchool==null||graduSchool.equals("")){
				graduSchool="";
				message=message+"畢業院校為空";
			}
			vipUser.setGraduSchool(getGbk(graduSchool));
//			獲取job參數
			String job=request.getParameter("job");
			if(job==null||job.equals("")){
				job="";
				message=message+"從事工作為空";
			}			
			vipUser.setJob(getGbk(job));
//			獲取workUnit參數
			String workUnit=request.getParameter("workUnit");
			if(workUnit==null||workUnit.equals("")){
				workUnit="";
				message=message+"工作單位為空";
			}			
			vipUser.setWorkUnit(getGbk(workUnit));
//			獲取Picture參數
			String Picture=request.getParameter("Picture");
			if(Picture==null||Picture.equals("")){
				Picture="";
				message=message+"相片路徑為空";
			}			
//////			
		if(message.equals("")){
			flag=true;
		}
		return flag;
		}catch(Exception e){
			return flag;
		}
	}
//	將高級用戶信息加入數據庫	
	public boolean insert(HttpServletRequest req)throws Exception{
		if(getRequest(req)){
			sql="insert into vip_Users(Id,userName,passQuestion,passAnswer,introduction,eduStatus,graduTime,graduSchool,job,workUnit,regVIPTime,Score,Picture) values('";
			sql=sql+strformat.toSql(vipUser.getId())+"','";
			sql=sql+strformat.toSql(vipUser.getUserName())+"','";			
			sql=sql+strformat.toSql(vipUser.getPassQuestion())+"','";
			sql=sql+strformat.toSql(vipUser.getPassAnswer())+"','";
			sql=sql+strformat.toSql(vipUser.getIntroduction())+"','";
			sql=sql+strformat.toSql(vipUser.getEduStatus())+"','";
			sql=sql+strformat.toSql(vipUser.getGraduTime())+"','";
			sql=sql+strformat.toSql(vipUser.getGraduSchool())+"','";
			sql=sql+strformat.toSql(vipUser.getJob())+"','";
			sql=sql+strformat.toSql(vipUser.getWorkUnit())+"','";
			sql=sql+MyDate.getTime()+"',";//使用getTime()獲得系統時間
			sql=sql+"0"+",?);";
			
			try{
				String filename=request.getParameter("Picture");
				FileInputStream str=new FileInputStream(filename);
				PreparedStatement pstmt=conn.prepareStatement(sql);
				pstmt.setBinaryStream(1,str,str.available());
				pstmt.execute();
				pstmt.close();
				str.close();
				return true;
			}catch(SQLException sqle){
				System.out.println(sqle.toString());
				return false;
			}
		}else{
			return false;
		}
	}
	
//	更新高級用戶信息
	public boolean update(HttpServletRequest req)throws Exception{
		if(getRequest(req)){
			sql="select Id from vip_Users where Id="
				+vipUser.getId();
			rs=stmt.executeQuery(sql);
			if(!rs.next()){
				message=message+"id不存在！";
				rs.close();
				return false;
			}

			sql="update vip_users set userName='"+vipUser.getUserName()
				+"',passQuestion='"+vipUser.getPassQuestion()
				+"',passAnswer='"+vipUser.getPassAnswer()
				+"',introduction='"+vipUser.getIntroduction()
				+"',eduStatus='"+vipUser.getEduStatus()
				+"',graduTime='"+vipUser.getGraduTime()
				+"',graduSchool='"+vipUser.getGraduSchool()
				+"',job='"+vipUser.getJob()
				+"',workUnit='"+vipUser.getWorkUnit()
				+"',regVIPTime='"+MyDate.getTime()
				+"',Score='"+"0"
				+"',Picture=? " 
				+"where Id='"+vipUser.getId()+"'";		
				
				try{					
					String filename=request.getParameter("Picture");
					FileInputStream str=new FileInputStream(filename);
					PreparedStatement pstmt=conn.prepareStatement(sql);
					pstmt.setBinaryStream(1,str,str.available());
					pstmt.execute();
					pstmt.close();
					str.close();
					return true;
				}catch(SQLException e){
					System.out.println(e.toString());
					return false;
				}						
		}else{
			return false;
		}
	}
	
	public String getMessage() {
		return message;
	}
	public void setMessage(String message) {
		this.message = message;
	}
	
}