Return to Test.java CVS log

Up to [Repository] / FM2SQL / src

Annotation of FM2SQL/src/Test.java, revision 1.1

1.1     ! rogo        1: /*
        !             2:  * Created on 01.12.2004
        !             3:  *
        !             4:  * TODO To change the template for this generated file go to
        !             5:  * Window - Preferences - Java - Code Style - Code Templates
        !             6:  */
        !             7: 
        !             8: /**
        !             9:  * @author rogo
        !            10:  * 
        !            11:  * TODO To change the template for this generated type comment go to Window -
        !            12:  * Preferences - Java - Code Style - Code Templates
        !            13:  */
        !            14: import java.sql.*;
        !            15: 
        !            16: public class Test
        !            17: {
        !            18: 
        !            19:    public static void main(String args[]) throws Exception
        !            20:    {
        !            21: 
        !            22:        Class.forName("acs.jdbc.Driver");
        !            23:        String url = "jdbc:atinav:localhost:7227:D:\\IslamicMSS.mdb";
        !            24:        String username = "Admin";
        !            25:        String password = "";
        !            26:        Connection con = DriverManager.getConnection(url, username, password);
        !            27:      Statement stm = con.createStatement();
        !            28:      stm.setMaxRows(21);
        !            29:      stm.execute("select * from TITLES");
        !            30:      ResultSet result=stm.getResultSet();
        !            31:      int count =0;
        !            32:      while(result.next())
        !            33:      {
        !            34:        System.out.println(result.getString(3)+" "+count);
        !            35:        count++;
        !            36:      }
        !            37:      System.out.println(con);
        !            38:    }
        !            39: }
        !            40: