package?bean;

import?java.sql.Connection;
import?java.sql.DriverManager;

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

public?class?Admin?{

	public?int?id;
	String?adminuser;
	String?adminpassword;
	String?authority;
	public?Admin（）
	{
		id=1;
		adminuser=““;
		adminpassword=““;
		authority=““;
	}
	public?int?getId（）
	{
	return?id;
	}
	public?void?setId（int?id）
	{
	this.id=id;
	}
	public?void?setAdminuser（String?adminuser）
	{
		this.adminuser=adminuser;
	}
	public?String?getAdminuser（）
	{
		return?adminuser;
	}
	public?void?setAdminpassword（String?adminpassword）
	{
		this.adminpassword=adminpassword;
	}
	public?String?getAdminpassword（）
	{
		return?adminpassword;
	}
	public?void?setAuthority（String?authority）
	{
		this.authority=authority;
	}
	public?String?getAuthority（）
	{
		return?authority;
	}
	public?void?insert（）
	{
		String?sDBDriver?=?“com.microsoft.jdbc.sqlserver.SQLServerDriver“;
		String?url?=
			“jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=oa“;
		//pubs為你的數據庫的????

		Connection?conn?=?null;
		Statement?stmt?=?null;
		String?sql=“insert?into?admin?（idadminuseradminpassauthority）?values?（“;sql=sql+id;sql=sql+“‘“+adminuser;sql=sql+“‘‘“+adminpassword+“‘‘“;sql=sql+authority+“‘）“;
		System.out.print（sql）;
			try?{
				Class.forName（sDBDriver）;
			}?catch?（java.lang.ClassNotFoundException?e）?{
				System.err.println（“sql_data（）:?“?+?e.getMessage（））;
			}
			try?{
				//conn?=?DriverManager.getConnection（urluserpassword）;
				conn?=?DriverManager.getConnection（url“sa“““）;
				stmt?=?conn.createStatement（）;
				stmt.executeUpdate（sql）;
				stmt.close（）;
				conn.close（）;
			}?catch?（SQLException?ex）?{
				System.err.println（“sql_data.executeUpdate:“?+?ex.getMessage（））;
			}
	}
	public?static?void?main（String[]?args）?{
		//?TODO?Auto-generated?method?stub

	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????552??2007-03-28?09:17??eoa\eoa\.classpath

?????文件????????282??2007-06-25?21:37??eoa\eoa\.mymetadata

?????文件???????1343??2006-07-24?20:29??eoa\eoa\.project

?????文件????????677??2004-11-06?22:39??eoa\eoa\WebRoot\.classpath

?????文件??????????4??2004-11-06?22:34??eoa\eoa\WebRoot\.cvsignore

?????文件????????443??2004-11-06?22:34??eoa\eoa\WebRoot\.project

?????文件????????359??2004-11-06?22:34??eoa\eoa\WebRoot\.tomcatplugin

?????文件????????706??2007-06-25?21:37??eoa\eoa\WebRoot\bottom.jsp

?????文件???????5112??2007-06-25?21:37??eoa\eoa\WebRoot\default.jsp

?????文件????????531??2004-09-23?14:16??eoa\eoa\WebRoot\headbottom.jsp

?????文件????????996??2007-03-27?09:55??eoa\eoa\WebRoot\header.jsp

?????文件???????3385??2004-09-08?16:58??eoa\eoa\WebRoot\hot.jsp

?????文件??????11705??2007-03-30?21:20??eoa\eoa\WebRoot\index.jsp

?????文件???????9312??2007-06-25?21:37??eoa\eoa\WebRoot\list.jsp

?????文件???????3388??2004-09-08?16:58??eoa\eoa\WebRoot\new.jsp

?????文件???????4077??2004-09-08?16:22??eoa\eoa\WebRoot\newstyle.css

?????文件????????438??2004-06-03?21:54??eoa\eoa\WebRoot\sample.jsp

?????文件???????4904??2006-07-24?20:46??eoa\eoa\WebRoot\search.jsp

?????文件????????392??2004-06-03?21:55??eoa\eoa\WebRoot\shop.htm

?????文件????????657??2006-07-29?22:13??eoa\eoa\WebRoot\shop.jsp

?????文件???????2728??2007-03-26?20:51??eoa\eoa\WebRoot\show.jsp

?????文件???????2090??2006-07-29?08:21??eoa\eoa\WebRoot\show2.jsp

?????目錄??????????0??2007-05-17?20:35??eoa\eoa\WebRoot\work\org\apache\jsp

?????目錄??????????0??2007-05-17?20:35??eoa\eoa\WebRoot\work\org\apache

?????目錄??????????0??2007-05-17?20:35??eoa\eoa\WebRoot\work\org

?????目錄??????????0??2007-05-17?20:35??eoa\eoa\WebRoot\work

?????文件??????????7??2004-11-06?22:34??eoa\eoa\WebRoot\WEB-INF\.cvsignore

?????文件????????286??2006-07-24?20:23??eoa\eoa\WebRoot\WEB-INF\web.xml

?????文件????????351??2004-11-06?22:32??eoa\eoa\WebRoot\WEB-INF\src\.classpath

?????文件????????384??2004-11-06?22:32??eoa\eoa\WebRoot\WEB-INF\src\.project

............此處省略126個文件信息