80,349
社区成员
发帖
与我相关
我的任务
分享
//创建数据库连接,存入用户名和密码
JDBConnection sqlConn = new JDBConnection();
sqlConn.executeUpdagte("insert into 'user_test'('name','password') values(" + username + “,” + password + ")");
sqlConn.executeUpdagte("insert into user_test(`name`,`password`) values('" + username + "','" + password + "')");
[/quote]
试了还是不行,you have an error in your SQL syntax; check the manual that correspond to your MySQL server version for the right syntax to use near ' 'user_test'('name','password') value('test','123')' at line 1[/quote]
怎么错误信息和我的这句不一致?我的user_test没加引号,其次`name`,`password`的那个两个不是引号,还有我的是values而你给的错误信息是value。你是在试我的这句么。。。
[/quote]终于解决了,我还是标点写错了,我把你那句复制进去就成功了,username那个是什么符号?好像不是单引号。我的是苹果电脑,怎么才能打出来?谢谢前辈了sqlConn.executeUpdagte("insert into user_test(`name`,`password`) values('" + username + "','" + password + "')");
[/quote]
试了还是不行,you have an error in your SQL syntax; check the manual that correspond to your MySQL server version for the right syntax to use near ' 'user_test'('name','password') value('test','123')' at line 1[/quote]
怎么错误信息和我的这句不一致?我的user_test没加引号,其次`name`,`password`的那个两个不是引号,还有我的是values而你给的错误信息是value。你是在试我的这句么。。。
sqlConn.executeUpdagte("insert into user_test(`name`,`password`) values('" + username + "','" + password + "')");
[/quote]
试了还是不行,you have an error in your SQL syntax; check the manual that correspond to your MySQL server version for the right syntax to use near ' 'user_test'('name','password') value('test','123')' at line 1sqlConn.executeUpdagte("insert into user_test(`name`,`password`) values('" + username + "','" + password + "')");