使用jdbc
dbc桥
<%@ page import ="java.sql.*"%>
<%
Connection sqlCon;
//数据库连接对象
Statement sqlStmt;
//SQL语句对象
ResultSet sqlRst;
//结果集对象
java.lang.String strCon;
//数据库连接字符串
try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){}
//连接数据库
sqlCon = java.sql.DriverManager.getConnection("jdbc
dbc:your_db_name","","");
sqlStmt = sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
//准备SQL语句
strSQL = "select * from file";
//执行SQL语句并获取结果集
sqlRst = sqlStmt.executeQuery(strSQL);
.....
.....
%>