测试数据库jdbc连接jsp

最新推荐文章于 2021-09-02 11:24:24 发布

WhatWeDo

最新推荐文章于 2021-09-02 11:24:24 发布

阅读量845

点赞数

本文链接：https://blog.csdn.net/sz_syb/article/details/23543813

版权

<%@ page contentType="text/html;charset=gb2312" language="java"
import="java.sql.*" import="java.io.*"%>

<html>
<head>
<title>数据库连接试验</title>
</head>
<body>
<%
Connection conn = null;
Statement stmt = null;
ResultSet rest = null;
ResultSetMetaData rsmd = null;
int numberOfColumns = 0;
String dbDriver = "oracle.jdbc.driver.OracleDriver";
String dbConnSt = "jdbc:oracle:thin:@192.235.1.20:1598:zss";
boolean remark = false;
try {
Class.forName(dbDriver).newInstance();
conn = DriverManager.getConnection(dbConnSt, "mytest1",
"mytest1");
} catch (Exception e) {
remark = true;
out.print("连接失败！异常:" + e.getMessage());
}
if (remark == false) {
out.println("恭喜，连接数据库成功！");
}
%>
</body>
</html