2006-4-11 15:20
manhunt
非常简单的ArrayList问题
本人是初学者，
想用jsp连接SQL Server数据库，并在页面上显示出来。
一共有3个重要文件：
usr_detail.jsp，loginusr.java：调用其中的detail方法，basebean.java：属性类
basebean.java
<%@ page contentType="text/html; charset=gb2312" import="usr.basebean"%>
<%@ page import="java.util.*"%>
<jsp:useBean id="FUCK" scope="page" class="usr.loginusr"/>
<html>
<head>
<title>detail</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<p> </p>
<p>hello:<%= session.getAttribute("name")%></p>
<form name="form1" method="post" action="detail">
<table width="75%" cellspacing="0" cellpadding="0">
<tr>
<td width="44%"><div align="right">1</div></td>
<td width="56%"><input name="a1" type="text" id="a1"></td>
</tr>
<tr>
<td><div align="right">2</div></td>
<td><input name="a2" type="text" id="a2"></td>
</tr>
<tr>
<td><div align="right">3</div></td>
<td><input name="a3" type="text" id="a3"></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div align="right"></div></td>
<td><input type="submit" name="Submit" value="Submit"> <input type="reset" name="Submit2" value="Reset"></td>
</tr>
</table>
</form>
<%
String abc = (String)session.getAttribute("name");
ArrayList a=FUCK.detail(abc);
Iterator it = a.iterator();
%>
<table width="731" border="0">
<tr>
<td>1</td>
<td>2</td>
<td>3</td>
<td>date</td>
</tr>
<%
while(it.hasNext()){
basebean usr = (basebean)it.next();
String name = usr.getName();
String a1 = usr.geta1();
String a2 = usr.geta2();
%>
<tr>
<td><%= a1%> </td>
<td><%= a2%> </td>
<td><%= %> </td>
<td><%= name%> </td>
</tr>
<%
}
%>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<p> </p>
</body>
</html>
loginusr.java
package usr;
import java.sql.*;
import db.*;
import usr.basebean;
import java.util.ArrayList;
public class loginusr {
public static final int ISUSER = 1;
public static final int USERNAME_ERROR = 2;
public static final int PASSWORD_ERROR = 3;
public static final int OTHER_ERROR = 4;
public int isUser(String name, String pwd) {
int result = 0;
dbconnection dbcon = new dbconnection();
String sql = "select name,pwd from usr where name='" + name +
"'";
ResultSet rs = dbcon.getRs(sql);
try {
if (rs.next()) {
if (rs.getString("pwd").trim().equals(pwd)) {
result = this.ISUSER;
} else {
result = this.PASSWORD_ERROR;
}
} else {
result = this.USERNAME_ERROR;
}
} catch (SQLException ex) {
ex.printStackTrace();
result = this.OTHER_ERROR;
} finally {
dbcon.close();
}
return result;
}
public void addu(String a1, String a2, String a3, String name) {
dbconnection dbcon = new dbconnection();
String sql = "insert into detail(a1,a2,a3,dname) values('" + a1 + "','" +
a2 + "','" + a3 + "','" + name + "')";
ResultSet rs = dbcon.getRs(sql);
}
public ArrayList detail(String name) throws SQLException {
ArrayList al = new ArrayList();
dbconnection dbcon = new dbconnection();
String sqld = "select a1,a2,a3,dname from detail where dname='"+name+"'";
ResultSet rsd = dbcon.getRs(sqld);
basebean d=null;
while (rsd.next()) {
d = new basebean();
d.setdname(rsd.getString("dname"));
d.seta1(rsd.getString("a1"));
d.seta2(rsd.getString("a2"));
d.seta3(rsd.getString("a3"));
al.add(d);
}
return al;
}
}
usr_detail.jsp
<%@ page contentType="text/html; charset=gb2312" import="usr.basebean"%>
<%@ page import="java.util.*"%>
<jsp:useBean id="FUCK" scope="page" class="usr.loginusr"/>
<html>
<head>
<title>detail</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<p> </p>
<p>hello:<%= session.getAttribute("name")%></p>
<form name="form1" method="post" action="detail">
<table width="75%" cellspacing="0" cellpadding="0">
<tr>
<td width="44%"><div align="right">1</div></td>
<td width="56%"><input name="a1" type="text" id="a1"></td>
</tr>
<tr>
<td><div align="right">2</div></td>
<td><input name="a2" type="text" id="a2"></td>
</tr>
<tr>
<td><div align="right">3</div></td>
<td><input name="a3" type="text" id="a3"></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div align="right"></div></td>
<td><input type="submit" name="Submit" value="Submit"> <input type="reset" name="Submit2" value="Reset"></td>
</tr>
</table>
</form>
<%
String abc = (String)session.getAttribute("name");
ArrayList a=FUCK.detail(abc);
Iterator it = a.iterator();
%>
<table width="731" border="0">
<tr>
<td>1</td>
<td>2</td>
<td>3</td>
<td>date</td>
</tr>
<%
while(it.hasNext()){
basebean usr = (basebean)it.next();
String name = usr.getName();
String a1 = usr.geta1();
String a2 = usr.geta2();
%>
<tr>
<td><%= a1%> </td>
<td><%= a2%> </td>
<td><%= %> </td>
<td><%= name%> </td>
</tr>
<%
}
%>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<p> </p>
</body>
</html>
问题就出现在这个jsp页面上，jbuilder指出ArrayList a=FUCK.detail(abc);有问题
运行后的问题是：
"user_detail.jsp": cannot find symbol; symbol : method print(), location: class javax.servlet.jsp.JspWriter
我不知是什么问题。
本人是初学者，
想用jsp连接SQL Server数据库，并在页面上显示出来。
一共有3个重要文件：
usr_detail.jsp，loginusr.java：调用其中的detail方法，basebean.java：属性类
basebean.java
<%@ page contentType="text/html; charset=gb2312" import="usr.basebean"%>
<%@ page import="java.util.*"%>
<jsp:useBean id="FUCK" scope="page" class="usr.loginusr"/>
<html>
<head>
<title>detail</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<p> </p>
<p>hello:<%= session.getAttribute("name")%></p>
<form name="form1" method="post" action="detail">
<table width="75%" cellspacing="0" cellpadding="0">
<tr>
<td width="44%"><div align="right">1</div></td>
<td width="56%"><input name="a1" type="text" id="a1"></td>
</tr>
<tr>
<td><div align="right">2</div></td>
<td><input name="a2" type="text" id="a2"></td>
</tr>
<tr>
<td><div align="right">3</div></td>
<td><input name="a3" type="text" id="a3"></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div align="right"></div></td>
<td><input type="submit" name="Submit" value="Submit"> <input type="reset" name="Submit2" value="Reset"></td>
</tr>
</table>
</form>
<%
String abc = (String)session.getAttribute("name");
ArrayList a=FUCK.detail(abc);
Iterator it = a.iterator();
%>
<table width="731" border="0">
<tr>
<td>1</td>
<td>2</td>
<td>3</td>
<td>date</td>
</tr>
<%
while(it.hasNext()){
basebean usr = (basebean)it.next();
String name = usr.getName();
String a1 = usr.geta1();
String a2 = usr.geta2();
%>
<tr>
<td><%= a1%> </td>
<td><%= a2%> </td>
<td><%= %> </td>
<td><%= name%> </td>
</tr>
<%
}
%>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<p> </p>
</body>
</html>
loginusr.java
package usr;
import java.sql.*;
import db.*;
import usr.basebean;
import java.util.ArrayList;
public class loginusr {
public static final int ISUSER = 1;
public static final int USERNAME_ERROR = 2;
public static final int PASSWORD_ERROR = 3;
public static final int OTHER_ERROR = 4;
public int isUser(String name, String pwd) {
int result = 0;
dbconnection dbcon = new dbconnection();
String sql = "select name,pwd from usr where name='" + name +
"'";
ResultSet rs = dbcon.getRs(sql);
try {
if (rs.next()) {
if (rs.getString("pwd").trim().equals(pwd)) {
result = this.ISUSER;
} else {
result = this.PASSWORD_ERROR;
}
} else {
result = this.USERNAME_ERROR;
}
} catch (SQLException ex) {
ex.printStackTrace();
result = this.OTHER_ERROR;
} finally {
dbcon.close();
}
return result;
}
public void addu(String a1, String a2, String a3, String name) {
dbconnection dbcon = new dbconnection();
String sql = "insert into detail(a1,a2,a3,dname) values('" + a1 + "','" +
a2 + "','" + a3 + "','" + name + "')";
ResultSet rs = dbcon.getRs(sql);
}
public ArrayList detail(String name) throws SQLException {
ArrayList al = new ArrayList();
dbconnection dbcon = new dbconnection();
String sqld = "select a1,a2,a3,dname from detail where dname='"+name+"'";
ResultSet rsd = dbcon.getRs(sqld);
basebean d=null;
while (rsd.next()) {
d = new basebean();
d.setdname(rsd.getString("dname"));
d.seta1(rsd.getString("a1"));
d.seta2(rsd.getString("a2"));
d.seta3(rsd.getString("a3"));
al.add(d);
}
return al;
}
}
usr_detail.jsp
<%@ page contentType="text/html; charset=gb2312" import="usr.basebean"%>
<%@ page import="java.util.*"%>
<jsp:useBean id="FUCK" scope="page" class="usr.loginusr"/>
<html>
<head>
<title>detail</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<p> </p>
<p>hello:<%= session.getAttribute("name")%></p>
<form name="form1" method="post" action="detail">
<table width="75%" cellspacing="0" cellpadding="0">
<tr>
<td width="44%"><div align="right">1</div></td>
<td width="56%"><input name="a1" type="text" id="a1"></td>
</tr>
<tr>
<td><div align="right">2</div></td>
<td><input name="a2" type="text" id="a2"></td>
</tr>
<tr>
<td><div align="right">3</div></td>
<td><input name="a3" type="text" id="a3"></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td><div align="right"></div></td>
<td><input type="submit" name="Submit" value="Submit"> <input type="reset" name="Submit2" value="Reset"></td>
</tr>
</table>
</form>
<%
String abc = (String)session.getAttribute("name");
ArrayList a=FUCK.detail(abc);
Iterator it = a.iterator();
%>
<table width="731" border="0">
<tr>
<td>1</td>
<td>2</td>
<td>3</td>
<td>date</td>
</tr>
<%
while(it.hasNext()){
basebean usr = (basebean)it.next();
String name = usr.getName();
String a1 = usr.geta1();
String a2 = usr.geta2();
%>
<tr>
<td><%= a1%> </td>
<td><%= a2%> </td>
<td><%= %> </td>
<td><%= name%> </td>
</tr>
<%
}
%>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<p> </p>
</body>
</html>
问题就出现在这个jsp页面上，jbuilder指出ArrayList a=FUCK.detail(abc);有问题
运行后的问题是：
"user_detail.jsp": cannot find symbol; symbol : method print(), location: class javax.servlet.jsp.JspWriter
我不知是什么问题。
2006-4-11 23:50
xiaocao-x
错的是这一句<td><%= %> </td>内容不能为空
页: [1]
查看完整版本: 非常简单的ArrayList问题
Powered by Discuz! Archiver 5.5.0 © 2001-2006 Comsenz Inc.