i have to create an actionscript to retrieve data from the database. i have a database(mySQL) called mapping with the fields Longitude, Latitude and Angle.
this is my jsp file:
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="java.sql.*" %>
<%@ include file="mysqlConfig.jsp" %>
<%
Connection connection = null;
String str="";
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection(s1_db, db_user, db_pw);
Statement statement = connection.createStatement();
ResultSet rs = statement.executeQuery("SELECT * FROM mapping");
//String[][] data = new String[11][10];
int x = 0;
while (rs.next()) {
//noinspection UnusedAssignment
str = str + "&Longitude" + x + "=" + rs.getString("Longitude") + "&Latitude" + x + "=" + rs.getString("Latitude") +
"&Angle" + x + "=" + rs.getString("Angle") + "&" + "<br>";
x++;
}
out.println(str);
} catch(ClassNotFoundException cnfe){
System.out.println("Database driver not found:" + cnfe.getMessage());
} catch(SQLException sqlexception){
System.out.println("Error opening the db connection: " + sqlexception.getMessage());
} finally {
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace(); //To change body of catch statement use File | Settings | File Templates.
}
}
%>
from this jsp file, i have to use the function LoadVars to receive the data that is retrieve by this file from my database. i started the actionscript as show below but i need to incoporate it with the other actionscript. as in i have to use the longitude and latitude as the multidimensional array.
this is the one that is connected with the jsp
[AS]
[FONT=Courier New][LEFT][FONT=Verdana]#include “tomcatURL.as”[/FONT]
[FONT=Verdana]var mUnit:Array = new Array();[/FONT]
[FONT=Verdana]//***************************************************************************************
// function to connect database for initial positions of active objects in Battlescape
// also to insert new entries to all logs
function initMap():Void {
var send_lv:LoadVars = new LoadVars();
var rec_lv:LoadVars = new LoadVars();
// Battlescape to receive data from test.mapping using main.jsp
send_lv.sendAndLoad(_global.serverURL + “mine.jsp”, rec_lv, “POST”);
rec_lv.onLoad = function(success:Boolean) {
if (success) {
var i:Number = 0;
while (rec_lv[“Longitude”+i] != null){
mUnit* = new Mappie(rec_lv[“Longitude”+i], rec_lv[“Latitude”+i], rec_lv[“Angle”+i]);
i++;
}[/FONT]
[FONT=Verdana] }
}
}
[/AS][/FONT][/LEFT]
[/FONT]
this is the one that needs to be modify so that it would be connected to the jsp (help me on this one plz)
[AS]
[FONT=Courier New][LEFT][FONT=Verdana]var targetIndex:Number = 0;
//var xValues:Array = [100,200,220,300,330,370];
//var yValues:Array = [100,150,220,300,310,400];
var tarArray:Array = [[70,120], [80,215], [110,270], [170,320], [225,280], [300,360], [355,430], [520,380], [610,500]];
this.createEmptyMovieClip(“line_mc”, 1); //creating the line
this.attachMovie(“arrowmc”, “arrowmc”, this.getNextHighestDepth()); //inserting the mc
line_mc.lineStyle(2, 0xFF00FF, 30);
line_mc.moveTo(tarArray[0][0], tarArray[0][1]); // starting point of the target
arrowmc._x = tarArray[0][0];
arrowmc._y = tarArray[0][1]; [/FONT]
[FONT=Verdana]var move_int = setInterval(moveChaser,50); //setting time delay between movements[/FONT]
[FONT=Verdana]function moveChaser() {
//works out the angle in radians between tarArray[targetIndex] and arrowmc
var theta:Number = Math.atan2(tarArray[targetIndex][1] - arrowmc._y, tarArray[targetIndex][0] - arrowmc._x);
//changes radians to degrees and orientates it 90 more degrees because in flash 0 degrees is facing right
arrowmc._rotation = (theta * 180 / Math.PI)+90;
//checks that tarArray[targetIndex] and arrowmc are more than 2 away from each other
if(Math.abs((tarArray[targetIndex][0]-arrowmc._x)) > 2 || Math.abs((tarArray[targetIndex][1]-arrowmc._y)) > 2){
//moves arrowmc 3 towards tarArray[targetIndex]
arrowmc._x += Math.cos(theta) * 3;
arrowmc._y += Math.sin(theta) * 3;
//draws the line to wherever arrowmc is
line_mc.lineTo(arrowmc._x , arrowmc._y);
}
route_btn.onRelease = function(){
//test for no more targets in tarArray
if(tarArray[targetIndex][0] == undefined){
clearInterval(move_int);
trace(“successful”);
}
//to go to the next Array
targetIndex++;
trace(“Target Index:” +targetIndex)
}
};[/FONT]
[FONT=Verdana][/AS][/FONT][/LEFT]
[/FONT]
