📄 myex7_3.jsp

📁 黑魔方JSP基础教程源代码(耿祥义编著)是这里有课件和jsp源代码

💻 JSP

字号:

<%@ 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 + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -