package?com.starting.jdbc;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;

import?com.starting.user.Admin;
import?com.starting.user.BeanFormatDateTime;
import?com.starting.user.Cargo;
import?com.starting.user.Driver;
import?com.starting.user.User;

public?class?OAManager?{
	String?url?=?“jdbc:mysql://localhost:3306/cargo“;
	Connection?con?=?null;
	ResultSet?rs?=?null;
	PreparedStatement?stmt;

	public?OAManager（）?{
		try?{
			Class.forName（“org.gjt.mm.mysql.Driver“）;
		}?catch?（ClassNotFoundException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}

	}

	public?Connection?getCon（）?{
		try?{
			con?=?DriverManager.getConnection（url?“root“?“1234“）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?con;
	}

	public?boolean?insertUser（String?username?String?add?String?pwd
			String?company?String?email?String?tel?String?zip?String?name
			String?time?String?lasttime?int?LoginTimes）?{
		String?usersql?=?“insert?user?（userLoginNameuserLoginPwduserNameuserCompany“
				+?“userPhoneuserAddressuserEmailuserZip“
				+?“userRegDateuserLastDateLoginTimes）“
				+?“?values（???????????）“;
		PreparedStatement?stmt?=?null;
		Connection?conn?=?null;

		try?{
			conn?=?this.getCon（）;
			stmt?=?conn.prepareStatement（usersql）;
			stmt.setString（1?username）;
			stmt.setString（2?pwd）;
			stmt.setString（3?name）;
			stmt.setString（4?company）;
			stmt.setString（5?tel）;
			stmt.setString（6?add）;
			stmt.setString（7?email）;
			stmt.setString（8?zip）;
			stmt.setString（9?time）;
			stmt.setString（10?lasttime）;
			stmt.setInt（11?LoginTimes）;
			int?num?=?stmt.executeUpdate（）;
			System.out.println（“更新成功?num?=?“?+?num）;
			return?true;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?false;
	}

	public?boolean?insertDriverInfo（String?linkMan?String?linkPhone
			String?carType?String?startAdd?String?endAdd?String?linkEmail
			String?message）?{

		String?usersql?=?“insert?driver?（linkManlinkPhonecarTypestartAdd“
				+?“endAddlinkEmailmessage）“?+?“values（???????）“;
		PreparedStatement?stmt?=?null;
		Connection?conn?=?null;

		try?{
			conn?=?this.getCon（）;
			stmt?=?conn.prepareStatement（usersql）;
			stmt.setString（1?linkMan）;
			stmt.setString（2?linkPhone）;
			stmt.setString（3?carType）;
			stmt.setString（4?startAdd）;
			stmt.setString（5?endAdd）;
			stmt.setString（6?linkEmail）;
			stmt.setString（7?message）;
			int?num?=?stmt.executeUpdate（）;
			System.out.println（“更新成功?num?=?“?+?num）;
			return?true;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		return?false;

	}

	public?User?login（String?username?Stri

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-02-28?15:27??cargotrans\
?????文件?????????845??2011-02-13?19:29??cargotrans\.classpath
?????文件????????1043??2011-02-13?18:41??cargotrans\.project
?????目錄???????????0??2012-02-28?15:27??cargotrans\.settings\
?????文件?????????454??2011-02-13?19:29??cargotrans\.settings\.jsdtscope
?????文件?????????244??2011-02-13?20:41??cargotrans\.settings\org.eclipse.core.resources.prefs
?????文件?????????330??2011-02-13?19:29??cargotrans\.settings\org.eclipse.jdt.core.prefs
?????文件?????????426??2011-02-13?19:29??cargotrans\.settings\org.eclipse.wst.common.component
?????文件?????????320??2011-02-13?19:29??cargotrans\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2011-02-13?19:29??cargotrans\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2011-02-13?19:29??cargotrans\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2012-02-28?15:27??cargotrans\WebContent\
?????文件?????????621??2011-02-13?19:57??cargotrans\WebContent\AdminErrorNotice.jsp
?????文件?????????772??2011-02-13?19:57??cargotrans\WebContent\AdminWarningPage.jsp
?????文件?????????625??2011-02-13?19:57??cargotrans\WebContent\ClientServer.jsp
?????文件?????????615??2011-02-13?19:57??cargotrans\WebContent\ErrorNotice.jsp
?????文件?????????611??2011-02-13?19:57??cargotrans\WebContent\FirstLoading.jsp
?????文件?????????674??2011-02-13?20:20??cargotrans\WebContent\FirstPage.jsp
?????目錄???????????0??2012-02-28?15:27??cargotrans\WebContent\meta-INF\
?????文件??????????39??2011-02-13?19:57??cargotrans\WebContent\meta-INF\MANIFEST.MF
?????文件????????2384??2011-02-13?22:34??cargotrans\WebContent\ModifyCargoInfo.jsp
?????文件?????????632??2011-02-13?19:57??cargotrans\WebContent\NoticePoint.jsp
?????文件?????????615??2011-02-13?19:57??cargotrans\WebContent\SendFailNotice.jsp
?????文件?????????536??2011-02-13?19:57??cargotrans\WebContent\SendNotice.jsp
?????文件?????????579??2011-02-13?19:57??cargotrans\WebContent\SendSuccessNotice.jsp
?????文件????????1557??2011-02-13?19:57??cargotrans\WebContent\ShowAllCargo.jsp
?????文件????????1646??2011-02-13?22:22??cargotrans\WebContent\ShowAllCargo_first.jsp
?????文件?????????972??2011-02-13?19:57??cargotrans\WebContent\ShowAllDriver.jsp
?????文件????????1307??2011-02-13?22:37??cargotrans\WebContent\ShowCargoDetailedInfo.jsp
?????文件????????2380??2011-02-13?22:33??cargotrans\WebContent\ShowCargoselfDetailedInfo.jsp
?????目錄???????????0??2012-02-28?15:27??cargotrans\WebContent\WEB-INF\
............此處省略91個文件信息