java如何连接oracle数据库，并根据所输入的条件将数据库中的相关内容显示在jsp页面的table中？

大四到公司实习，这是公司的一个蛮大的项目，分给我这么一个小小的功能，可是在学校里这些东西都没学过啊~也不知道该怎么弄，求大神指点。

public class testOra extends HttpServlet { private static final long serialVersionUID = 1L;
/**
* @see HttpServlet#HttpServlet()
*/
public testOra() {
super();
// TODO Auto-generated constructor stub
}

/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
this.doPost(request, response);
}

/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException,
IOException {
// TODO Auto-generated method stub
ArrayList<String> list =this.rsMod();
request.setAttribute("list", list);
}

public ArrayList<String> rsMod() {
ArrayList<String> list = new ArrayList<String>();
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url = "jdbc:oracle:thin:@localhost:1521:binbo";
String user = "scott";
String password = "tiger";
Connection conn = DriverManager.getConnection(url, user, password);

Statement stat = conn.createStatement(); ResultSet result = stat.executeQuery("SELECT * FROM test");
while (result.next()) {
String a = result.getString(1);
list.add(a);
}
result.close();
stat.close();
conn.close();
return list;
}
catch (ClassNotFoundException en) {
System.out.println("数据库驱动找不到！");
en.printStackTrace();
}
catch (SQLException ex) {
while (ex != null) {
ex.printStackTrace();
ex = ex.getNextException();
}
}
catch (Exception e) {
System.out.println("其他未知异常！");
e.printStackTrace();
}
return list;
}
}

JSP:简单点：
<%
ArrayList<String> list =(ArrayList<String>) request.getAttribute("list");
for(int i=0;i<list.size();i++)
{%>
<tr>
<td>
<%=list.get(i)%>
</td>
</tr>
<%
}
%>当然，你也可以使用标签，比如可以用C/LOGIC 标签

温馨提示：内容为网友见解，仅供参考

当前网址：https://11.t2y.org/zz/28447282p.html