001: package com.bostechcorp.cbesb.console.server.test;
002:
003: import java.sql.Timestamp;
004:
005: import junit.framework.TestCase;
006:
007: import com.bostechcorp.cbesb.common.util.runtimedb.DaoConfig;
008: import com.bostechcorp.cbesb.common.util.runtimedb.vo.ConsoleUserVO;
009: import com.bostechcorp.cbesb.console.common.ConsoleUserListVO;
010: import com.ibatis.sqlmap.client.SqlMapClient;
011:
012: public class TestDB extends TestCase {
013:
014: public void testInsert() {
015: SqlMapClient sqlMap = null;
016: try {
017: DaoConfig consoleUserDaoConfig = new DaoConfig();
018: sqlMap = consoleUserDaoConfig.getSqlMapInstance();
019: ConsoleUserVO userVO = new ConsoleUserVO();
020: userVO.setName("John");
021: userVO.setEmail("lp.zje ");
022: userVO.setPassword("kk");
023: userVO.setLastUpdated(new Timestamp(System
024: .currentTimeMillis()));
025: userVO.setLogin("kkk");
026: userVO.setType("admin");
027: sqlMap.insert("insertUser", userVO);
028: } catch (Exception e) {
029: System.out.println(e.toString());
030: }
031: }
032:
033: public void testUpdate() {
034: SqlMapClient sqlMap = null;
035: try {
036: DaoConfig DaoConfig = new DaoConfig();
037: sqlMap = DaoConfig.getSqlMapInstance();
038: ConsoleUserVO userVO = new ConsoleUserVO();
039: userVO.setName("Eugeniu");
040: userVO.setEmail("Eugeniu");
041: userVO.setPassword("Eugeniu");
042: userVO.setLogin("Eugeniu");
043: userVO.setType("Eugeniu");
044: userVO.setLastUpdated(new Timestamp(System
045: .currentTimeMillis()));
046: sqlMap.update("updateUserById", userVO);
047: } catch (Exception e) {
048: System.out.println(e.toString());
049: }
050: }
051:
052: public void testSelectOne() {
053: SqlMapClient sqlMap = null;
054: try {
055: DaoConfig DaoConfig = new DaoConfig();
056: sqlMap = DaoConfig.getSqlMapInstance();
057: ConsoleUserVO userVO = (ConsoleUserVO) sqlMap
058: .queryForObject("selectUserByLogin", "Eugeniu");
059: System.out.println(userVO.toString());
060: } catch (Exception e) {
061: System.out.println(e.toString());
062: }
063: }
064:
065: public void testSelectAll() {
066: SqlMapClient sqlMap = null;
067: try {
068: DaoConfig DaoConfig = new DaoConfig();
069: sqlMap = DaoConfig.getSqlMapInstance();
070: ConsoleUserListVO userVO = new ConsoleUserListVO();
071: userVO.setUserList(sqlMap.queryForList("selectAll", null));
072: System.out.println(userVO.toString());
073: } catch (Exception e) {
074: System.out.println(e.toString());
075: }
076: }
077:
078: public void testAuthenticate() {
079: SqlMapClient sqlMap = null;
080: try {
081: DaoConfig DaoConfig = new DaoConfig();
082: sqlMap = DaoConfig.getSqlMapInstance();
083: ConsoleUserVO userVO = (ConsoleUserVO) sqlMap
084: .queryForObject("selectUserByLogin", new String(
085: "Eugeniu"));
086: System.out.println(userVO.toString());
087: } catch (Exception e) {
088: System.out.println(e.toString());
089: }
090: }
091:
092: public void testDelete() {
093: SqlMapClient sqlMap = null;
094: try {
095: DaoConfig DaoConfig = new DaoConfig();
096: sqlMap = DaoConfig.getSqlMapInstance();
097: ConsoleUserVO userVO = new ConsoleUserVO();
098: userVO.setUserId(1);
099: sqlMap.update("delteUser", userVO);
100: } catch (Exception e) {
101: System.out.println(e.toString());
102: }
103: }
104: }
|