* todo 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － java － 代码样式 － 代码模板
 */
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());
        }

    }

}



文章整理：西部数码--专业提供域名注册、虚拟主机服务
http://www.west263.com
以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢!