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
     */
    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());
        }

    }

}