Flex + MySQL + Tomcat 小例子

环境

1.服务器:Tomcat

2.数据库:MySQL

3.IDE:Eclipse+FlexBuilder插件

前期准备

1.MySQL里新建数据库,命名test

2.新建表,命名:person,脚本如下:

CREATE TABLE `te_person` ( `id` VARCHAR(20) COLLATE utf8_general_ci NOT NULL DEFAULT '', `name` VARCHAR(20) COLLATE utf8_general_ci NOT NULL DEFAULT '', `sex` INTEGER(2) DEFAULT NULL, `content` TEXT COLLATE utf8_general_ci, PRIMARY KEY (`id`))ENGINE=InnoDBCHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

3.任意插入两条记录即可

步骤

1.新建Flex Project工程,命名:FlexSample

2.在src下新建包,命名:test

3.在test包下新建类,命名:HelloWorld(源码在文章下方)

4.在flex_src下新建MXML APPLICATION文件,命名:Hello.mxml(源码在文章下方)

5.在web.xml里增加一段代码(源码在文章下方)

测试

1.启动Tomcat

2.右键单击Hello.mxml, ->run as Flex Application

运行效果如下图

 

源码

1. HelloWorld.java

package test;import java.io.IOException;import java.io.PrintWriter;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.mysql.jdbc.Connection;import com.mysql.jdbc.Statement;public class HelloWorld extends HttpServlet {private static final long serialVersionUID = 1L;String driver = "com.mysql.jdbc.Driver";String url = "jdbc:mysql://localhost:3306/test";String user = "root";String password = "root";Statement stmt = null;Connection con = null;public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {this.doPost(request, response);}public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {response.setContentType("text/xml;charset=utf-8");response.setHeader("Cache-Control", "no-cache");String content = "";try {Class.forName(driver);} catch (Exception e) {System.out.println("无法加载驱动程序" + driver);}try {con = (Connection) DriverManager.getConnection(url, user, password);con.setAutoCommit(false);stmt = (Statement) con.createStatement();String querySql = "select * from te_person";ResultSet result = stmt.executeQuery(querySql);while (result.next()) {String personName = result.getString("name");int sex = result.getInt("sex");String sexy;if (sex == 0) {sexy = "男";} else {sexy = "女";}String personContent = result.getString("content");content += "<person><name>" + personName + "</name><sex>"+ sexy + "</sex><content>" + personContent+ "</content></person>";}content="<?xml version=/"1.0/" encoding=/"utf-8/"?><persons>"+content+"</persons>";System.out.println("content:" + content);PrintWriter writer = response.getWriter();writer.write(content);writer.close();stmt.close();con.close();} catch (SQLException ee) {System.out.println("数据库连接失败");} finally {try {if (!con.isClosed()) {stmt.close();con.close();}} catch (SQLException e) {System.out.print("数据库关闭连接失败");}}}}

2.Hello.mxml

<?xml version="1.0" encoding="utf-8"?><mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" creationComplete="feedRequest.send()" > <mx:HTTPService id="feedRequest" url="http://localhost:8080/FlexSample/helloWorld" useProxy="false" /> <mx:Panel x="10" y="10" width="475" height="400" layout="absolute" title="{dgPosts.selectedItem.name}" color="#1C06F6" fontSize="16"> <mx:DataGrid x="20" y="20" id="dgPosts" width="400" dataProvider="{feedRequest.lastResult.persons.person}" fontFamily="Times New Roman" fontSize="16"> <mx:columns> <mx:DataGridColumn headerText="Name" dataField="name"/> <mx:DataGridColumn headerText="Sex" dataField="sex"/> <mx:DataGridColumn headerText="Content" dataField="content"/> </mx:columns> </mx:DataGrid> </mx:Panel></mx:Application> http://p.blog.csdn.net/images/p_blog_csdn_net/wozeze1/EntryImages/20090603/flexsample.jpg

3.web.xml

<servlet> <display-name>helloWorld</display-name> <servlet-name>helloWorld</servlet-name> <servlet-class>test.HelloWorld</servlet-class> </servlet> <servlet-mapping> <servlet-name>helloWorld</servlet-name> <url-pattern>/helloWorld</url-pattern> </servlet-mapping>