flex与数据库交互

通过java与数据库交互读取数据，然后flex和java再进行交互，把java读取的数据放在flex前端显示出来。

1）首先建立数据库：

① 打开cmd终端：
view plaincopy to clipboardprint?
mysql -h localhost -u root -p
mysql -h localhost -u root -p
，按提示输入密码(我用的root)。

② 建立数据库：

view plaincopy to clipboardprint?
create database user;
use user;
create database user;
use user;

③ 建立数据表userInfo：

view plaincopy to clipboardprint?
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
`userId` int(10) unsigned zerofill NOT NULL auto_increment,
`userName` varchar(30) NOT NULL,
`userPasswd` varchar(16) NOT NULL,
PRIMARY KEY (`userId`)
) DEFAULT CHARSET=utf8;
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
`userId` int(10) unsigned zerofill NOT NULL auto_increment,
`userName` varchar(30) NOT NULL,
`userPasswd` varchar(16) NOT NULL,
PRIMARY KEY (`userId`)
) DEFAULT CHARSET=utf8;

2）创建javaDao。

① 创建User类

view plaincopy to clipboardprint?
public class User {
private String name;
　　 public String getName(){
return name;
}
public void setName(String name){
this.name=name;
}
}
public class User {
private String name;
　　 public String getName(){
return name;
}
public void setName(String name){
this.name=name;
}
}

② 创建DAO类

view plaincopy to clipboardprint?UserDao.java import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; public class UserDao{ public static Connection getConnection(){ Connection onnection=null; try{ String driver="com.mysql.jdbc.Driver"; String url="jdbc:mysql://localhost:3306/user"; String username="root"; String password="root"; Class.forName(driver); onnection=DriverManager.getConnection(url,username,password); }catch(Exception e){ System.out.println(e.getMessage()); } return onnection; } public List getAllUser()throws SQLException{ Connection connection=getConnection(); Statement st=onnection.createStatement(); ResultSet rs=st.executeQuery("select * from userInfo"); ArrayList userList=new ArrayList<User>(); while(rs.next()){ User u=new User(); u.setName(rs.getString("name")); userList.add(u); } return userList; } } UserDao.java
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class UserDao{
public static Connection getConnection(){
Connection onnection=null;
try{
String driver="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/user";
String username="root";
String password="root";
Class.forName(driver);
onnection=DriverManager.getConnection(url,username,password);
}catch(Exception e){
System.out.println(e.getMessage());
}
return onnection;
}
public List getAllUser()throws SQLException{
Connection connection=getConnection();
Statement st=onnection.createStatement();
ResultSet rs=st.executeQuery("select * from userInfo");
ArrayList userList=new ArrayList<User>();
while(rs.next()){
User u=new User();
u.setName(rs.getString("name"));
userList.add(u);
}
return userList;
}
}

3） flex代码

① User类

view plaincopy to clipboardprint?User.aspackage org.rjb.flex{ [RemoteClass(alias="java.User")] public class User{ private var _name:String; public function User(){} public function get name():String{ return this._name; } public function set name(name:String):void{ this._name=name; } } } User.aspackage org.rjb.flex{
[RemoteClass(alias="java.User")]
public class User{
private var _name:String;
public function User(){}

public function get name():String{
return this._name;
}
public function set name(name:String):void{
this._name=name;
}
}
}

②user.mxml文件

view plaincopy to clipboardprint?
<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="vertical">
<mx:RemoteObject id="ud" destination="UserDao" result="onResult(event)" fault="onFault()" />
<mx:DataGrid dataProvider="{users}">
<mx:columns>
<mx:DataGridColumn dataField="name" headerText="name" />
</mx:columns>
</mx:DataGrid>
<mx:Label id="info" />
<mx:Button label="click" click="clickFun()" />
<mx:Script>
<!--[CDATA[
import mx.collections.ArrayCollection;
import mx.rpc.events.ResultEvent;
[Bindable]
public var users:ArrayCollection=new ArrayCollection();
public function clickFun():void{
ud.getAllUser();
}
public function onResult(event:ResultEvent):void{
users=ArrayCollection(event.result);
info.text="get data successfully";
}
public function onFault():void{
info.text="Error";
}
]]-->
</mx:Script>
</mx:Application>
<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="vertical">
<mx:RemoteObject id="ud" destination="UserDao" result="onResult(event)" fault="onFault()" />
<mx:DataGrid dataProvider="{users}">
<mx:columns>
<mx:DataGridColumn dataField="name" headerText="name" />
</mx:columns>
</mx:DataGrid>
<mx:Label id="info" />
<mx:Button label="click" click="clickFun()" />
<mx:Script>
<!--[CDATA[
import mx.collections.ArrayCollection;
import mx.rpc.events.ResultEvent;
[Bindable]
public var users:ArrayCollection=new ArrayCollection();
public function clickFun():void{
ud.getAllUser();
}
public function onResult(event:ResultEvent):void{
users=ArrayCollection(event.result);
info.text="get data successfully";
}
public function onFault():void{
info.text="Error";
}
]]-->
</mx:Script>
</mx:Application>

③配置remoting-config.xml，在里面加上如下配置文件：

view plaincopy to clipboardprint?<destination id="UserDao"> <properties> <source>UserDao</source> </properties> </destination>