java - 参数索引超出范围 (0 < 1 )

Question

我一直在努力解决这个问题

ps.setString(1,fname);
ps.setString(2,lname);
ps.setString(3,uname);
ps.setString(4,pass);
ps.setString(5,gender);
ps.setString(6, phone);
ps.setString(7,brdate);
ps.setString(8,address );

它会在底部发送另一条消息：

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''java_login_register'('fname', 'lname', 'uname', 'pass','gender','phono','bdate'' at line 1

连接到数据库或本地主机

con = DriverManager.getConnection("jdbc:mysql://localhost:3306/uinterface_?serverTimezone=UTC","root","");
            ps = con.prepareStatement("INSERT INTO 'login_register'('fname', 'lname', 'uname', 'pass','gender','phono','bdate','address') VALUES (?,?,?,?,?,?,?,?)");

标签： javamysqljdbclocalhost