package?com.chongmeng.oa.dao;

import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.SQLException;

import?com.chongmeng.oa.pojo.Userinfo;
import?com.chongmeng.oa.util.SQLConnection;

public?class?Adduser?{
	public?boolean?addUser（Userinfo?userinfo）{
		//定義
		String?sql?=?“insert?into?t_user（u_name?u_passwordu_sexu_phoneu_emailu_possied_name）?values（???????）“;
		PreparedStatement?pre?=?null;
		Connection?conn?=?null;
		//獲取封裝信息
		String?username?=?userinfo.getU_name（）;	
		String?usersex?=?userinfo.getU_sex（）;
		String?userpwd?=?userinfo.getU_password（）;
		String?userdept?=?userinfo.getD_name（）;
		String?userzhiwei?=?userinfo.getU_possie（）;
		String?userphone?=?userinfo.getU_phone（）;
		String?usermail?=?userinfo.getU_email（）;
		//獲取數(shù)據(jù)庫連接
		conn?=?SQLConnection.getConnection（）;
		
		try?{
			//獲取執(zhí)行sql語句的對(duì)象
			pre?=?conn.prepareStatement（sql）;
			//給sql語句賦值
			pre.setString（1?username）;
			pre.setString（2?userpwd）;
			pre.setString（3?usersex）;
			pre.setString（4?userphone）;
			pre.setString（5?usermail）;
			pre.setString（6?userzhiwei）;
			pre.setString（7?userdept）;
			//執(zhí)行sql語句
			int?i?=?pre.executeUpdate（）;
			if（i?==?1）{
				System.out.println（“添加員工成功“）;
			}
			return?true;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		
		return?false;
		
	}

}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-06-15?19:31??新建文件夾\
?????目錄???????????0??2015-06-15?19:28??新建文件夾\Oa\
?????文件??????470034??2015-06-15?19:29??新建文件夾\oa.doc
?????文件????????2890??2014-12-18?23:23??新建文件夾\Oa\.classpath
?????目錄???????????0??2014-12-15?20:41??新建文件夾\Oa\.myeclipse\
?????文件?????????300??2014-12-18?08:26??新建文件夾\Oa\.mymetadata
?????文件????????1752??2014-12-28?21:57??新建文件夾\Oa\.project
?????目錄???????????0??2015-06-15?19:28??新建文件夾\Oa\.settings\
?????文件?????????522??2014-12-18?22:09??新建文件夾\Oa\.settings\.jsdtscope
?????文件?????????382??2014-12-18?22:09??新建文件夾\Oa\.settings\com.genuitec.eclipse.migration.prefs
?????文件??????????84??2014-12-28?14:59??新建文件夾\Oa\.settings\org.eclipse.core.resources.prefs
?????文件?????????334??2009-11-16?08:09??新建文件夾\Oa\.settings\org.eclipse.jdt.core.prefs
?????文件?????????555??2014-12-18?22:09??新建文件夾\Oa\.settings\org.eclipse.wst.common.component
?????文件?????????413??2014-12-18?22:09??新建文件夾\Oa\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2014-12-18?22:09??新建文件夾\Oa\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2014-12-18?22:09??新建文件夾\Oa\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2015-06-15?19:28??新建文件夾\Oa\bin\
?????文件????????1752??2014-12-28?21:57??新建文件夾\Oa\bin\.project
?????目錄???????????0??2015-06-15?19:28??新建文件夾\Oa\bin\WebRoot\
?????目錄???????????0??2014-12-28?21:57??新建文件夾\Oa\bin\WebRoot\caozuo\
?????目錄???????????0??2015-06-15?19:28??新建文件夾\Oa\bin\WebRoot\chaojiguanli\
?????目錄???????????0??2014-12-28?21:57??新建文件夾\Oa\bin\WebRoot\chaojiguanli\dept\
?????目錄???????????0??2014-12-28?21:57??新建文件夾\Oa\bin\WebRoot\chaojiguanli\houtai\
?????目錄???????????0??2014-12-28?21:57??新建文件夾\Oa\bin\WebRoot\css\
?????目錄???????????0??2014-12-28?21:57??新建文件夾\Oa\bin\WebRoot\gerenxinxi\
?????目錄???????????0??2014-12-28?21:57??新建文件夾\Oa\bin\WebRoot\gonggaoguanli\
?????目錄???????????0??2014-12-28?21:57??新建文件夾\Oa\bin\WebRoot\img\
?????目錄???????????0??2015-06-15?19:28??新建文件夾\Oa\bin\WebRoot\jihuaguanli\
?????目錄???????????0??2014-12-28?21:57??新建文件夾\Oa\bin\WebRoot\jihuaguanli\plan\
?????目錄???????????0??2015-06-15?19:28??新建文件夾\Oa\bin\WebRoot\Login\
?????目錄???????????0??2014-12-28?21:57??新建文件夾\Oa\bin\WebRoot\Login\imgs\
............此處省略276個(gè)文件信息