@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);
}
@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();
}
}