import java.sql.*;
import java.util.Properties;

public class JDBCconnection {

    public static void main(String[] args) throws Exception {
        /*Connection conn =
                DriverManager.getConnection("jdbc:twitter:user=AbhishekJohri2;password=parichay27;");*/

        Class.forName("cdata.jdbc.twitter.TwitterDriver");

        Connection conn =
                DriverManager.getConnection("jdbc:twitter:OAuth Access Token Secret=P3rybaCkgVj4Qdq6RHGREPFvSrWtWWrSvvbIs95OCcxDQ;"
                        + "OAuth Access Token=458089951-uWdPm0IwIjjiDfDPK5I9mmcmRViXkH7WN5F1Vh36;"
                        + "OAuth Client Id=351cSmVczeM8FhQQlSon0GeRX;"
                        + "OAuth Client Secret=MzV0ueB0uBsib3OU6lZ4s3l4Z6RPkemhiYeoIkvqb3WTrnPCgY;");

//      Properties prop = new Properties();
//      prop.setProperty("User","AbhishekJohri2");
//      prop.setProperty("Password","parichay27");
//      prop.setProperty("Location","YYYY");
//      Connection conn = DriverManager.getConnection("jdbc:twitter:",prop);

        Statement stat = conn.createStatement();
        boolean ret = stat.execute("SELECT AbhishekJohri2, From_User_Id FROM Tweets");
        ResultSet rs= stat.getResultSet();
        while(rs.next()){
          for(int i=1;i<=rs.getMetaData().getColumnCount();i++)
          {
            System.out.println(rs.getMetaData().getColumnName(i) +"="+rs.getString(i));
          }
        }
        //boolean ret = stat.execute("SELECT From_User_Name, Text INTO [csv://c:/Tweets.txt] FROM [Tweets]");
        System.out.println(stat.getUpdateCount()+" rows affected");


    }

}