package com.mole.struts.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;

import com.mole.struts.bean.CustomerInfoBean;

public class CustomerInfoDAO {
	private Connection conn;

	public CustomerInfoDAO() {
		try {
			Context ctx = new InitialContext();
			if (ctx == null)
				throw new Exception("Failed to initial context!");
			DataSource ds = (DataSource) ctx
					.lookup("java:comp/env/jdbc/crmdata");
			conn = ds.getConnection();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	// 獲取用戶基本信息
	public CustomerInfoBean getCustomerInfo(String ID) throws Exception {
		ResultSet rs = null;
		PreparedStatement ps = null;
		CustomerInfoBean bean = new CustomerInfoBean();
		String sql = "SELECT [LoginName],[Name],[FaceImage],[FaceWidth],[FaceHeight],"
				+ "CONVERT(varchar(30),[LastLogin],120),CONVERT(varchar(30),[CreateDate],120),"
				+ "[Nickname],[BlogTitle],[BlogSubTitle],[BlogStyle],[Gender],[Interest],"
				+ "[Description],[ShowRecord],[ShowShopped] FROM [Customer] WHERE [ID]=?";
		try {
			conn.setAutoCommit(true);
			ps = conn.prepareStatement(sql);
			ps.setObject(1, ID);
			rs = ps.executeQuery();
			if (rs.next()) {
				bean.setID(ID);
				bean.setLoginName(rs.getString(1));
				bean.setName(rs.getString(2));
				bean.setFaceImage(rs.getString(3).trim());
				bean.setFaceWidth(rs.getString(4));
				bean.setFaceHeight(rs.getString(5));
				bean.setLastLogin(rs.getString(6));
				bean.setCreateDate(rs.getString(7));
				bean.setNickname(rs.getString(8));
				bean.setBlogTitle(rs.getString(9));
				bean.setBlogSubTitle(rs.getString(10));
				bean.setBlogStyle(rs.getString(11).trim());
				bean.setGender(rs.getString(12));
				bean.setInterest(rs.getString(13));
				bean.setDescription(rs.getString(14));
				bean.setShowRecord(rs.getString(15));
				bean.setShowShopped(rs.getString(16));
			}
			return bean;
		} finally {
			if (ps != null)
				ps.close();
		}
	}
}