向mysql中插入数据出错，提示You have an error in your SQL syntax......

[tx183584]

		sql="create table"+" "+"E"+number + "(BookName varchar(50),Price varchar(10),time varchar(15))";
			statement.executeUpdate(sql);
			String time=getTime();  //getTime是自定义的方法
			//例如 insert into E4355 values("一","13.5",'2010-09-17');
		    sql="insert into"+" "+"E"+number +" "+"values"+"("+BookName+" "+Price+" "+time+")";
		    statement.execute(sql);

[龙四]

SQL错了呗
System.out.println(sql);一下

[tx183584]

[Quote=引用 1 楼 ticmy 的回复:]

SQL错了呗
System.out.println(sql);一下
[/Quote]
那括号里，需要双引号吗？好像不需要吧
完整的错误信息：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 'null 2010-9-17)' at line 1

[liuzhengkang]

[Quote=引用 2 楼 tx183584 的回复:]
引用 1 楼 ticmy 的回复:

SQL错了呗
System.out.println(sql);一下

那括号里，需要双引号吗？好像不需要吧
完整的错误信息：You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the righ……
[/Quote]
括号里，需要单引号..

[wzju64676266]

sql="insert into "+"E"+number+" values"+"('"+BookName+"','"+Price+"','"+time+"')";