<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page language="java" import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<% Connection con=null;
PreparedStatement ps=null;
ResultSet rst=null;
try{
//1.加载驱动 loading driver
Class.forName("oracle.jdbc.driver.OracleDriver");
//2.得到连接 get connection
con=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","system","3333");
//3.创建preparedstatement借口对象
ps=con.prepareStatement("select * from aaa");
//4.完成查询 finish the select
rst=ps.executeQuery();
//5.循环输出结果
while(rst.next()){ %>
<%=rst.getInt(1)%> <%}
}catch (Exception e){
}finally {
} %>
</body>
</html>我是想让这里<%=rst.getInt(1)%> 把查询结果输出到jsp页面的, 可是出不来啊
pageEncoding="ISO-8859-1"%>
<%@ page language="java" import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<% Connection con=null;
PreparedStatement ps=null;
ResultSet rst=null;
try{
//1.加载驱动 loading driver
Class.forName("oracle.jdbc.driver.OracleDriver");
//2.得到连接 get connection
con=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","system","3333");
//3.创建preparedstatement借口对象
ps=con.prepareStatement("select * from aaa");
//4.完成查询 finish the select
rst=ps.executeQuery();
//5.循环输出结果
while(rst.next()){ %>
<%=rst.getInt(1)%> <%}
}catch (Exception e){
}finally {
} %>
</body>
</html>我是想让这里<%=rst.getInt(1)%> 把查询结果输出到jsp页面的, 可是出不来啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货