连接Oracle(thin模式)
<%@ page contentType="text/html; charset=UTF-8" import="java.util.*" language="java" errorPage="" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
String url="jdbc:oracle:thin:@127.0.0.1:1521:orcl";
String user="数据库用户名";
String password="密码";
java.lang.Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from Test";
ResultSet rs=stmt.executeQuery(sql);
Integer roleCode=0;
while(rs.next()){
roleCode= rs.getInt(1);
}
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
//连接MySQL数据库
<%
//mysql的链接字符串
/* Class.forName(“com.mysql.jdbc.Driver”)是 强制JVM将com.mysql.jdbc.Driver这个类加载入内存,
并将其注册到DriverManager类,然后根据DriverManager.getConnection(url,user,pwd)中的url找到相应的驱动类,
最后调用该该驱动类的connect(url, info)来获得connection对象。 */
String url="jdbc:postgresql://localhost/数据库名";
String user="myuser";
String password="123456";
Class.forName("org.postgresql.Driver").newInstance();
//创建数据库连接对象
Connection conn = DriverManager.getConnection(url, user, password);
//构造Statement(语句)对象,传递sql语句的载体
Statement stmt = conn
.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String sql = "select * from test";
//返回结果集
ResultSet rs = stmt.executeQuery(sql);
%>
<%
//关闭连接对象
rs.close();
stmt.close();
conn.close();
%>
Jsp中连接数据库写sql查询
最新推荐文章于 2023-07-25 10:14:48 发布