<%@ page contentType="text/html; charset=GBK" %>
<%@ page import ="java.sql.*" %><%
String DBDriver = "oracle.jdbc.driver.OracleDriver";
//String DBLocation = "jdbc:oracle:thin:@172.16.58.100:1521:orc1";String DBLocation = "jdbc:oracle:thin:@211.138.113.26:1521:orc1";
String DBUser = "test";
String DBPwd = "test";Class.forName(DBDriver);
Connection conn = DriverManager.getConnection(DBLocation, DBUser, DBPwd);
String sql = "select * from dual";
Statement stmt = conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
rs.next();
out.println(rs.getString(1));%>要把jdbc包含到你的classpath中
在jsp中就是WEB-INF/classes/下
<%@ page import ="java.sql.*" %><%
String DBDriver = "oracle.jdbc.driver.OracleDriver";
//String DBLocation = "jdbc:oracle:thin:@172.16.58.100:1521:orc1";String DBLocation = "jdbc:oracle:thin:@211.138.113.26:1521:orc1";
String DBUser = "test";
String DBPwd = "test";Class.forName(DBDriver);
Connection conn = DriverManager.getConnection(DBLocation, DBUser, DBPwd);
String sql = "select * from dual";
Statement stmt = conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
rs.next();
out.println(rs.getString(1));%>要把jdbc包含到你的classpath中
在jsp中就是WEB-INF/classes/下
解决方案 »
- IK Analyzer - Lucene
- hibernate4.0+c3p0的配置问题
- java.io.FileNotFoundException:
- 蛋疼问题(Java Web开发) 关于HTML Java Jsp JavaScript 之间的联系.跪求大侠!!!
- 关于OpenSSL中客户证书的签发
- 关于freemarker.properties自动导入ftl我无效的问题
- Myeclipse6 下面,加入Struts或者Hibernate支持,如何讓項目文件目錄lib下馬上也添加進相關的jar包,默認是沒有馬上加入的,而是發布之時
- JSP求助,我用别人的系统,在我的机子上调试出现问题
- 一个关于ArrayList的问题,求大虾帮我看看错在那里?
- POI如何让表格边框显示出来.
- 关于 时间处理问题,在线等待。
- JSP里的恶心问题,N天了也没解决,我就不相信没人能解决
import java.sql.*;
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
String url = "jdbc:oracle:oci8:@";
try {
String url1 = System.getProperty("JDBC_URL");
if (url1 != null)
url = url1;
} catch (Exception e) { // If there is any security exception, ignore it and use the default
}
Connection conn =
DriverManager.getConnection (url, "scott", "tiger");
注意:All the drivers(thin, jdbc-oci and jdbc-kprb) could be used with thin driver just by changing the connect string.