public int Community_insert(Object[] params) throws SQLException{
QueryRunner qr = new QueryRunner();String sql="insert into Community(Community_Title,Community_Content,Community_File,Community_Time) values(?,?,?,?)";
int ab=qr.update(getConnetion(),sql,params);
return ab;
}
//此段代码出现的问题是sql的语句。insert into Community(xx,xx,xx,xx) values();
抛出异常如下:java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: 关键字 'WHERE' 附近有语法错误。 Query: insert into Community(Community_Title,Community_Content,Community_File,Community_Time) values(?,?,?,?) ]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:320)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:489)
public int Community_insert(Object[] params) throws SQLException{
QueryRunner qr = new QueryRunner();
String sql="insert into Community (Community_Title,Community_Content,Community_File,Community_Time) values(?,?,?,?)";
int ab=qr.update(getConnetion(),sql,params);
return ab;
}
//代码更正:insert into Community (xx,xx,xx,xx) values(); 表名后面加一个空格后面在跟属性,就不会出现异常。