7-04.jsp

来自「石志国著《JSP应用教程》」· JSP 代码 · 共 21 行

<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<%
try{
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
	Connection conn = DriverManager.getConnection("jdbc:odbc:person", "", ""); 
	Statement stmt  = conn.createStatement();
	ResultSet rs=stmt.executeQuery("select * from [Sheet1$]");
	while(rs.next()){
		out.print("  编号：" + rs.getString(1));
		out.print("  姓名：" + rs.getString(2));
		out.print("  座位：" + rs.getString(3));
		out.print("<BR>");
	}
	rs.close();
	stmt.close();
	conn.close();
}catch(Exception e){
	e.printStackTrace();
}
%>