博客

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();  表名后面加一个空格后面在跟属性，就不会出现异常。