安卓avd注册用户时服务端数据库报错

最新推荐文章于 2022-08-08 18:24:12 发布

runzhi5172

最新推荐文章于 2022-08-08 18:24:12 发布

阅读量393

点赞数

本文链接：https://blog.csdn.net/runzhi5172/article/details/53938294

版权

安卓avd注册用户时服务端数据库报错（mysql数据库）

新手学习急求解决方案啊
服务端报错提示：
insert into users(school,email,userId,court,userName,professional,password)values(?,?,?,?,?,?,?)
[沈阳工学院, bb, 0, bb, bb, bb, bb]
java.sql.SQLException: Table 'sg.users' doesn't exist Query: insert into users(school,email,userId,court,userName,professional,password)values(?,?,?,?,?,?,?) Parameters: [沈阳工学院, bb, 0, bb, bb, bb, bb]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:363)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:490)
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:403)
at com.tomo.dao.impl.common.BaseDaoImpl.save(BaseDaoImpl.java:207)
at com.tomo.web.servlet.UserAdd.doPost(UserAdd.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.tomo.web.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:27)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
添加用户信息是代码为：
public Serializable save(T entity){
Long id = Long.valueOf(0);
Connection conn = null;
//insert into 表名(列名,列名...) values(?,?...);
StringBuilder sql = new StringBuilder("insert into ");
sql.append(getTableName());
sql.append("(");

StringBuilder values = new StringBuilder("(");
List<Object> valueList = new ArrayList<Object>();
Map<String,Object> fieldValueMap = getFieldValueMap(entity);

fieldValueMap.remove(getPKName());
int i = 0;
for(Entry<String, Object> entry : fieldValueMap.entrySet()){
if(i++ > 0){
sql.append(",");
values.append(",");
}
sql.append(entry.getKey());
values.append("?");
valueList.add(entry.getValue());
}
sql.append(")");
values.append(")");
sql.append("values").append(values);

System.out.println(sql.toString());//测试输出
System.out.println(valueList);//测试输出
try {
conn = DbHelper.getConn();

qr.update(conn, sql.toString(), valueList.toArray());

//获取最新插入的这条数据的ID
BigInteger bi = qr.query(conn, "select @@identity", new ScalarHandler<BigInteger>());

id = Long.valueOf(bi.longValue());
} catch (SQLException e) {
e.printStackTrace();
} finally{
DbHelper.close(conn);
}

return id;
}