Junit单元测试简单小例子

一、编写一个web程序

      本文根据工作实际项目，编写一个web程序：实现防伪码查询页面，输入防伪码，点击查询，查询数据库并作出判断，将结果显示在查询页面。

 

      1、需要添加的buildpath：ojdbc14.jar\classes12.jar

      2、编写searchresult.jsp文件：（刚入门格式不规范） 

 1 <%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
 2 <!--%
 3     String path = request.getContextPath();
 4     String basePath = request.getScheme() + "://"
 5             + request.getServerName() + ":" + request.getServerPort()
 6             + path + "/";
 7 %>-->
 8 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
 9 <%@ page import="java.sql.*"%>
10 <%@ page import="testsample001.check"%>
11 <html>
12 <head>
13 <!--base href="<!--%=basePath%>">-->
14 <title>查询结果</title>
15 <meta http-equiv="pragma" content="no-cache">
16 <meta http-equiv="cache-control" content="no-cache">
17 <meta http-equiv="expires" content="0">
18 <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
19 <meta http-equiv="description" content="This is my page">
20 <!--<link rel="stylesheet" type="text/css" href="styles.css"> -->
21 </head>
22 <body>
23     <br>
24     <br>
25     <br>
26     <table>
27         <tr>
28             <td>
29                 <form action="/testsample001/testservlet" method="post">
30                     防伪码
31                     <!--input name="fangweima" id="t1" type="text">-->
32                     <!--input name="searchbtn" type="button" value='查询' onclick="check1()">-->
33                     <!--input name="result" id="t2" type="text"-->
34                     <input type="text" id="t1" name="t1" value="<%=session.getAttribute("t1")%>" /> 
35                     <!--input type="text" id="t2" name="t2" value="<%=session.getAttribute("t2")%>"/>-->
36                     <input type="submit" value="查询"/>
37                     <br>
38                     查询结果：<%=session.getAttribute("t2")%>;
39                 </form>
40             </td>
41         </tr>
42     </table>
43 </body>
44 </html>
View Code

      3、编写check.java文件

 1 package testsample001;
 2 
 3 import java.sql.Connection;
 4 import java.sql.DriverManager;
 5 import java.sql.ResultSet;
 6 import java.sql.SQLException;
 7 import java.sql.Statement;
 8 
 9 public class check {
10     private Connection con;
11     private String user = "deejuser";
12     // private String user = "sys as sysdba";
13     private String password = "deejuser";
14     private String className = "oracle.jdbc.driver.OracleDriver";
15     // private String url="jdbc:oracle:oci@localhost:1158:orcl";这个url可能无效
16     private String url = "jdbc:oracle:thin:@zs-PC:1521:ytdf";
17 
18     public String ConnectOracle(String productno) {
19         try {
20             Class.forName(className);
21             // System.out.println("加载数据库驱动成功！");
22             // System.out.println(productno);
23             String resultInfo = getCon(productno);
24             closed();
25             return resultInfo;
26         } catch (ClassNotFoundException e) {
27             // System.out.println("加载数据库驱动失败！");
28             e.printStackTrace();
29             return "加载数据库驱动失败！";
30         }
31     }
32 
33     /** 创建数据库连接 */
34     // public Connection getCon(String productno) {
35     public String getCon(String productno) {
36         try {
37             con = DriverManager.getConnection(url, user, password);
38             // System.out.println("创建数据库连接成功！");
39             Statement stmt = con
40                     .createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
41                             ResultSet.CONCUR_UPDATABLE);
42             String sql = "select * from product t where t.packagsn="
43                     + productno;
44             // System.out.print(sql);
45             ResultSet rs = stmt.executeQuery(sql);
46             if (rs.next())
47                 return "防伪码存在！";
48             else
49                 return "防伪码不存在！";
50         } catch (SQLException e) {
51             // System.out.print(con);
52             // System.out.println("创建数据库连接失败！");
53             con = null;
54             e.printStackTrace();
55             return "数据库连接失败！";
56         }
57         // return con;
58     }
59 
60     public void closed() {
61         try {
62             if (con != null) {
63                 con.close();
64             }
65         } catch (SQLException e) {
66             System.out.println("关闭con对象失败！");
67             e.printStackTrace();
68         }
69     }
70 }
View Code

      4、编写testservlet.java文件

 1 package testsample002;
 2 
 3 import java.io.IOException;
 4 
 5 import javax.servlet.ServletException;
 6 import javax.servlet.annotation.WebServlet;
 7 import javax.servlet.http.HttpServlet;
 8 import javax.servlet.http.HttpServletRequest;
 9 import javax.servlet.http.HttpServletResponse;
