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

 

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 ,用户名,密码,喜好

因为喜好有多个 所以就用了数组类型的

 

 

 

 

 

  • 0
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值