package com.wpxcar.model;
import java.util.Arrays;
public class User {
private int id;
private String userName;
private String password;
private String[] favorate;
public User() {
// TODO Auto-generated constructor stub
}
public User(int id, String userName, String password,String[] favorate) {
super();
this.id = id;
this.userName = userName;
this.password = password;
this.favorate = favorate;
}
@Override
public String toString() {
return "User [id=" + id + ", userName=" + userName + ", password="
+ password + ", favorate="
+ Arrays.toString(favorate) + "]";
}
public User(String userName, String password) {
super();
this.userName = userName;
this.password = password;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String[] getFavorate() {
return favorate;
}
public void setFavorate(String[] favorate) {
this.favorate = favorate;
}
}
package com.wpxcar.dao;
import java.util.List;
import com.wpxcar.model.User;
public interface UserDao {
public boolean add(User user);
}
package com.wpxcar.dao.impl;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.wpxcar.dao.UserDao;
import com.wpxcar.model.User;
public class UserDaoImpl extends SuperOpr implements UserDao {
public boolean add(User user) {
sql = "insert into user_info (userName,password,favorate) values(?,?,?)";
try {
psmt = con.prepareStatement(sql);
psmt.setString(1, user.getUserName());
psmt.setString(2, user.getPassword());
psmt.setString(9, user.getFavorate());
row = psmt.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return row>0?true:false;
}
写到这里然后就在psmt.setString(9, user.getFavorate());这里报错,报的是:The method setString(int, String) in the type PreparedStatement is not applicable for the arguments (int, String[]),求教各位大神我应该怎么改
我的目的就是往数据库中插入一条记录
里面有id ,用户名,密码,喜好
因为喜好有多个 所以就用了数组类型的