gpt4 book ai didi

java - 如何在JSP中调用Java方法?

转载 作者:行者123 更新时间:2023-11-29 09:49:18 25 4
gpt4 key购买 nike

我正在做学校项目,我需要在 jsp 文件中以下拉格式从数据库中动态显示学年、部门和媒介。我正在从 java 类中获取数据库值,并尝试在 jsp 中调用 tat java 方法来显示这些值,但我没有得到 nething der 并且我不想在 jsp 文件中写入查询.. 请帮助我 guyz m 从过去 3 天开始尝试。 ..我的java类

public class EmpBean {
public java.util.List dataList(){
ArrayList list=new ArrayList();
try {
Class.forName("driver");
Connection con = DriverManager.getConnection("url", "user", "pwd");
Statement st = con.createStatement();
System.out.println("hiiiii");
ResultSet rs = st.executeQuery("select * from employee");

while(rs.next()){
list.add(rs.getString("name"));
list.add(rs.getString("address"));
list.add(rs.getString("contactNo"));
list.add(rs.getString("email"));
}

System.out.println(rs.getString("contactNo"));
}

catch(Exception e){}

return list;
}
}

和我的 jsp 文件:

<%@page language="java" import="java.util.*" %>
<html>
<body>
<table border="1" width="303">
<tr>
<td width="119"><b>Name</b></td>
</tr>

<%Iterator itr;%>
<%
EmpBean p = new EmpBean();
List list= (List) p.dataList();
%>

for (itr=list.iterator(); itr.hasNext(); ) {
%>
<tr>
<select name="" id="" style="width: 150px;"">
<option value="-1"><%=itr.next()%></option>
</select>
</tr>
<%
}
%>
</table>
</body>
</html>

编辑 1:

错误信息:

> The server encountered an internal error () that prevented it from
> fulfilling this request. exception org.apache.jasper.JasperException:
> An exception occurred processing JSP page
> /Administrative/collectFees.jsp at line 93 90: <td colspan="4"><div
> id="fndiv"> 91: <%Iterator itr;%> 92: <% List data=
> (List)request.getAttribute("data"); 93: for (itr=data.iterator();
> itr.hasNext(); ){ 94: %> 95: <select name="year1" id="yr1"
> style="width: 150px;" onclick="showDetails()"> 96: <option
> value="-1">><%=itr.next()%></option> root cause
> java.lang.NullPointerException

最佳答案

尝试

<%
java.util.List list = new EmpBean().dataList();
%>

迭代你可以使用

<select>
<%for(String txt : new EmpBean().dataList()){%>
<option><%=txt%></option>
<%}%>
</select>

关于java - 如何在JSP中调用Java方法?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/12951486/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com