jdbc直接连接
<%@ page contentType="text/html;charset=gb2312"%> <%@ page import="java.sql.*"%> <% String result = ""; // 查询结果字符串 String sql = "select sysdate from dual"; // SQL 字符串 // 连接字符串，格式： "jdbc:数据库驱动名称:连接模式:@数据库服务器ip:端口号:数据库SID" String url = "jdbc:oracle:thin:@localhost:1521:cs"; String username = "csdata"; // 用户名 String password = "pwd"; //密码 // 创建oracle数据库驱动实例 Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); // 获得与数据库的连接 Connection conn = DriverManager.getConnection(url, username, password); // 创建执行语句对象 Statement stmt = conn.createStatement(); // 执行sql语句，返回结果集 ResultSet rs = stmt.executeQuery(sql); while ( rs.next() ) { result += "\n 第一个字段内容：" + rs.getString(1) + "<BR>"; } rs.close(); // 关闭结果集 stmt.close(); // 关闭执行语句对象 conn.close(); // 关闭与数据库的连接 %> <HTML> <BODY> <%=result%> </BODY> </HTML>
通过JNDI获取数据源
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Insert title here</title> </head> <body> <%@ page import="java.sql.*"%> <%@ page import="java.util.*"%> <%@ page import="javax.naming.*"%> <% String result = ""; Context ctx = null; Hashtable ht = new Hashtable(); ht.put(Context.INITIAL_CONTEXT_FACTORY, "weblogic.jndi.WLInitialContextFactory"); ht.put(Context.PROVIDER_URL, "t3://localhost:7001"); Connection conn = null; Statement stmt = null; ResultSet rs = null; try { ctx = new InitialContext(ht); javax.sql.DataSource ds = (javax.sql.DataSource) ctx .lookup("JDBC/CS"); conn = ds.getConnection(); stmt = conn.createStatement(); stmt.execute("select sysdate from dual"); rs = stmt.getResultSet(); while (rs.next()) { result = rs.getString(1); out.println(result); } stmt.close(); stmt = null; conn.close(); conn = null; rs.close(); rs = null; } catch (Exception e) { out.println(e.toString()); } finally { out.println("end"); } %> <%=result%> </body> </html>
278
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
