银行储蓄系统的实现

2、t"action="">

用户ID  

用户名

3、er("id");Stringsname=request.getParameter("name");Stringname=newString(sname.getBytes("iso-8859-1"));Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");Connectioncon=DriverManager.getConnection("jdbc:odbc:ruanjiangongcheng");Statementsql=con.createStatement();ResultSetrs=sql.executeQuery("

4、select*fromcustomerwherecustomerid='"+id+"'andcustomername='"+name+"'");if(rs.next()){out.print("");out.print("");out.print("账号");out.print("用户名");out.print("存款银行");out.print("业务员编号");out.print("

5、dth=70>存款日期");out.print("取款日期");out.print("账户余额");out.print("利息金额");out.print("手续费");out.print("");Stringa,b,c,d,e,f,g,h,i;a=rs.getString(1);out.print(""+a+"");b=rs.getString(2);out.print(""+b+"<

6、/td>");c=rs.getString(3);out.print(""+c+"");d=rs.getString(4);out.print(""+d+"");e=rs.getString(5);out.print(""+e+"");f=rs.getString(6);out.print(""+f+"");g=rs.getString(7);out.print(""+g+"");h=rs.getString(8);out.print(""+h+"");i=

7、rs.getString(9);out.print(""+i+"");out.print("");}elseout.print("输入有误，请重新输入！");con.close();%>通过白盒测试用例对该模块进行测试，截图如下：(1)用户ID= “hw1235”，用户名=“cat”(两个条件都正确)(2)用户ID=“aw1235”，用户名=“cat”(用户名正确)(3)用户ID=“hw1235”，用户名=“bill”(用户ID正确)(4)用户ID=“zg1235”，用户名=“tom”(两个条件都不正确)评价本软件的查询模块能够进行按用户

8、名和ID查