package com.jspdev.ch5;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.sql.*;

public class UserRegist
{
	private UserInfo userInfo;
	private Connection con;
	
	//獲得數(shù)據(jù)庫連接。
	public UserRegist()
	{
	 	String CLASSFORNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	    String SERVANDDB="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jspdev";
	    String USER="bn";
	    String PWD="bn"; 
	    try
	    {
	    	
	    	Class.forName(CLASSFORNAME);
			con = DriverManager.getConnection(SERVANDDB,USER,PWD);
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}
	//設置待注冊的用戶信息。
	public void setUserInfo(UserInfo userInfo)
	{
		this.userInfo=userInfo;
	}
	
	//進行注冊
	public void regist()throws Exception
	{
		String reg="insert into user_Info values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
		
		try
		{
			PreparedStatement pstmt=con.prepareStatement(reg);
			pstmt.setString(1,userInfo.getUserid());
			pstmt.setString(2,userInfo.getName());
			pstmt.setString(3,userInfo.getPhone());
			pstmt.setString(4,userInfo.getStreet());
			pstmt.setString(5,userInfo.getState());
			pstmt.setString(7,userInfo.getCity());
			pstmt.setString(6,userInfo.getZipCode());	
			pstmt.setString(8,userInfo.getEmail());
			pstmt.setString(9,userInfo.getCardNumber());
			pstmt.setInt(10,userInfo.getCardType());
			pstmt.setInt(11,0);
			pstmt.setDate(12,new java.sql.Date(new java.util.Date().getTime()));
			pstmt.setInt(13,1);
			pstmt.setInt(14,0);
			pstmt.setString(15,userInfo.getFanvcategory());
			pstmt.setString(16,userInfo.getPassword());
			pstmt.executeUpdate();
		}
		catch(Exception e)
		{
			e.printStackTrace();
			throw e;
		}
	}
}