调试下面的程序为什么会发生错误，没有任何等显示，为什么啦，能够给我看看吗？？？

boyandgirl 2001-11-23 01:38:31

<%@page language="java"%>
<%@page import="java.io.*"%>
<%@page import="java.sql.*"%>
<%@page import="work.com.data.*"%>
<%@page contentType="text/html;charset=gb2312"%>
<%
opendb data = new opendb();
String username1=request.getParameter("username");
String password1=request.getParameter("password");
String sql="select * from sam_user where username='"+username1+"' and password='"+password1+"'";
ResultSet rs;
rs=data.executeQuery(sql);
if(rs.next()){
String sqll="select rightname,rid from sam_user,sam_user_prog,right where sam_user.username='"+username1+"' and sam_user_prog.username='"+username1+"' and right.prog_id=sam_user_prog.prog_id ";
ResultSet rs1;
%>

<HTML>
<HEAD>
<TITLE> test </TITLE>
<META http-equiv="content-Type" content="text/html;charset=gb2312">
</HEAD>
<BODY bgcolor="#FFCCFF" text="#0000">
<div align="center"><font size="6" color="#330033">用户登陆：</font></div>
<form method="post" name="name">
<table width="50%" border="1" height="100" align="center" cellspacing="0" cellpadding="0">
<tr align="center">
<td align="center"><font color="#FF6666">用户名称：</font></td>
<td><input type="text" name="username"></td>
</tr>
<tr align="center">
<td align="center"><font color="#00CCCC">密码：</font></td>
<td><input type="password" name="password"></td>
</tr>
<tr align="right">
<td><input type="submit" name="name2" value="确定"></td>
</tr>
<tr>
<%
rs1=data.executeQuery(sqll);
String[] rightname=null;
String[] rightid=null;
int i=0;
while(rs1.next()){
rightname[i]=rs1.getString("rightname");
rightid[i]=rs1.getString("rid");
i++;
}
for (int n=0;n<rightname.length;n++){
%>
<tr>
<TD><A href="<%=rightid[n]%>"><%=rightname[n]%></A></TD>
</tr>
<%}
}
%>
</form>
<%
rs.close();

%>
</table>
</BODY>
</HTML>

...全文