<%@ page contentType="text/html;charset=gb2312"%> <%@ page import="java.sql.*"%> <%Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); String url="jdbc:oracle:thin:@localhost:1521:myoracle"; //orcl为你的数据库的SID String user="system"; String password="manager"; Connection conn= DriverManager.getConnection(url,user,password); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); %>
解决方案 »
- 请诸位高手点拨:现在的ISP运营商,面向自己的ICP,分成的行价是多少?谢谢高手!!
- 【求救】在Liferay 6.0当中开发Struts 2 Portlet的跳转问题
- 特急!Unable to compile class for JSPNote: sun.tools.javac.Main has been deprecated
- 奇怪的FTP服务器 文件修改时间 的问题
- Struts-config.xml文件Action元素的foreward子元素的设置问题
- message bean发布的问题
- hibernate出现read Resource error mychild.hbm.
- 请大家比较一下jboss与weblogic的优缺点,来者有份!
- 请教两个基础的 Java 问题
- 设计一对多表关系的时候 大家设置外键了吗 我觉得设置不设置外键都无所谓啊
- JSP与ACCESS连接的问题
- 关于jsp连接oracle数据库的问题,谢谢帮忙!!
import javax.naming.*; public class DBconn { java.sql.Connection Conn = null;
javax.sql.DataSource ds = null;
java.sql.ResultSet rs = null; public DBconn() {
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@10.25.4.20:1521:dbname";
String user="test";
String password="test";
Conn= DriverManager.getConnection(url,user,password); }catch(Exception e) {
Conn = null;
System.out.print("Error To Create Connection");
}
}
public ResultSet executeQuery(String sql) {
rs=null;
try {
Statement stmt=Conn.createStatement();
rs=stmt.executeQuery(sql);
} catch (SQLException ex) {
Conn = null ;
rs = null;
System.err.println("aq.execute-Query: "+ex.getMessage());
}
return rs; } }
import java.sql.*;
import javax.naming.*; public class DBconn { java.sql.Connection Conn = null;
javax.sql.DataSource ds = null;
java.sql.ResultSet rs = null; public DBconn() {
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@10.25.4.20:1521:dbname";
String user="test";
String password="test";
Conn= DriverManager.getConnection(url,user,password); }catch(Exception e) {
Conn = null;
System.out.print("Error To Create Connection");
}
}
public ResultSet executeQuery(String sql) {
rs=null;
try {
Statement stmt=Conn.createStatement();
rs=stmt.executeQuery(sql);
} catch (SQLException ex) {
Conn = null ;
rs = null;
System.err.println("aq.execute-Query: "+ex.getMessage());
}
return rs; } }
jsp页面:
<%@ page contentType="text/html;charset=gb2312"%> <%@ page import="java.sql.*"%>
<%jsp:useBean id="随便起个bean名" class="opendb.opendb1"%>//opendb1为编译的class,