Unknown column '?????????' in 'field list'列不存在啊?String sql = "insert into emp(empno,ename,job,hiredate,sal)" + "values("+empno+"," + ename+","+job+","+hiredate+","+sal+")";这里如果ename是字符串变量的话需要写成如下: String sql = "insert into emp(empno,"+"ename,job,hiredate,sal)" + "values("+empno+"," + ename+","+job+","+hiredate+","+sal+")"; 或者直接写成: String sql = "insert into emp(empno,`潘春春`,job,hiredate,sal)" + "values("+empno+"," + ename+","+job+","+hiredate+","+sal+")";
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''fenshu',job,hiredate,sal)values(6229,fenshu,manager,2010-05-04,8000)' at line 1 出现这种错误,不会改;
把你生成的insert的sql语句打印出来,我看看是什么样子的?
把你生成的insert的sql语句打印出来,我看看是什么样子的?insert into emp(empno,ename,job,hiredate,sal)values(6229,fenshu,manager,2010-05-04,8000)
//String sql = "insert into emp values("+"'"+"6229"+"'"+","+"'"+"fenshu"+"'"+","+"'"+"manager"+"'"+","+"'"+"2010-05-04"+"'"+","+"'"+"8000"+"'"+")"; //得到连接 System.out.println(sql);
求在java中向数据库中插入数据的语法
生成的sql语句不正确啊,你的字段名不是有一个叫 把你生成的insert的sql语句打印出来,我看看是什么样子的?insert into emp(empno,ename,job,hiredate,sal)values(6229,fenshu,manager,2010-05-04,8000) 不对啊,你的字段名不是有把你生成的insert的sql语句打印出来,我看看是什么样子的?insert into emp(empno,ename,job,hiredate,sal)values(6229,fenshu,manager,2010-05-04,8000) 唉,你这个sql错了,values里面的字段值除了数字外,字符串和日期都要用''括起来啊,应该打印出来的sql语句如下所示: INSERT INTO emp(empno,ename,job,hiredate,sal)VALUES(6229,'fenshu','manager','2010-05-04',8000);才是正确格式的。
+ ename+","+job+","+hiredate+","+sal+")";这里如果ename是字符串变量的话需要写成如下:
String sql = "insert into emp(empno,"+"ename,job,hiredate,sal)" + "values("+empno+","
+ ename+","+job+","+hiredate+","+sal+")";
或者直接写成:
String sql = "insert into emp(empno,`潘春春`,job,hiredate,sal)" + "values("+empno+","
+ ename+","+job+","+hiredate+","+sal+")";
出现这种错误,不会改;
String empno = "6239";
String ename = "'"+"fenshu"+"'";
String job = "'"+"manager"+"'";
String hiredate = "'"+"2010-05-04"+"'";
String sal = "8000";
String sql = "insert into emp values("+empno+"," +ename+","+job+","+hiredate+","+sal+")";
//String sql = "insert into emp values("+"'"+"6229"+"'"+","+"'"+"fenshu"+"'"+","+"'"+"manager"+"'"+","+"'"+"2010-05-04"+"'"+","+"'"+"8000"+"'"+")";
//得到连接
System.out.println(sql);
生成的sql语句不正确啊,你的字段名不是有一个叫 把你生成的insert的sql语句打印出来,我看看是什么样子的?insert into emp(empno,ename,job,hiredate,sal)values(6229,fenshu,manager,2010-05-04,8000)
不对啊,你的字段名不是有把你生成的insert的sql语句打印出来,我看看是什么样子的?insert into emp(empno,ename,job,hiredate,sal)values(6229,fenshu,manager,2010-05-04,8000)
唉,你这个sql错了,values里面的字段值除了数字外,字符串和日期都要用''括起来啊,应该打印出来的sql语句如下所示:
INSERT INTO emp(empno,ename,job,hiredate,sal)VALUES(6229,'fenshu','manager','2010-05-04',8000);才是正确格式的。