<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*"%>
<html><body>
<table width="400px" align="center" border="0" cellpadding="0" cellspacing="1" bgcolor="black">
<%
/*http://jingyan.baidu.com/article/2fb0ba406b437200f2ec5fc0.html
添加数据源时选用“系统DSN而不是用户DSN”
win7：控制面板-管理工具-数据源(OBDC)-系统DSN*/
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:zhchldb","","");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from Student_Info");
while(rs.next()){
out.print("<tr bgcolor=\"white\"><td>"+rs.getString("StudentID")+"</td><td>"+rs.getString("StudentName")+"</td></tr>");
}
rs.close();
stmt.close();
conn.close();
%>
</table></body></html>
<html><body>
<table width="400px" align="center" border="0" cellpadding="0" cellspacing="1" bgcolor="black">
<%
/*http://jingyan.baidu.com/article/2fb0ba406b437200f2ec5fc0.html
添加数据源时选用“系统DSN而不是用户DSN”
win7：控制面板-管理工具-数据源(OBDC)-系统DSN*/
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:zhchldb","","");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from Student_Info");
while(rs.next()){
out.print("<tr bgcolor=\"white\"><td>"+rs.getString("StudentID")+"</td><td>"+rs.getString("StudentName")+"</td></tr>");
}
rs.close();
stmt.close();
conn.close();
%>
</table></body></html>
765
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
