测试oracle链接

最新推荐文章于 2023-06-13 09:43:37 发布

daohe113

最新推荐文章于 2023-06-13 09:43:37 发布

阅读量595

点赞数

分类专栏： oracle 文章标签： Oracle JDBC SQL HTML

本文链接：https://blog.csdn.net/daohe113/article/details/83288574

版权

oracle 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

<%@ 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>