如何通过java类在jsp中显示值 [英] how to display values in jsp through java class
问题描述
我有一个包含表和值的数据库.我想获取该数据并将其显示在jsp页面中.不想在jsp页面中编写查询，分离Java类，创建Java对象值，然后将其显示在jsp的select字段中.请帮助我...
I have a database with tables and values. I want to fetch that data and display it in jsp page. Don't want to write query in jsp page, separate java class,creating java object values and then displaying it in select field in jsp. please help me...
这是我的java类 p
here is my java class p
ublic 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;
}
}
//and my jsp file
<%@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>
推荐答案
我认为您应该尝试
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;
}
}
假设此类正常运行，并且正在返回具有某些值的列表
Assuming this class working fine and it is returning list with some value
现在在您的jsp页面上
now on your jsp page
<%@page language="java" import="java.util.*" %>
<html>
<body>
<table border="1" width="303">
<tr>
<td width="119"><b>Name</b></td>
</tr>
<%
ArrayList list;
EmpBean emp = new EmpBean();
list = emp.dataList();
ArrayList li = (ArrayList) li.get(0);
%>
<tr>
<select name="" id="" style="width: 150px;"">
<option value="-1"><%=li.get(1)%></option>
</select>
</tr>
</table>
</body>
</html>
仅检查此代码...可能会发生取值错误的情况，这里只需通过更改列表索引来检查值，以及是否可以用try catch将整个scriptlet包围起来，以便在发生异常时很容易找到错误...祝您好运，请不要担心它是否无效，我将为您提供示例代码，以确保我在我的项目中使用此代码
just check this code...it might happen that values fetched may be wrong here just check the values by changing list indexing and also if you can surround the whole scriptlets thing with try catch so that if exception occurs it will be easy to find bug...good luck and don't worry if it doesn't works i will give you sample code for sure i am using this code my project
这篇关于如何通过java类在jsp中显示值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
