java - - The method setString(int, String) in the type PreparedStatement is not applicable for the arguments (String, String, String, String, String, -

i hav written method want write set method gives me error saying - method setstring(int, string) in type preparedstatement not applicable arguments (string, string, string, string, string, )my code given below package com.glomindz.mercuri.dao;

import java.sql.connection; import java.sql.preparedstatement; import java.sql.resultset; import java.sql.sqlexception; import java.util.arraylist; import java.util.list;   import com.glomindz.mercuri.pojo.user;  import com.glomindz.mercuri.util.mysingleton;   public class userservicesdao {  private connection connection;  public userservicesdao() {     // connection = new mysingleton().getconnection();     connection = mysingleton.getinstance().getconnection();  }  public list<user> get_all_data() {     list<user> userslist = new arraylist<user>();     try {         preparedstatement stmt = connection.preparestatement("insert              spl_user_master(name,email,mobile,password,role,status,last_update)values(?,?,?,?,?,?,?)");          stmt.setstring("charlie sheen","help@glomindz.com","9654087107","cbf51a71a11d7ec348b0d7e9b2f0055f","admin","3","null");          boolean execute = stmt.execute();         system.out.println(execute);         resultset resultset = stmt.getresultset();         system.out.println(resultset.getmetadata());         while (resultset.next()) {             user user = new user();             user.setid(resultset.getint("id"));             user.setname(resultset.getstring("name"));             user.setemail(resultset.getstring("email"));             user.setmobile(resultset.getstring("mobile"));             user.setpassword(resultset.getstring("password"));             user.setrole(resultset.getstring("role"));             user.setstatus(resultset.getstring("status"));             user.setlast_udpate(resultset.getstring("last_update"));             userslist.add(user);         }     }       catch (sqlexception e) {         // todo auto-generated catch block         e.printstacktrace();     }     return userslist;  }  public static void main(string[] args) {     userservicesdao userdao = new userservicesdao();     list<user> data = userdao.get_all_data();     system.out.println(data);     system.exit(0); } 

} user class package com.glomindz.mercuri.pojo;

     public class user {  private int  id;       private string  name;  private string  email;  private string  mobile;  private string  password;  private string  role;  private string  status;  private string  last_update;  public int getid() {     return id; }  public void setid(int id) {     this.id = id; }  public string getname() {   return name;  }   public void setname(string name) {   name = name;  }    public string getemail() {   return email;  }    public void setemail(string email) {   this.email = email;   }    public string getmobile() {   return mobile;   }    public void setmobile(string mobile) {   this.mobile = mobile;   }    public string getpassword() {   return password;    }    public void setpassword(string password) {   this.password = password;  }    public string getrole() {   return role;   }     public void setrole(string role) {   this.role = role;    }     public string getstatus() {   return status;  }    public void setstatus(string status) {       this.status = status;   }   public string getlast_update() {   return last_update;   }      public void setlast_udpate(string last_update) { // todo auto-generated method stub     }          @override    public string tostring() {    return "user [id=" + id + "name=" + name + ", email=" + email + ", mobile=" + mobile           + ", password=" + password + ", role=" + role + ", status="           + status + ", last_update=" + last_update + "]";     }        } 

preparedstatement.setstring() not variable arity method; doesn't take variable no. of arguments. each placeholder(?) must set individualy using

stmt.setstring(1, "charlie sheen"); stmt.setstring(2, "help@glomindz.com"); 

and on.

using spring's jdbctemplate

jdbctemplate.update("insert spl_user_master(name,email,mobile,password,role,status,last_update)values(?,?,?,?,?,?,?)", new object[] {          "charlie sheen","help@glomindz.com","9654087107","cbf51a71a11d7ec348b0d7e9b2f0055f","admin","3","null"});