微信公众号开发源代码大全2015 java版本

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  baemysqlWebRoot
     目录           0  2015-05-16 00:08  baemysqlWebRootmeta-INF
     文件          39  2013-11-18 20:29  baemysqlWebRootmeta-INFMANIFEST.MF
     目录           0  2015-05-16 00:08  baemysqlWebRootWEB-INF
     目录           0  2015-05-16 00:08  baemysqlWebRootWEB-INFclasses
     目录           0  2015-05-16 00:08  baemysqlWebRootWEB-INFclassesorg
     目录           0  2015-05-16 00:08  baemysqlWebRootWEB-INFclassesorgliufeng
     目录           0  2015-05-16 00:08  baemysqlWebRootWEB-INFclassesorgliufengcourse
     目录           0  2015-05-16 00:08  baemysqlWebRootWEB-INFclassesorgliufengcourseservlet
     文件        4230  2014-01-09 20:58  baemysqlWebRootWEB-INFclassesorgliufengcourseservletUserServlet.class
     目录           0  2015-05-21 15:43  baemysqlWebRootWEB-INFlib
     文件         653  2013-11-18 20:56  baemysqlWebRootWEB-INFweb.xml
     文件         834  2013-11-18 20:29  baemysqlWebRootindex.jsp
     目录           0  2015-05-16 00:08  baemysqlsrc
     目录           0  2015-05-16 00:08  baemysqlsrcorg
     目录           0  2015-05-16 00:08  baemysqlsrcorgliufeng
     目录           0  2015-05-16 00:08  baemysqlsrcorgliufengcourse
     目录           0  2015-05-16 00:08  baemysqlsrcorgliufengcourseservlet
     文件        2707  2013-12-08 20:09  baemysqlsrcorgliufengcourseservletUserServlet.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-03WebRoot
     目录           0  2015-05-16 00:08  chapter-03WebRootmeta-INF
     文件          39  2013-09-01 19:34  chapter-03WebRootmeta-INFMANIFEST.MF
     目录           0  2015-05-16 00:08  chapter-03WebRootWEB-INF
............此处省略801个文件信息