主题:请问 JAVA SQL 问题
SQLException: Unknown column 'mda' in 'field list'
SQLState: 42S22
VendorError: 1054
我在insert数据的时候出现这个错误如何解决谢谢
String SQLCommand = "Insert into user (login_name,User_name,password,User_type,create_time) values("+login_name+","+User_name+","+password+","+User_type+","+System.currentTimeMillis()+");";
stmt.executeUpdate(SQLCommand);
ros.addUser("mda","12345678","mark","Admin");
SQLState: 42S22
VendorError: 1054
我在insert数据的时候出现这个错误如何解决谢谢
String SQLCommand = "Insert into user (login_name,User_name,password,User_type,create_time) values("+login_name+","+User_name+","+password+","+User_type+","+System.currentTimeMillis()+");";
stmt.executeUpdate(SQLCommand);
ros.addUser("mda","12345678","mark","Admin");