java – 使用DAO和Web服务的数据库插入方法的Junit测试用例

Course.java

public class Course {

    private String courseName;
    private String location;
    private String courseId;


       public String getCourseId()
               {
        return courseId;
            }

    public void setCourseId(String courseId) {
        this.courseId = courseId;
    }

    public String getCourseName() {
        return courseName;
    }

    public void setCourseName(String courseName) {
        this.courseName = courseName;
    }

        public String getLocation() {
        return location;
    }
    public void setLocation(String location) {
        this.location = location;
    }
}

然后另一个文件如下

CourseDaoImpl.java

public class CourseDaoImpl implements IDao {
   Connection conn = null;
   Statement stmt = null;

public CourseDaoImpl(){

try {
    Class.forName("com.MysqL.jdbc.Driver").newInstance();
    conn = DriverManager.getConnection(
            "jdbc:MysqL://localhost:3306/univesitydb","root","root");
    stmt = conn.createStatement();

    if (!conn.isClosed())
        System.out.println("Successfully connectiod");
} catch (sqlException e) {
    e.printstacktrace();
} catch (InstantiationException e) {
    e.printstacktrace();
} catch (illegalaccessexception e) {
    e.printstacktrace();
} catch (ClassNotFoundException e) {
    e.printstacktrace();
}
}

      @Override
  public String add(Object object) {

Course c = (Course) object ;

String courseId = c.getCourseId();
String courseName = c.getCourseName();
String location = c.getLocation();

String result = "";
int rowcount;

try {
    String query = "Insert into course (courseId,courseName,location) values"
            + " ('"
            + courseId
            + "','"
            + courseName
            + "','"
            + location
            + "')";
    rowcount = stmt.executeUpdate(query);
    if (rowcount > 0) {
        result = "true";
        System.out.println("Course inserted successful");
    } else {
        result = "false:The data Could not be inserted in the databse";
    }
} catch (sqlException e) {
    e.printstacktrace();
}

return result;
}

第三个是如下的Web服务文件,它与前两个交互并将数据添加到数据库.

CourseService.java

package edu.service;

          import edu.dao.IDao;
          import edu.dao.impl.CourseDaoImpl;
          import edu.db.entity.Course;

       public class CourseService {

     public String addCourse(String courseId,String courseName,String location)
    {   
       Course c = new Course();
       c.setCourseId(courseId);
       c.setCourseName(courseName);
       c.setLocation(location);     
       IDao dao = new CourseDaoImpl();
       return dao.add(c);   
     }

查看我的代码清单,任何机构都可以建议我如何为我的add方法编写测试用例.我是JAVA的初学者,我从朋友那里学习了这个java部分,现在需要为我的数据库方法实现Junit测试,比如上面的添加课程.

请提出一些我可以学习,阅读和使用的东西来实现我的数据库方法的Junit测试.