问题原因:
原来新系统安装了影子系统,配置完JDK和Tomcat、数据库只要访问数据库就在浏览器端返回错误信息(js代码打印的信息)
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'supplier_database.supplier_user' doesn't exist ### The error may exist in file [E:\tomcat-8.0.47-supplier-80\webapps\supplier\WEB-INF\classes\mapper\UserMapper.xml] ### The error may involve cn.supplier.dao.UserDao.findUserByName-Inline ### The error occurred while setting parameters ### SQL: select User_Id as id, User_Name as name, User_Nick as nick, User_Password as password, User_corporate_name as corporate_name, User_corporate_address as corporate_address, User_email as email, User_tel as tel, User_Product_range as product_range, User_certificate as certificate, User_Permission as permission, User_CreatedTime as createdTime from Supplier_User where User_Name = ?; ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'supplier_database.supplier_user' doesn't exist ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'supplier_database.supplier_user' doesn't exist
解决:
后来重装了系统:用驱动精灵扫描并安装了系统重要驱动(没有安装影子系统),在安装数据库过程中有个微软驱动正在安装(具体哪个驱动忘记了),提示有程序正在安装等那个驱动安装完毕后,安装完数据库一切配置好后,正常了…
总结:1.有可能是因为我安装了影子系统影响了 2.微软关于数据库运行相关的驱动没有安装第二次重装系统正好装上了