oracle连接数据库

1.

oracle9.0.1.0.1 客户端连接的配置文件。

 

# TNSNAMES.ORA Network Configuration File: g:/oracle/ora90/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

 

BORDER =

 (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.209)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = orcal)

    )

 )

 

 

 

SQL*Plus: Release 9.0.1.0.1 - Production on 星期二 3月 28 10:19:29 2006

 

(c) Copyright 2001 Oracle Corporation. All rights reserved.

 

 

连接到:

Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production

With the Partitioning option

JServer Release 9.0.1.1.1 - Production

 

SQL>

 

2. 连接数据库。

方法一.

<%@ page contentType = "text/html;charset=gb2312" %>

<%@ page import = "java.sql.*" %>

<%

out.println( "border is me ！ " );

try {

Class.forName( "oracle.jdbc.driver.OracleDriver" ).newInstance();

}

catch (Exception E) {

out.println( "Unable to load driver." );

}

%>

 

方法二。

<%@ page contentType="text/html;charset=gb2312" %>

<%

java.sql.Connection conn;

java.lang.String strConn;

Class.forName( "oracle.jdbc.driver.OracleDriver" ).newInstance();

conn= java.sql.DriverManager.getConnection( "jdbc:oracle:thin:@192.168.1.209:1521:orcal" , "system" , "manager" );

out.println( "border is me ！ " ); 

%>

 

方法三、javabean ：

package com.yourcompany.struts;

import java.sql.*;     // 完成环境设置，导入java.sql 包

public class dbconn {

 public dbconn()

 {

 }

 //declare variable

 private Connection conn = null;

 private ResultSet rs = null;

 

 private String server = "192.168.1.209";     // Can't use localhost , you must use IP or CNAME

 private String port = "1521";               //change to your port

 private String db = "orcal";  //change to your db name

 private String user = "system";     //change to your username

 private String pass = "manager"; //change to your password

 private String drivername="oracle.jdbc.driver.OracleDriver";     //mysql driver

 private String URL="jdbc:oracle:thin:@"+server+":"+port+":"+db;

 

 public Connection getConn(){ //get database connection

 try{

     Class.forName(drivername).newInstance();       //载入驱动器

     conn = DriverManager.getConnection(URL,user,pass);     //连接到数据库

   }

 catch(Exception e){

   e.printStackTrace();

 }

   return conn ;

 }

 public ResultSet executeSQL(String str) {

 try{

   Statement stmt = conn.createStatement();      //语句接口

   rs = stmt.executeQuery(str);          //获得结果集

 }

 catch(Exception e){

   e.printStackTrace();

 }

   return rs;

 }

}

 

 

<%@ page contentType="text/html;charset=GBK" import="java.sql.*"%>

<jsp:useBean id="Border" scope="page" class="com.yourcompany.struts.dbconn" />

<%

ResultSet rs = null ;

Connection conn = null ;

conn = Border.getConn() ;  

rs = Border.executeSQL( "select * from addressbook_table" );

%>

< html >

  < body >

    < h2 align = "center" > My first Jsp JavaBean Mysql </ h2 >

    < table border = "1" align = "center" >

       < tr >

           < th > id </ th >

           < th > name </ th >

           < th > phone </ th >

       </ tr >

       <%

       while (rs.next()) {

       %>

       < tr >    < th > <%= rs.getString( "id" ) %> </ th >

                < th > <%= rs.getString( "name" ) %> </ th >

                < th > <%= rs.getString( "phone" ) %> </ th >

       </ tr >

       <% } %>

       <%

       rs.close();

       conn.close();

       %>

      </ table >

  </ body >

</ html >