コード例 #1
0
  @Test
  public void testLogin3() {
    String mail = "demo";
    String password = "******";

    BSUserServiceImpl userService = new BSUserServiceImpl();

    User user = null;
    BSDataUtils dau = new BSDataUtils();
    Connection conn = null;
    conn =
        dau.getConnection("org.gjt.mm.mysql.Driver", "localhost", "bsframework", "admin", "root");

    user = userService.login(conn, mail, password);

    assertNull(user);
  }
コード例 #2
0
  @Test
  public void testDB() {
    try {
      BSDataUtils dau = new BSDataUtils();
      Connection conn = null;
      conn = dau.getConnection("org.gjt.mm.mysql.Driver", "localhost", DATABASE, "admin", "root");
      DatabaseMetaData dbmd = (DatabaseMetaData) conn.getMetaData();
      ResultSet rs = dbmd.getTables(DATABASE, null, null, null);

      System.out.println("TABLES:");
      System.out.println("--------------------");
      while (rs.next()) {
        ResultSetMetaData md = rs.getMetaData();
        for (int i = 1; i < md.getColumnCount(); i++) {
          System.out.println(md.getColumnName(i) + "=" + rs.getString(md.getColumnName(i)));
        }
        System.out.println("--------------------");
      }
      rs.close();

      rs = dbmd.getImportedKeys(null, null, TABLE);

      System.out.println("getImportedKeys:");
      System.out.println("--------------------");
      while (rs.next()) {
        ResultSetMetaData md = rs.getMetaData();
        for (int i = 1; i < md.getColumnCount(); i++) {
          System.out.println(md.getColumnName(i) + "=" + rs.getString(md.getColumnName(i)));
        }
        System.out.println("--------------------");
      }
      rs.close();

      System.out.println("getExportedKeys():");
      System.out.println("--------------------");
      rs = dbmd.getExportedKeys(null, null, TABLE);
      while (rs.next()) {
        ResultSetMetaData md = rs.getMetaData();
        for (int i = 1; i < md.getColumnCount(); i++) {
          System.out.println(md.getColumnName(i) + "=" + rs.getString(md.getColumnName(i)));
        }
        System.out.println("----------");
      }
      rs.close();

      System.out.println("getIndexInfo():");
      System.out.println("--------------------");
      rs = dbmd.getIndexInfo(DATABASE, null, TABLE, true, false);
      while (rs.next()) {
        ResultSetMetaData md = rs.getMetaData();
        for (int i = 1; i < md.getColumnCount(); i++) {
          System.out.println(md.getColumnName(i) + "=" + rs.getString(md.getColumnName(i)));
        }
        System.out.println("----------");
      }
      rs.close();

      System.out.println("getPrimaryKeys():");
      System.out.println("--------------------");
      rs = dbmd.getPrimaryKeys(DATABASE, null, TABLE);
      while (rs.next()) {
        ResultSetMetaData md = rs.getMetaData();
        for (int i = 1; i < md.getColumnCount(); i++) {
          System.out.println(md.getColumnName(i) + "=" + rs.getString(md.getColumnName(i)));
        }
        System.out.println("----------");
      }
      rs.close();

      conn.close();
    } catch (SQLException e) {

      e.printStackTrace();
    }
  }