异常 java.sql.SQLException：参数索引超出范围（1 > 参数数量，为 0）
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2975797/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-08-13 15:08:19 来源:igfitidea点击:
Exception java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)
提问by Rbn
I'm getting this error:
我收到此错误：
Exception java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3288)
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3272)
at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4108)
at com.inmobia.RSSToNews.Consumer.print(Consumer.java:92)
at com.inmobia.RSSToNews.Consumer.main(Consumer.java:122)
When I'm trying to execute this class:
当我尝试执行这个类时：
package com.in.RSSToNews;
import java.net.URL;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
import java.net.URLConnection;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import com.sun.syndication.feed.synd.SyndEntry;
import com.sun.syndication.feed.synd.SyndFeed;
import com.sun.syndication.io.SyndFeedInput;
import com.sun.syndication.io.XmlReader;
/**
* Consumer class from RSS/Atom feed type.
*
* @author Rbn
*/
public class Consumer {
SyndFeed feed;
/**
* Class constructor
*
* @param url: url path to consume
*/
public Consumer(String url) {
super();
try {
URL feedUrl = new URL(url);
SyndFeedInput input = new SyndFeedInput();
feed = input.build(new XmlReader(feedUrl));
} catch (Exception ex) {
ex.printStackTrace();
System.out.println("ERROR: "+ex.getMessage());
}
}
/**
* print method
* Scroll down the list of entries and displays the feed title, author and description
*/
void print () {
//feeds list
List<SyndEntry> entradas = new ArrayList<SyndEntry>();
entradas = feed.getEntries();
try
{
//list iterator
Iterator<SyndEntry> it = entradas.iterator();
Class.forName("org.gjt.mm.mysql.Driver");
Connection conexion = DriverManager.getConnection("jdbc:mysql://localhost/newsamerica", "root", "123");
if (!conexion.isClosed())
{
while (it.hasNext())
{
SyndEntry entrada = it.next();
String title=(entrada.getTitle() );
String link=(entrada.getLink());
String author=(entrada.getAuthor());
String description=(""+entrada.getDescription() );
Date date=(entrada.getPublishedDate());
String date2= date.toString();
String content=(""+entrada.getContents());
//description=description.replaceAll("SyndContentImpl.value=", "");
//System.out.println(text2);
//System.out.println("Autor.......: " + entrada.getAuthor() );
// System.out.println("Noticia.......: " + entrada.getContents());
// Statement st = conexion.createStatement();
PreparedStatement pstmt = conexion.prepareStatement("INSERT INTO general_news(title,link,author,description,date,content) VALUES ('?','?','?','?','?','?')");
pstmt.setString(1,title);
pstmt.setString(2,link);
pstmt.setString(3,author);
pstmt.setString(4,description);
pstmt.setString(5,date2);
pstmt.setString(6,content);
ResultSet rs = pstmt.executeQuery();
rs.next();
}
}
conexion.close();
}
catch (Exception e)
{
// Error en algun momento.
System.out.println("Excepcion "+e);
e.printStackTrace();
}
}
public static void main(String[] args) {
Consumer feed = new Consumer (args[0]);
feed.print();
}
}
}
回答by Jorge Ferreira
Horrible formatting. When using parameters you do not put '?'but simply ?.
可怕的格式。使用参数时，您不要输入，'?'而是简单地输入?.
Change the line:
更改行：
PreparedStatement pstmt = conexion.prepareStatement("INSERT INTO general_news(id,title,link,author,description,date,content) VALUES ('?','?','?','?','?','?')");
to
到
PreparedStatement pstmt = conexion.prepareStatement("INSERT INTO general_news(id,title,link,author,description,date,content) VALUES (?,?,?,?,?,?)");
This is why he thinks you have 0 parameters but were specifying the first.
这就是为什么他认为您有 0 个参数但指定了第一个参数。
Also note that you are executing an INSERTand as such MUST NOT use executeQuery. Use executeUpdate()instead.
另请注意，您正在执行一个INSERT，因此不得使用 executeQuery。请改用executeUpdate()。
