我用的openamf做flashremoting服務器是沒問題的!這是as的代碼!package{importflash.display.Sprite;importflash.net.ObjectEncoding;importcom.riafan.remoting.PendingCall;import...
我用的openamf做flash remoting服務器是沒問題的!
這是as的代碼!
package {
import flash.display.Sprite;
import flash.net.ObjectEncoding;
import com.riafan.remoting.PendingCall;
import com.riafan.remoting.Service;
import com.riafan.rpc.FaultEvent;
import com.riafan.rpc.ResultEvent;
/**
* Flash Remoting ActionScript 3.0
* @author Flying
*/
public class Main extends Sprite {
public function Main() {
//創建遠程服務
var service : Service = new Service("tutorials.remoting.insect.src.insect.test.testMysql",
"http://localhost:8080/flashService/gateway",
ObjectEncoding.AMF3);
//調用遠程方法
var rpc : PendingCall = service.TestObject();
//注冊調用成功的事件偵聽器對象
rpc.addEventListener(ResultEvent.RESULT, successHandler);
//注冊調用成功失敗的偵聽器對象
rpc.addEventListener(FaultEvent.FAULT, faultHandler);
}
//聲明處理調用成功的偵聽器函數
private function successHandler( re : ResultEvent ) : void {
// 您好,Flying。這是來自Fluorine Flash remoting的問候
trace("success");
trace(re.result);
}
//聲明處理調用失敗的偵聽器函數
private function faultHandler( fe : FaultEvent ) : void {
trace(fe.fault.description);
}
}
}
這是java的程序
package tutorials.remoting.insect.src.insect.test;
import java.sql.*;
import java.util.*;
public class testMysql {
public static void main(String[] args){
TestObject();
System.out.println(TestObject());
}
public static List TestObject() {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
List list = new ArrayList();
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection
("jdbc:mysql://localhost/insectdata?user=root&password=insect");
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from level where id = 1");
while (rs.next()) {
Map data = new HashMap();
data.put("等級", rs.getInt("crtlevel"));
data.put("金錢", rs.getString("money"));
data.put("經驗", rs.getInt("experience"));
list.add(data);
}
//System.out.println(list);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
} finally {
try {
if(rs != null) {
rs.close();
rs = null;
}
if(stmt != null) {
stmt.close();
stmt = null;
}
if(conn != null) {
conn.close();
conn = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
}
return list;
}
}
幫忙看看哪里有什么問題?
展開