作者kobe0811 (想去看海...)
看板Flash
标题[问题] flex login
时间Sat Oct 4 21:58:31 2008
"[RPC Fault faultString="HTTP request error" faultCode="Server.Error.Request"
faultDetail="Error: [IOErrorEvent type="ioError" bubbles=false
cancelable=false eventPhase=2 text="Error #2032: 串流错误"
我是用 flex.org Create a login system with Flex and PHP
来修改 我改成用jsp来连资料库
jsp的程式
<%@ page contentType="text/html;charset=utf-8"%>
<%@ page import="java.sql.*" language="java"%>
<%!
String driverName="com.mysql.jdbc.Driver";
String userName="root";
String userPasswd="****";
String database = "test";
String url = "jdbc:mysql://localhost:3306/" + database +
"?user="+userName+"&password="+userPasswd;
Connection conn=null;
Statement stmt;
String usna="",pasw="",sql="";
ResultSet rs;
%>
<%
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn = DriverManager.getConnection(url);
stmt = conn.createStatement();
}catch(SQLException sqle){
out.println("SQL Exception : " + sqle);
}
if(request.getParameter("username")!=null &&
request.getParameter("password")!=null)
{
usna=request.getParameter("username");
pasw=request.getParameter("password");
sql="SELECT name,password FROM muser WHERE name="+usna+" AND
password='"+pasw;
rs=stmt.executeQuery(sql);
out.print("<?xml version=\"1.0\" encoding=\"UTF-8\" ?>");
while(rs.next()){
if(rs.getRow()==1)
{
out.print("<loginsuccess>YES</loginsuccess>");
}
else
{
out.print("<loginsuccess>NO</loginsuccess>");
}
}
}
else
out.print("<loginsuccess>NULL</loginsuccess>");
out.close();
rs.close();
stmt.close();
conn.close();
%>
上面显示的错误
我想应该是jsp这边有问题
可是我不知道是哪边有错
请各位高手帮帮忙~
感恩~
应该懂我的描述吧> <
或着有人有写好的范例
可以借我参考一下吗?
Orz
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 140.118.232.114
※ 编辑: kobe0811 来自: 140.118.232.114 (10/04 22:01)
※ 编辑: kobe0811 来自: 140.118.232.114 (10/05 11:59)