Advertisement
Guest User

Untitled

a guest
May 18th, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.47 KB | None | 0 0
  1. java.lang.Error: Unresolved compilation problem:    The method insertSprint(String, Date, Date, long, int) in the type MySQL is not applicable for the arguments (String, Date, Date, long, int)
  2.  
  3.  
  4. public static void insertSprint(String name, java.sql.Date start, java.sql.Date end,long duration, int proj_ID){
  5.         Connection con=null;
  6.         PreparedStatement pstmt = null;
  7.         try{
  8.             Class.forName("com.mysql.jdbc.Driver");
  9.             con=DriverManager.getConnection("jdbc:mysql://localhost:3306/Collabsoft","root","");
  10.             String query ="Insert into sprints (Title,Start_Date,End_Date,Duration,Proj_ID) values (?,?,?,?,?)";
  11.             pstmt = (PreparedStatement) con.prepareStatement(query);
  12.               pstmt.setString(1, name); // set input parameter 1
  13.               pstmt.setDate(2, start); // set input parameter 2
  14.               pstmt.setDate(3, end);
  15.               pstmt.setLong(4, duration); // set input parameter 3
  16.               pstmt.setInt(5, proj_ID);
  17.               pstmt.executeUpdate();
  18.            
  19.         }
  20.  
  21.  
  22.  
  23. protected void onSubmit()
  24.             {
  25.                 String s_Name=(String)sprint.getObject();
  26.                 Date s_Date=(Date)start_Date.getObject();
  27.                 Date e_Date=(Date)end_Date.getObject();
  28.                 long diff = e_Date.getTime()-s_Date.getTime();
  29.                 long days = diff/(1000 * 60 * 60 * 24);
  30.                 int proj_id=1;
  31.                 if(s_Name!=null && s_Date!=null && e_Date!=null)
  32.                 {
  33.                     MySQL.insertSprint(s_Name, s_Date, e_Date, days, proj_id);
  34.                     SprintResult sprintResult = new SprintResult(s_Name,days);
  35.                     setResponsePage(sprintResult);
  36.                    
  37.                 }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement