81,122
社区成员
发帖
与我相关
我的任务
分享调试下面的程序为什么会发生错误，没有任何等显示，为什么啦，能够给我看看吗？？？
<!--测试权限程序如何生成-->
<%@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;
%>
<!--现在的任务是怎么样把在sam_user当中用户所具有的prog_id给取出来放在某个数组当中去-->
<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>
<%@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;
%>
<!--现在的任务是怎么样把在sam_user当中用户所具有的prog_id给取出来放在某个数组当中去-->
<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>
...全文
请发表友善的回复…
发表回复
