package?mm.smy.bicq.server.user?;

/**
*?插入用戶到數(shù)據(jù)庫。
*?
*?
*?
*?
*?
*/

import?mm.smy.bicq.server.db.*?;
import?java.util.Date?;

import?java.sql.Statement?;
import?java.sql.SQLException?;

import?java.net.InetAddress?;

public?class?InsertUserDB{
	private?ServerGuest?guest?=?null?;
	private?StringBuffer?sb?=?null?;?//sql語句
	
	private?ReadWriteStatement?rw?=?null?;
	private?Statement?stmt?=?null?;
	
	public?InsertUserDB（）{}
	
	public?InsertUserDB（ServerGuest?m_guest）{
		guest?=?m_guest?;	
	}
	
	public?void?setServerGuest（ServerGuest?m_guest）{
		guest?=?m_guest?;	
		return?;
	}
	
	/**
	*?將數(shù)據(jù)真實(shí)加入到數(shù)據(jù)庫。
	*/
	public?int?update（）?throws?SQLException{
		init（）?;
		
		System.out.println（“$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$“）?;
		System.out.println（“the?sql?statement?we?creat?is:“?+?sb.toString（）?）?;
		if（sb?==?null）?return?-1?;
		
		if（rw?==?null）{
			rw?=?new?ReadWriteStatement（“user“）?;		
		}
		if（stmt?==?null）{
			stmt?=?rw.getStatement（）?;
		}
		
		return?stmt.executeUpdate（sb.toString（））?;		
	}
	
	public?void?close（）{
		if（rw?!=?null）{
			rw.close（）?;
		}
		
		if（stmt?!=?null）{
			try{
				stmt.close（）?;
				stmt?=?null?;
			}catch（Exception?e）{
			}
		}
	}
	
	//把ServerGuest的Fields做成sql語句
	private?void?init（）?throws?SQLException{
		if（guest.getNumber（）?==?ServerGuest.UNDEFINE_INT）?throw?new?SQLException（“InsertUserDB.class::number非法請(qǐng)輸入正確的number“）?;
		
		sb?=?new?StringBuffer（）?;
		//sb.append（“insert?into?user?（numberpasswordnicknameportraitmailrealnamehomepagezipaddresscountryprovinceexplain?genderbirthdayauthregistertimelastlogintimelogintimetotalonlinetimeregisterIPlastloginIP）?values（“）?;
		sb.append（“insert?into?user?values（“）?;
		
//	sb.append（“insert?into?user2（numberpasswordnickname）?values（“）?;
		sb.append（“10?“）?;
		sb.append（guest.getNumber（）?）?;
		sb.append（“?“）?;
		sb.append（doNull（guest.getPassword（）?null））?;
		sb.append（“?“）?;
		sb.append（doNull（guest.getNickname（）““）?）?;
		sb.append（“?“）?;
		sb.append（doNull（guest.getGender（）?-1）?）?;
		sb.append（“?“）?;
		sb.append（doNull（guest.getPortrait（）?0）?）?;
		sb.append（“?“）?;
		sb.append（doNull（guest.getAddress（）?““）?）?;
		sb.append（“?“）?;
		sb.append（doNull（guest.getZip（）?0）?）?;	
		sb.append（“?“）?;
		sb.append（doNull（guest.getCountry（）““）?）?;
		sb.append（“?“）?;
		sb.append（doNull（guest.getProvince（）““）?）?;
		sb.append（“?“）?;		
		sb.append（doNull（guest.getExplain（）““）?）?;	
		sb.append（“?“）?;
		sb.append（doNull（guest.getBirthday（）?null）?）?;	
		sb.append（“?“）?;
		sb.append（doNull（guest.getTelephone（）?““））?;
		sb.append（“?“）?;		
		sb.append（doNull（guest.getHomepage（）““）?）?;
		sb.append（“?“）?;			
		sb.append（doNull（guest.getRealname（）““）?）?;
		sb.append（“?“）?;	
		sb.append（doNull（guest.getMail（）?““）?）?;
		sb.append（“?“）?;
		sb.append（doNull（guest.getAuth（）?mm.smy.bicq.user.Host.ALLOW_ANYONE）?）?

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????525??2012-07-26?17:06??支持多個(gè)登陸?BICQ\.classpath

?????文件????????380??2012-07-26?17:03??支持多個(gè)登陸?BICQ\.project

?????文件????????336??2012-07-26?17:04??支持多個(gè)登陸?BICQ\.settings\.svn\all-wcprops

?????文件????????524??2012-07-26?17:04??支持多個(gè)登陸?BICQ\.settings\.svn\entries

?????文件?????????86??2012-07-26?17:04??支持多個(gè)登陸?BICQ\.settings\.svn\text-base\org.eclipse.core.resources.prefs.svn-base

?????文件????????634??2012-07-26?17:04??支持多個(gè)登陸?BICQ\.settings\.svn\text-base\org.eclipse.jdt.core.prefs.svn-base

?????文件?????????86??2012-07-26?17:04??支持多個(gè)登陸?BICQ\.settings\org.eclipse.core.resources.prefs

?????文件????????634??2012-07-26?17:04??支持多個(gè)登陸?BICQ\.settings\org.eclipse.jdt.core.prefs

?????文件????????742??2012-07-26?17:04??支持多個(gè)登陸?BICQ\.svn\all-wcprops

?????文件?????????38??2012-07-26?17:04??支持多個(gè)登陸?BICQ\.svn\dir-prop-base

?????文件???????1495??2012-07-26?17:04??支持多個(gè)登陸?BICQ\.svn\entries

?????文件?????????53??2012-07-26?16:57??支持多個(gè)登陸?BICQ\.svn\prop-base\symbol.bmp.svn-base

?????文件?????????53??2012-07-26?16:57??支持多個(gè)登陸?BICQ\.svn\prop-base\TrayIcon12.dll.svn-base

?????文件?????????53??2012-07-26?17:04??支持多個(gè)登陸?BICQ\.svn\prop-base\鴿子.ico.svn-base

?????文件????????522??2012-07-26?16:57??支持多個(gè)登陸?BICQ\.svn\text-base\.classpath.svn-base

?????文件????????380??2012-07-26?16:57??支持多個(gè)登陸?BICQ\.svn\text-base\.project.svn-base

?????文件???????9357??2012-07-26?17:04??支持多個(gè)登陸?BICQ\.svn\text-base\BICQ.jcp.svn-base

?????文件????????613??2012-07-26?16:57??支持多個(gè)登陸?BICQ\.svn\text-base\BICQ.jcw.svn-base

?????文件?????????37??2012-07-26?16:57??支持多個(gè)登陸?BICQ\.svn\text-base\server.ini.svn-base

?????文件???????2100??2012-07-26?16:57??支持多個(gè)登陸?BICQ\.svn\text-base\symbol.bmp.svn-base

?????文件??????51200??2012-07-26?16:57??支持多個(gè)登陸?BICQ\.svn\text-base\TrayIcon12.dll.svn-base

?????文件???????5694??2012-07-26?17:04??支持多個(gè)登陸?BICQ\.svn\text-base\鴿子.ico.svn-base

?????文件?????????47??2012-07-31?12:30??支持多個(gè)登陸?BICQ\10001\chatlog.log

?????文件???????1102??2012-07-31?12:30??支持多個(gè)登陸?BICQ\10001\guestgroup.bicq

?????文件????????712??2012-07-31?12:30??支持多個(gè)登陸?BICQ\10001\host.bicq

?????文件??????????0??2012-07-31?12:21??支持多個(gè)登陸?BICQ\10001\permit.bicq

?????文件?????????24??2012-07-31?12:30??支持多個(gè)登陸?BICQ\10002\chatlog.log

?????文件???????1371??2012-07-31?12:30??支持多個(gè)登陸?BICQ\10002\guestgroup.bicq

?????文件????????653??2012-07-31?12:30??支持多個(gè)登陸?BICQ\10002\host.bicq

?????文件??????????0??2012-07-31?12:26??支持多個(gè)登陸?BICQ\10002\permit.bicq

............此處省略1824個(gè)文件信息