Flex & jsp interface

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%  request.setCharacterEncoding("UTF-8"); %>
<%@ page language = "java" %>
<%@ page import   = "java.util.* , java.lang.* " %>
<%@ page import   = "javax.servlet.http.*" %>
<%@ page import   = "java.sql.Connection , java.sql.DriverManager , java.sql.SQLException" %>
<%@ page import   = "java.sql.* " %>

 

<%

  Statement stmt = null;
  ResultSet rs = null;

     String url = "jdbc:mysql://localhost:3306/데이터베이스 명";
     Class.forName("com.mysql.jdbc.Driver");
     Connection conn = DriverManager.getConnection(url,"SQL USER ID","SQL PASSWORD");   

    
// Parameter Get

   String command = request.getParameter ("command");
   String userid = request.getParameter ("userid"); 
   String username = request.getParameter ("username"); 
   String password = request.getParameter ("password"); 
   String address = request.getParameter ("address"); 
   String phone = request.getParameter ("phone"); 

 

//--------------------------------------SQL Connect .. Quiry Execute  .. Result ----------------
   try
   {
    stmt = conn.createStatement ();

  
   String sql = "INSERT INTO userinfo (userid, username, password, address, phone)"
              + " values ( '" +userid+ "','" +username+ "','" +password+ "','" +address+ "','" +phone+"')";

 

   rs = stmt.executeUpdate(sql);

//--------------------------------------XML Data to Flex ----------------------------------    
   while (rs.next())
   {

   out.println ("<userdata>" );
   out.println ("<userid>" + rs.getString("userid") + "</userid>" );
   out.println ("<username>" + rs.getString("username") + "</username>" );
   out.println ("<password>" + rs.getString("password") + "</password>" );
   out.println ("<address>" + rs.getString("address") + "</address>" );
   out.println ("<phone>" + rs.getString("phone") + "</phone>" );
   out.println ("</userdata>");
   }

//----------------------------------------------------------------------------------------

 }
 
catch (SQLException ex)
 {
 // handle and errors
   out.println ("<SQLException> : " + ex.getMessage() + "</SQLException>");
   out.println ("<SQLState>     : " + ex.getSQLState() + "</SQLState>"  );
   out.println ("<VendorError>  : " + ex.getErrorCode() + "</VendorError>");      
 }

finally
 {
 
 // - ResultSet close , Statement close , connection close ---------------------------------------
    if (rs != null)    try { rs.close();   } catch (SQLException ex) {} 
    if (stmt != null)  try { stmt.close(); } catch (SQLException ex) {}
    if (conn != null)  try { conn.close(); } catch (SQLException ex) {}
 }    

%>