package li.dao.h2;
import java.sql.SQLException;
import javax.sql.DataSource;
import li.annotation.Inject;
import li.ioc.Ioc;
import li.test.BaseTest;
import li.util.Log;
import org.junit.Before;
import org.junit.Test;
public class H2Test extends BaseTest {
private static final Log log = Log.init();
@Inject
Account accountDao;
@Before
public void before() {
Account account = new Account();
account.set("ID", System.currentTimeMillis() / 10000).set("USERNAME", "uuu_" + System.currentTimeMillis()).set("PASSWORD", "ppp").set("EMAIL", "eee").set("STATUS", 1);
accountDao.insert(account);
}
@Test
public void list() {
log.info(accountDao.list(null));
System.out.println(accountDao.getDataSource());
}
// @Test
public void create_table() {
String sql = "CREATE TABLE t_account" + //
"(id int PRIMARY KEY AUTO_INCREMENT," + //
"username varchar(255) UNIQUE NOT NULL ," + //
"password varchar(255) NOT NULL," + //
"email varchar(255) NOT NULL," + //
"status int NOT NULL DEFAULT 1)";
try {
System.out.println(Ioc.get(DataSource.class, "h2").getConnection().prepareStatement(sql).executeUpdate());
} catch (SQLException e) {
e.printStackTrace();
}
}
}