<%@ page contentType="text/html;charset=GBK" import="java.sql.*"%>
<html>
<title>测试oracle链接</title>
<body>
<%out.println("<center>测试数据库链接</center>"); %>
<center>
<%
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@GHOST-EF7E44257:1521:test";
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
try
{
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url,"system","yang");
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from student");
while (rs.next()){
out.println(":"+"<br>");
out.println(" + rs.getString('name') + ");
out.println(" + rs.getString('info') + ");
}
rs.close();
}
catch(Exception e)
{
out.println(e);
}
%>
fdafagjkgl
</center>
</body>
</html>
<html>
<title>测试oracle链接</title>
<body>
<%out.println("<center>测试数据库链接</center>"); %>
<center>
<%
String driver = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@GHOST-EF7E44257:1521:test";
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
try
{
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url,"system","yang");
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from student");
while (rs.next()){
out.println(":"+"<br>");
out.println(" + rs.getString('name') + ");
out.println(" + rs.getString('info') + ");
}
rs.close();
}
catch(Exception e)
{
out.println(e);
}
%>
fdafagjkgl
</center>
</body>
</html>