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數(shù)據(jù)庫
?*?
?*?@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數(shù)據(jù)庫中user表的數(shù)據(jù)
	?*?
	?*?@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“）;
		//?數(shù)據(jù)庫名稱
		String?dbName?=?“FTGJUvPHrbXsLGsYpwlp“;
		//?JDBC?URL
		String?url?=?String.format（“jdbc:mysql://%s:%s/%s“?host?port?dbName）;

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

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

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

?????文件???????1245??2013-10-15?01:18??chapter-05\.classpath

?????文件????????303??2014-01-20?11:38??chapter-05\.mymetadata

?????文件???????1228??2013-10-17?23:11??chapter-05\.project

?????文件????????544??2013-10-17?23:24??chapter-05\src\log4j.properties

?????文件????????270??2013-10-17?12:08??chapter-05\src\org\liufeng\course\menu\Button.java

?????文件????????423??2013-10-17?12:08??chapter-05\src\org\liufeng\course\menu\ClickButton.java

?????文件????????344??2013-10-17?12:08??chapter-05\src\org\liufeng\course\menu\ComplexButton.java

?????文件????????282??2013-10-17?12:08??chapter-05\src\org\liufeng\course\menu\Menu.java

?????文件????????421??2013-10-17?12:08??chapter-05\src\org\liufeng\course\menu\ViewButton.java

?????文件???????1068??2013-11-04?01:12??chapter-05\src\org\liufeng\course\message\event\baseEvent.java

?????文件????????721??2013-11-04?02:49??chapter-05\src\org\liufeng\course\message\event\LocationEvent.java

?????文件????????371??2013-11-04?02:51??chapter-05\src\org\liufeng\course\message\event\MenuEvent.java

?????文件????????520??2013-11-04?02:41??chapter-05\src\org\liufeng\course\message\event\QRCodeEvent.java

?????文件????????177??2013-11-04?02:25??chapter-05\src\org\liufeng\course\message\event\SubscribeEvent.java

?????文件???????1098??2013-11-02?18:04??chapter-05\src\org\liufeng\course\message\req\baseMessage.java

?????文件????????324??2013-09-11?01:38??chapter-05\src\org\liufeng\course\message\req\ImageMessage.java

?????文件????????650??2013-09-11?02:32??chapter-05\src\org\liufeng\course\message\req\linkMessage.java

?????文件????????869??2013-09-11?01:49??chapter-05\src\org\liufeng\course\message\req\LocationMessage.java

?????文件????????330??2013-09-11?01:26??chapter-05\src\org\liufeng\course\message\req\TextMessage.java

?????文件????????553??2013-11-02?15:55??chapter-05\src\org\liufeng\course\message\req\VideoMessage.java

?????文件????????698??2013-11-02?17:42??chapter-05\src\org\liufeng\course\message\req\VoiceMessage.java

?????文件????????930??2013-09-11?17:00??chapter-05\src\org\liufeng\course\message\resp\Article.java

?????文件????????942??2013-11-02?18:05??chapter-05\src\org\liufeng\course\message\resp\baseMessage.java

?????文件????????308??2013-11-02?16:55??chapter-05\src\org\liufeng\course\message\resp\Image.java

?????文件????????311??2013-11-02?16:59??chapter-05\src\org\liufeng\course\message\resp\ImageMessage.java

?????文件???????1119??2013-11-02?17:17??chapter-05\src\org\liufeng\course\message\resp\Music.java

?????文件????????311??2013-09-11?13:19??chapter-05\src\org\liufeng\course\message\resp\MusicMessage.java

?????文件????????628??2013-09-11?17:00??chapter-05\src\org\liufeng\course\message\resp\NewsMessage.java

?????文件????????337??2013-09-11?12:00??chapter-05\src\org\liufeng\course\message\resp\TextMessage.java

?????文件????????516??2013-11-02?16:57??chapter-05\src\org\liufeng\course\message\resp\Video.java

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