package?org.liufeng.course.servlet;

import?java.io.IOException;
import?java.io.PrintWriter;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.util.ArrayList;
import?java.util.HashMap;
import?java.util.List;
import?javax.servlet.ServletException;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

/**
?*?示例：使用JDBC操作BAE中的MySQL數據庫
?*?
?*?@author?liufeng
?*?@date?2013-11-18
?*/
public?class?UserServlet?extends?HttpServlet?{
	private?static?final?long?serialVersionUID?=?1196941092414541883L;

	public?void?doGet（HttpServletRequest?request?HttpServletResponse?response）?throws?ServletException?IOException?{
		request.setCharacterEncoding（“gb2312“）;
		response.setCharacterEncoding（“gb2312“）;

		PrintWriter?out?=?response.getWriter（）;
		//?查詢user
		Listject>>?userList?=?queryUser（request）;
		//?遍歷List集合
		for?（HashMapject>?map?:?userList）?{
			out.println（map.get（“name“）?+?“?“?+?map.get（“age“））;
		}
		out.flush（）;
		out.close（）;
	}

	/**
	?*?查詢BAE?MySQL數據庫中user表的數據
	?*?
	?*?@param?request
	?*?@return
	?*/
	private?static?Listject>>?queryUser（HttpServletRequest?request）?{
		Listject>>?userList?=?new?ArrayListject>>（）;

		//?從request請求頭中取出IP、端口、用戶名和密碼
		String?host?=?request.getHeader（“BAE_ENV_ADDR_SQL_IP“）;
		String?port?=?request.getHeader（“BAE_ENV_ADDR_SQL_PORT“）;
		String?username?=?request.getHeader（“BAE_ENV_AK“）;
		String?password?=?request.getHeader（“BAE_ENV_SK“）;
		//?數據庫名稱
		String?dbName?=?“FTGJUvPHrbXsLGsYpwlp“;
		//?JDBC?URL
		String?url?=?String.format（“jdbc:mysql://%s:%s/%s“?host?port?dbName）;

		try?{
			//?加載MySQL驅動
			Class.forName（“com.mysql.jdbc.Driver“）;
			//?獲取數據庫連接
			Connection?conn?=?DriverManager.getConnection（url?username?password）;
			//?定義查詢SQL語句
			String?sql?=?“select?nameage?from?user“;
			//?創建PreparedStatement對象（包含已編譯的SQL語句）
			PreparedStatement?ps?=?conn.prepareStatement（sql）;
			//?執行查詢并獲取結果集
			ResultSet?rs?=?ps.executeQuery（）;
			//?遍歷查詢結果集
			while?（rs.next（））?{
				HashMapject>?userMap?=?new?HashMapject>（）;
				userMap.put（“name“?rs.getString（“name“））;
				userMap.put（“age“?rs.getInt（“age“））;
				userList.add（userMap）;
			}

			//?關閉連接，釋放資源
			rs.close（）;
			ps.close（）;
			conn.close（）;
		}?catch?（Exception?e）?{
			e.printStackTrace（）;
		}
		return?userList;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-05-16?00:08??baemysql\
?????文件?????????362??2013-11-18?20:29??baemysql\.classpath
?????文件?????????297??2014-01-20?11:39??baemysql\.mymetadata
?????文件????????1226??2013-11-18?20:57??baemysql\.project
?????目錄???????????0??2015-05-16?00:08??baemysql\WebRoot\
?????目錄???????????0??2015-05-16?00:08??baemysql\WebRoot\meta-INF\
?????文件??????????39??2013-11-18?20:29??baemysql\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2015-05-16?00:08??baemysql\WebRoot\WEB-INF\
?????目錄???????????0??2015-05-16?00:08??baemysql\WebRoot\WEB-INF\classes\
?????目錄???????????0??2015-05-16?00:08??baemysql\WebRoot\WEB-INF\classes\org\
?????目錄???????????0??2015-05-16?00:08??baemysql\WebRoot\WEB-INF\classes\org\liufeng\
?????目錄???????????0??2015-05-16?00:08??baemysql\WebRoot\WEB-INF\classes\org\liufeng\course\
?????目錄???????????0??2015-05-16?00:08??baemysql\WebRoot\WEB-INF\classes\org\liufeng\course\servlet\
?????文件????????4230??2014-01-09?20:58??baemysql\WebRoot\WEB-INF\classes\org\liufeng\course\servlet\UserServlet.class
?????目錄???????????0??2015-05-21?15:43??baemysql\WebRoot\WEB-INF\lib\
?????文件?????????653??2013-11-18?20:56??baemysql\WebRoot\WEB-INF\web.xml
?????文件?????????834??2013-11-18?20:29??baemysql\WebRoot\index.jsp
?????目錄???????????0??2015-05-16?00:08??baemysql\src\
?????目錄???????????0??2015-05-16?00:08??baemysql\src\org\
?????目錄???????????0??2015-05-16?00:08??baemysql\src\org\liufeng\
?????目錄???????????0??2015-05-16?00:08??baemysql\src\org\liufeng\course\
?????目錄???????????0??2015-05-16?00:08??baemysql\src\org\liufeng\course\servlet\
?????文件????????2707??2013-12-08?20:09??baemysql\src\org\liufeng\course\servlet\UserServlet.java
?????目錄???????????0??2015-05-16?00:08??chapter-03\
?????文件?????????362??2013-09-01?19:34??chapter-03\.classpath
?????文件?????????303??2014-01-20?11:38??chapter-03\.mymetadata
?????文件????????1228??2013-09-02?00:36??chapter-03\.project
?????目錄???????????0??2015-05-16?00:08??chapter-03\WebRoot\
?????目錄???????????0??2015-05-16?00:08??chapter-03\WebRoot\meta-INF\
?????文件??????????39??2013-09-01?19:34??chapter-03\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2015-05-16?00:08??chapter-03\WebRoot\WEB-INF\
............此處省略801個文件信息