数据库索引超出范围
大家好,下面是我的一些程序,值都有取到,sql执行没问题,可是报错
org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select * from dbo.NOTICE_TABLE where [NOTICE_NAME] like '%标题001%'and [NOTICE_details] like '%%' and [NOTICE_STATE] like '%%']; SQL state [S1093]; error code [0]; 索引 1 超出范围。; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: 索引 1 超出范围。
com.microsoft.sqlserver.jdbc.SQLServerException: 索引 1 超出范围。
请问是什么问题,下面是具体程序,谢谢协助
public int queryNotice(String name,String details,String state) throws SQLException {
int num = 0 ;
String sql = "select * from dbo.NOTICE_TABLE where [NOTICE_NAME] like '%"+name+"%'and [NOTICE_details] like '%"+details+"%' and [NOTICE_STATE] like '%"+state+"%'";
// String sql = "select * from dbo.NOTICE_TABLE where [NOTICE_NAME] like '%标题001%'and [NOTICE_details] like '%%' and [NOTICE_STATE] like '%%'";
JdbcTemplate jt = new JdbcTemplate(this.getDataSource());
num = jt.queryForInt(sql,new String []{name,details,state});
return num;
}