Question

java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).怎么办

package com.test.action;
import java.sql.*;
import org.apache.struts2.ServletActionContext;
import java.sql.SQLException;
import java.sql.Statement;

import java.sql.Connection;
import com.opensymphony.xwork2.ActionSupport;
import java.sql.PreparedStatement;
public class RegistAction extends ActionSupport {

private static final long serialVersionUID = 1L;

private String id;
private String username;
private String password;

public String execute() throws Exception{
id=ServletActionContext.getRequest().getParameter("id");
username=ServletActionContext.getRequest().getParameter("username");
password= ServletActionContext.getRequest().getParameter("password");

Connection conn = null;
String URL = "jdbc:mysql://localhost:3306/test";
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(URL, "root", "123456");
String sql = "insert into user(id,username,password) values('"+id+"','"+username+"','"+password+",'0')";

PreparedStatement ps;

try { ps = conn.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS);
ps.setString(1, id);
ps.setString(2, username);
ps.setString(3, password);
ps.executeUpdate();
return "no";
} catch (SQLException e)
{ e.printStackTrace();
return "yes";
}
}
}

Answer 1

"insert into user(id,username,password) values('"+id+"','"+username+"','"+password+",'0')"; 这才3个，你values里有4个值

追问

 

去掉也是报一样的错啊

追答

字符串要加单引号，

追问

还是 有错

追答

你留个qq看看

追问

1585208787