import java.sql.*;
import java.util.Calendar;
import java.text.SimpleDateFormat;


class pgsql_test {
  public static void main(String args[]) {

  	String username;
  	String name;
  	String android_id;
  	int const_id;
  	int app_id;
  	String terminal_name;
    try {
      //JDBCドライバのロード
      //Class.forName("org.postgresql.Driver");
      //各設定
      String url = "jdbc:postgresql://192.168.100.153:5432/ansys";
      String user = "postgres";
      String pass = "postgres";

      //データベースに接続
      Connection con = DriverManager.getConnection(url,user,pass);

      System.out.println("接続成功");

	Calendar now = Calendar.getInstance(); //インスタンス化
	SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
	
	
	// SQLコンテナの作成
    Statement stmt = con.createStatement();
    //String sql_i = "INSERT INTO qgis.ts_terminal_test(android_id,const_id,app_id,terminal_name,upddatetime,regdatetime) VALUES('abckkk',1,15,'テスト端末','2015-01-19 18:20:00','2015-01-19 18:20:00')";
/*
    // SQL文の実行 (挿入)
    int i = 0;
    int num = 0;
    for(i = 0;i < 100;i++)
    {
    	String sql_i = "INSERT INTO qgis.ts_terminal_test(android_id,const_id,app_id,terminal_name,upddatetime,regdatetime) VALUES('abckkk'," + i +",15,'テスト端末','2015-01-19 18:20:00','2015-01-19 18:20:00')";
    	num = stmt.executeUpdate(sql_i);
    }
    
    System.out.println("登録件数 : " + num);
*/
	// テーブル照会実行
    String sql_s = "SELECT * FROM qgis.ts_terminal";
            ResultSet rs = stmt.executeQuery (sql_s);
            // テーブル照会結果を出力
            while(rs.next()){
               android_id = rs.getString("android_id");
               const_id = rs.getInt("const_id");
               app_id = rs.getInt("app_id");
               terminal_name = rs.getString("terminal_name");
               System.out.println(android_id + "---" + const_id + "---" + app_id + "---" + terminal_name);
            }


      //データベースを切断
      con.close();

    } catch (Exception e) {
      System.out.println("例外発生：" + e );
    }
  }
}