myex7_3.jsp

来自「黑魔方JSP基础教程源代码(耿祥义编著)是这里有课件和jsp源代码」· JSP 代码 · 共 38 行

JSP
38
字号
<%@ page contentType="text/html;charset=GB2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
 Connection con;
 Statement sql;
 ResultSet rs;
 try
 {Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 }
 catch(ClassNotFoundException e){}
 try{con=DriverManager.getConnection("jdbc:odbc:moon","","");
  sql=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
  rs=sql.executeQuery("select * from student");
  rs.afterLast();
  while(rs.previous())
   {out.print(rs.getString(1)+"  ");
   out.print(rs.getString(2)+"  ");
   out.print(rs.getInt(3)+"  "); 
   out.print(rs.getInt(4)+"  ");  
   out.print(rs.getInt(5)+"  ");
   out.print("<p>");
  }
  rs.absolute(5);
   out.print("<br>");
  out.print(rs.getString(1)+"  ");
   out.print(rs.getString(2)+"  ");
   out.print(rs.getInt(3)+"  "); 
   out.print(rs.getInt(4)+"  ");  
   out.print(rs.getInt(5)+"  ");
   out.print("<p>");
 con.close();   
 }
 catch(SQLException e){}
%>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?