| 发表于:2007-09-03 13:44:14 楼主 |
第一次使用junit这个工具 我有一个函数,主要是 根据输入的日期 对数据库 进行检索,将结果显示在页面上请问大哥们,如何对这个函数进行ut? 函数被调用如下 if(operation.saveaction(datemanageform,request)){.....} 函数如下 public boolean saveaction(f00009form datemanageform, httpservletrequest request){ //db操作实例化 dbcommon db = new dbcommon(); //得到查询中得到的list值 list datalist = datemanageform.getstrutsaction(); //考试id string testid = datemanageform.gettestid(); //学科id string subjectid = datemanageform.getsubjectid(); //考试日期 string testdate = datemanageform.gettestdate(); //考试区分 string testdiff; //考试区分要进行相应处理 if( "one ".equals(datemanageform.gettestdiff())) testdiff= "1 "; else testdiff= "0 "; //实例化strutsdata strutsdata sd = new strutsdata(); //初始化考试id sd.settestid(testid); //初始化学科id sd.setsubjectid(subjectid); //初始化考试日期 sd.settestdate(testdate); //初始化考试区分 sd.settestdiff(testdiff); //实例化stringbuffer stringbuffer sb = new stringbuffer(); //sql语句 sb.append( "insert into testschedule " ); sb.append( "( " ); sb.append( "test_id " ); sb.append( ", " ); sb.append( "subject_id " ); sb.append( ", " ); sb.append( "test_date " ); sb.append( ", " ); sb.append( "test_division " ); sb.append( ") " ); sb.append( "values " ); sb.append( "( " ); sb.append( " ' " ); sb.append(testid); sb.append( " ' " ); sb.append( ", " ); sb.append( " ' " ); sb.append(subjectid); sb.append( " ' " ); sb.append( ", " ); sb.append( " ' " ); sb.append(testdate); sb.append( " ' " ); sb.append( ", " ); sb.append( " ' " ); sb.append(testdiff); sb.append( " ' " ); sb.append( ") " ); //数据库连接 connection conn=null; if (!datemanageform.getisjunit()) { conn = db.openconnection(); } else { conn = db.junitopenconnection(); } statement st = null; try{ st = conn.createstatement(); //执行数据库操作 st.EXECuteupdate(sb.tostring()); db.commit(); //往session加入数值,页面显示操作结果 httpsession session = request.getsession(); session.setattribute( "dbmessage ", "保存成功 "); } catch(exception ex){ //退回防止数据被死锁 db.rollback(); //在日志中设置错误信息 logconst.seterrormsg(this.getclass().getname(),ex.getmessage()); //往session加入数值,页面显示操作结果 httpsession session = request.getsession(); session.setattribute( "dbmessage ", "保存失败 "); //返回错误,跳转 return false; } finally{ try { st.close(); conn.close(); } catch (sqlexception e) { //在日志中设置错误信息 logconst.seterrormsg(this.getclass().getname(),e.getmessage()); e.printstacktrace(); return false; } } //往list中添加插入的数值 //datalist.add(sd); //设置form中添加list,这样就可以保存到session //datemanageform.setstrutsaction(datalist); return true; } |
|
|
|
|