氧气中毒 - J2EE

爪吐奕奕征途
posts - 24, comments - 10, trackbacks - 0, articles - 0
   :: 首页 :: 新随笔 ::  ::  :: 管理

在JAVA中连接Oracle数据库(例子)

Posted on 2006-06-14 15:03 氧气中毒 阅读(265) 评论(0)  编辑  收藏 所属分类: 数据处理
/*
 * 创建日期 2006-6-13
 *
 * java连接oracle数据库
 
*/

package  person.fane.test;

import  java.sql. * ;
/**
 * A JDBC test application for Oracle
 * 
@author  Fane
 * 
@version  1.0.0
 * 
@since  JDK1.4
 
*/

public   class  OracleTest  {
    
private   final  String oracleDriverName  =   " oracle.jdbc.driver.OracleDriver " ;
    
    
// 以下使用的Test就是Oracle里的表空间
     private   final  String oracleUrlToConnect  = " jdbc:oracle:thin:@192.168.0.36:1521:Test "
    
private  Connection myConnection  =   null ;
    
/**
     * To load the jdbc driver
     * 
     
*/

    
public  OracleTest()
    
{
        
try
        
{
            Class.forName(oracleDriverName);
        }
catch (ClassNotFoundException ex)
        
{
            System.out.println(getErrorMessage(ex,
" The Driver loaded error,please contact to your Software Designer! " ).toString());
        }

    }

    
    
public  StringBuffer getErrorMessage(Exception ex,String alarmMessage)
    
{
        StringBuffer errorStringBuffer 
=   new  StringBuffer();
        errorStringBuffer.append(alarmMessage);
        errorStringBuffer.append(ex.getMessage());
        
return  errorStringBuffer;
    }

    
    
/**
     * getConnection method 
     * 
@return  Connection
     
*/

    
public  Connection getConnection()
    
{
        
try
        
{
            
this .myConnection  =  DriverManager.getConnection(oracleUrlToConnect, " Fane " , " 201 " );
            
        }
catch (Exception ex)
        
{
            System.out.println(getErrorMessage(ex,
" Can not get connection,please contact to your Software Designer! " ).toString());
        }

        
        
return   this .myConnection;
        
    }

    
    
/**
     * 
@param  args
     
*/

    
public   static   void  main(String[] args)  {
        OracleTest myOracleTest 
=   new  OracleTest();
        
try
        
{
            Connection myConnection 
=  myOracleTest.getConnection();

            System.out.println(
" Now begin to excute. " );
        
            PreparedStatement myPreparedStatement 
=  myConnection.prepareStatement( " select area_id, area_name,ip_address,tel,area_type,pc_id from c_area_info " );
            
// myPreparedStatement.setInt(1,2);
            ResultSet myResultSet  =  myPreparedStatement.executeQuery();
            StringBuffer myStringBuffer 
=   new  StringBuffer();
            
            
while (myResultSet.next())
            
{
                
                myStringBuffer.append(myResultSet.getInt(
" area_id " ) + "    " );
                myStringBuffer.append(myResultSet.getString(
" area_name " ) + "    " );
                myStringBuffer.append(myResultSet.getString(
" ip_address " ) + "    " );
                myStringBuffer.append(myResultSet.getString(
" tel " ) + "    " );
                myStringBuffer.append(myResultSet.getInt(
" area_type " ) + "    " );
                myStringBuffer.append(myResultSet.getInt(
" pc_id " ) + " \n " );
            }

            System.out.println(myStringBuffer.toString());
            
// System.out.println(new String(myStringBuffer.toString().getBytes("ISO-8859-1"),"GBK"));
        }
catch (Exception ex)
        
{
            System.out.println(myOracleTest.getErrorMessage(ex,
" Application error,please contact to your Software Designer! " ).toString());
        }


    }


}

只有注册用户登录后才能发表评论。


网站导航: