Question

JSP后台servlet 和 dao中提示 索引 1 超出范围

我在数据库里面设计了4个数据news_title varchar(50),news_author varchar(20),news_summary varchar(50),news_content text.然后我在调用DBC连接数据库，
public boolean savaInfo(String news_title,String news_author,String news_summary,String news_content){
boolean bl=false;
conn = DBConnection.getConnection();
try {
String sql = "insert into news_info(news_title,news_author,news_summary,news_content)values('?','?','?','?')";
//执行sql语句
pstmt=conn.prepareStatement(sql);
//为参数赋值
pstmt.setString(1, news_title);
pstmt.setString(2, news_author);
pstmt.setString(3, news_summary);
pstmt.setString(4, news_content);
//发送命令给数据库开始执行
pstmt.executeUpdate();
//如果数据库执行将bl改为真
bl=true;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
//关闭连接
DBConnection.close(null, null, pstmt, null);
}
}
然后从页面接收数据，调用这个savaInfo（）方法传入页面接收的4个参数
一直报错 索引 1 超出范围

Answer 1

String sql = "insert into news_info(news_title,news_author,news_summary,news_content)values('?','?','?','?')";

将'?'的全部改为？，不需要加单双引号