JSP连接oracle数据库测试

最新推荐文章于 2021-04-07 09:39:41 发布

程序小生oO

最新推荐文章于 2021-04-07 09:39:41 发布

阅读量226

点赞数

文章标签： jdbc jsp

本文链接：https://blog.csdn.net/qq_21359467/article/details/103163374

版权

首先将oracle驱动jar添加到项目中.
代码粘贴复制直接用

<%@ page contentType="text/html; charset=gb2312"%>
<%@ page language="java"%>
<%@ page import="oracle.jdbc.driver.OracleDriver"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>连接数据库测试页面</title>
</head>
<body>
	<%
	Statement stmt = null;
	ResultSet rs = null;
	Connection conn = null;
	try {
	  	//数据库名 
	    String username = "bold";
	    //密码 
	    String password = "123456";
		//数据库连接地址
	    String url = "jdbc:oracle:thin:@127.0.0.1:1521:oracle";
	    out.print("1、加载数据库驱动...<br>");
	    Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
		out.print("2、初始化连接数据库...<br>");
	    conn = DriverManager.getConnection(url, username, password);
		out.print("3、创建执行sql语句的对象...<br>");
	    stmt = conn.createStatement();
	    String sql = "SELECT * FROM UP_VERSIONS";
		out.print("4、开始执行sql...<br>");
	    rs = stmt.executeQuery(sql);
	%>
		<table border="1" width="80%">
			<tr>
				<td>FNAME</td>
				<td>MAJOR</td>
				<td>MINOR</td>
			</tr>
			<%
		    while (rs.next()) {
		        String column1 = rs.getString(1);
		        String column2 = rs.getString(2);
		        String column3 = rs.getString(3);
			%>
			<tr>
				<td><%=column1%></td>
				<td><%=column2%></td>
				<td><%=column3%></td>
			</tr>
			<%
			    }
			%>
		</table>
	<%
		out.print("<br>");
		out.print("ok， Database Connection Successd！");
	} catch (java.lang.Exception ex){
		out.print("error "+ex.getMessage());
	} finally {
	    if(rs != null){
	        rs.close();
	    }
	    if(stmt != null){
	        stmt.close();
	    }
	    if(conn != null){
	        conn.close();
	    }
	}
	%>
</body>
</html>

程序小生oO

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
JSP连接oracle数据库测试

首先将oracle驱动jar添加到项目中.代码粘贴复制直接用<%@ page contentType="text/html; charset=gb2312"%><%@ page language="java"%><%@ page import="oracle.jdbc.driver.OracleDriver"%><%@ page import="...
复制链接

扫一扫