<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
Insert title here
<%
String url = "jdbc:odbc:DSSchool;useunicode=true;characterEncoding=UTF-8";
String sqlstr,no,name;
int age;
Connection con; // 建立连接类
Statement stmt; // 建立SQL语句执行类
ResultSet rs = null;// 建立结果集类
// 告诉程序使用JDBC与ODBC桥建立数据库连接
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection(url,"sa","123456");
stmt = con.createStatement();
sqlstr = "select * from T_STUDENT";
rs = stmt.executeQuery(sqlstr);
while (rs.next()){
String stuno = new String (rs.getString("STUNO").getBytes("GBK"),"UTF-8");
String stuname = new String ( rs.getString("STUNAME").getBytes("GBK"),"UTF-8");
out.print(stuno+" "+stuname + " "+"
");
}
stmt.close();
con.close();
%>
