|
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> |
|
|
|
|
|
|