package  samplecode;

 import  com.sybase.jdbc3.jdbc.SybDriver;
 import  java.io.*;
 import  java.sql.*;
  
    public   class  SampleCode
   {
        public   static   void  main(String args[])
       {
            try 
           {
           /*
            * Open the connection. May throw a SQLException.
            */
                SybDriver sybDriver =  null ;
        // Force the Sybase jdbc driver to be loaded
                 Class  c =  Class .forName("com.sybase.jdbc3.jdbc.SybDriver");
                sybDriver = (SybDriver) c.newInstance();              
                DriverManager.registerDriver(sybDriver);
               Connection con = DriverManager.getConnection(
                  "jdbc:sybase:Tds:10.2.150.209:3767?ServiceName=DBname", "ro_user", "qwerty");
           /*                                //3767 2638c
            * Create a statement object, the container for the SQL
            * statement. May throw a SQLException.
            */
              Statement stmt = con.createStatement();
           /*
            * Create a result set object by executing the query.
            * May throw a SQLException.
            */
              ResultSet rs = stmt.executeQuery("Select 1");
           /*
            * Process the result set.
            */
               if  (rs.next())
              {
                  int  value = rs.getInt( 1 );
                 System.out.println("Fetched value " + value);
              }
            rs.close();
            stmt.close();
            con.close();
          }//end try
      /*
       * Exception handling.
       */
           catch  (SQLException sqe)
          {
              System.out.println("Unexpected exception : " +
                          sqe.toString() + ", sqlstate = " +
                              sqe.getSQLState());
              sqe.printStackTrace();
              System.exit( 1 );
          }//end catch
           catch  (Exception e)
          {
              e.printStackTrace();
              System.exit( 1 );
          }//end catch

          System.exit( 0 );
      }
  }