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=InnoDB CHARACTER 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> https://p-blog.youkuaiyun.com/images/p_blog_youkuaiyun.com/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>