当前位置:数据库 > SYBASE >>

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

package person.fane.test;
/*
 * 创建日期 2005-7-15
 * created by Fane
 */
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
补充:Jsp教程,Java技巧及代码 
Oracle
MySQL
Access
SQLServer
DB2
Excel
SQLite
SYBASE
Postgres
如果你遇到数据库难题:
请访问www.zzzyk.com 试试
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,