jacklightchen / managebooks Goto Github PK

{"status":false,"total":0,"data":null,"message":"\r\n### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'library.manager' doesn't exist\r\n### The error may exist in file [D:\Project\ManageBooks\target\classes\Mapper\user.xml]\r\n### The error may involve defaultParameterMap\r\n### The error occurred while setting parameters\r\n### SQL: select manager_id as user_id, pass_wd, mname as user_name from manager where mname=? and pass_wd=?;\r\n### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'library.manager' doesn't exist\n; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'library.manager' doesn't exist"}

能把数据库的代码也放出来吗？

message: "\r\n### Error updating database. Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist\r\n### The error may involve defaultParameterMap\r\n### The error occurred while setting parameters\r\n### SQL: call library.new_book(?, ?, ?, ?, ?, ?, ?, ?, ?)\r\n### Cause: java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist\n; uncategorized SQLException; SQL state [HY000]; error code [1449]; The user specified as a definer ('root'@'%') does not exist; nested exception is java.sql.SQLException: The user specified as a definer ('root'@'%') does not exist"

数据库脚本看不太懂，里面那么多set 命令什么的，有没有简洁版的啊

I strongly recommend you that the picture should be replaced with something more graceful!!!