测试数据库jdbc连接jsp

来源:互联网 发布:父亲送女儿出嫁知乎 编辑:程序博客网 时间:2024/06/01 07:58
<%@ 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
0 0