10 
11 import testsample001.check;
12 
13 /**
14  * Servlet implementation class testservlet
15  */
16 @WebServlet("/testservlet")
17 public class testservlet extends HttpServlet {
18     private static final long serialVersionUID = 1L;
19 
20     /**
21      * @see HttpServlet#HttpServlet()
22      */
23     public testservlet() {
24         super();
25         // TODO Auto-generated constructor stub
26     }
27 
28     /**
29      * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse
30      *      response)
31      */
32     protected void doGet(HttpServletRequest request,
33             HttpServletResponse response) throws ServletException, IOException {
34         // TODO Auto-generated method stub
35     }
36 
37     /**
38      * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse
39      *      response)
40      */
41     protected void doPost(HttpServletRequest request,
42             HttpServletResponse response) throws ServletException, IOException {
43         // TODO Auto-generated method stub
44         String value = request.getParameter("t1");// 获取前台页面传递过来的数据
45         // request.getSession(false).setAttribute("t1", value);// 将数据放到session中
46         check connor = new check();
47         String resultInfo = connor.ConnectOracle(value);
48         request.getSession(false).setAttribute("t2", resultInfo);// 将数据放到session中
49         request.getSession(false).setAttribute("t1", value);
50         response.sendRedirect("/testsample001/searchresult.jsp");// 跳转回提交的页面
51 
52     }
53 
54 }
View Code

      5、设置项目的起始页面（tomcat服务配置-web.xml）

1     <welcome-file-list>
2         <welcome-file>index.html</welcome-file>
3         <welcome-file>index.htm</welcome-file>
4         <welcome-file>searchresult.jsp</welcome-file>
5     </welcome-file-list>
View Code

       6、实现结果：

 

        7、导出jar包（在要生成jar的项目上右击，选择菜单上的Export(导出)），导出oracleconnect.jar

            具体详细步骤参考：http://blog.csdn.net/guanmjie/article/details/4437779

二、Junit测试查询功能

        1、新建一个java项目：JunitTestSample001

        2、导入jar包：ojdbc14.jar\classes12.jar\oracleconnect.jar

        3、配置junit：详细步骤参考：http://www.cnblogs.com/shuaijie/articles/5731459.html 

            选择Libraries，点击Add variable按钮，输入变量名JUNIT_LIB，路径：E:\测试\测试工具\Juint\eclipse\eclipse-jee-kepler-SR2-win32\eclipse\plugins\org.junit_4.11.0.v201303080030，结果如下图：

 

          4、新建junit test case：JunitTest001.java

 1 package JunitTestSample001;
 2 
 3 import junit.framework.TestCase;
 4 
 5 import org.junit.After;
 6 import org.junit.Before;
 7 import org.junit.Test;
 8 
 9 import testsample001.check;
10 
11 public class JunitTest001 extends TestCase {
12 
13     @Before
14     public void setUp() throws Exception {
15         super.setUp();
16     }
17 
18     @After
19     public void tearDown() throws Exception {
20         super.tearDown();
21     }
22 
23     @Test
24     public void testsearchresult() {
25         // fail("Not yet implemented");
26         check cooner = new check();
27         cooner.ConnectOracle("1");
28         assertEquals("查询结果匹配情况", "防伪码存在！", cooner.ConnectOracle("1"));
29 
30     }
31 }
View Code

          5、运行JunitTest001.java（Run As-Junit test），运行结果如下：

 

posted @ 2016-08-10 16:09  帅姐  阅读(12979)  评论(0)  编辑  收藏  举报