Flex连接数据库的方法

package tree; import java.sql.*; import java.util.ArrayList; import java.util.HashMap; import java.util.Map; import java.util.Collection; public class getUserService { public Collection getUsers(){ ArrayList<Map> list = new ArrayList<Map>(); String dbDriver = "com.mysql.jdbc.Driver"; String dbServer = "localhost"; String dbName = "UserInfo"; String dbUser = "root"; String dbPass = "pass"; //连接字符串 String url="jdbc:mysql://"+dbServer+"/"+dbName+"?user="+dbUser+"&password="+dbPass; //实例化驱动 try{ Class.forName(dbDriver); }catch(ClassNotFoundException e){ return null; } try{ //建立连接 Connection connection=DriverManager.getConnection(url); //创建数据库操作对象 Statement statement = connection.createStatement(); String sql="SELECT * FROM UserInfo"; ResultSet rs = statement.executeQuery(sql); Map<String, Object> user; while (rs.next()) { user = new HashMap<String, Object>(); user.put("username",rs.getString("username")); user.put("url",rs.getString("url")); user.put("email",rs.getString("email")); list.add(user); } return list; }catch(SQLException e){ return null; } } }