在JAVA中連接Sybase數(shù)據(jù)庫的例子

2019-11-18 13:37:01

字體：大中小

供稿：網(wǎng)友

　　以下是程序代碼:

import java.sql.*;

/**

* A JDBC test application for Sybase

* @author Fane

* @version 1.0.0

* @since JDK1.4

*/

public class SybaseTest {

PRivate final String sybaseDriverName = "com.sybase.jdbc3.jdbc.SybDriver";

private final String sybaseUrlToConnect ="jdbc:sybase:Tds:192.168.0.201:7543/cpemyy?charset=cp850&jconnect_version=3";

private Connection myConnection = null;

/**

* To load the jdbc driver

*

*/

public SybaseTest()

{

    try

    {

        Class.forName(sybaseDriverName);

    }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(sybaseUrlToConnect,"sa","");



    }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) {

    SybaseTest mySybaseTest = new SybaseTest();

    try

    {

        Connection myConnection = mySybaseTest.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(1)+" ");

            myStringBuffer.append(myResultSet.getString(2)+" ");

            myStringBuffer.append(myResultSet.getString(3)+" ");

            myStringBuffer.append(myResultSet.getString(4)+" ");

            myStringBuffer.append(myResultSet.getInt(5)+" ");

            myStringBuffer.append(myResultSet.getInt(6)+" /n");

        }



        System.out.println(new String(myStringBuffer.toString().getBytes("ISO-8859-1"),"GBK"));

    }catch(Exception ex)

    {

        System.out.println(mySybaseTest.getErrorMessage(ex,"Application error,please contact to your Software Designer!").toString());

    }

}

}

上一篇：在JDBC警告的幫助下修正數(shù)據(jù)庫

下一篇：在Java中如何模擬多繼承