//情况名称;如果返回值为空,将返回至同一页面。
String a = "aaa";
String b = "bbb";
String c = "ccc";
String d = "ddd";
String queryinsert2 = "insert into mainboard values (" + "'" + a + "'," + "2000" + "," + "333" + "," + "444"
+ "," + "'" + b + "'," + "'" + c + "'," + "'" + d + "'" + ")";
Connection conn = null;
Statement st = null;
ResultSet r = null;
try
{
Class.forName(drivername);
conn = DriverManager.getConnection(url,user,password);
st = conn.createStatement();
r = st.executeQuery(queryinsert2);
}
catch(Exception e)
{
return "case10";
}
如上,运行后抛出异常错误,那个queryinsert2到底该怎么写才对,我要实现的MYSQL命令是这样的
mysql> insert into mainboard values ('aaa',2000,333,444,'bbb','ccc','ddd');
参数的话数字的就是INT的了其他都是字符串了。
String a = "aaa";
String b = "bbb";
String c = "ccc";
String d = "ddd";
String queryinsert2 = "insert into mainboard values (" + "'" + a + "'," + "2000" + "," + "333" + "," + "444"
+ "," + "'" + b + "'," + "'" + c + "'," + "'" + d + "'" + ")";
Connection conn = null;
Statement st = null;
ResultSet r = null;
try
{
Class.forName(drivername);
conn = DriverManager.getConnection(url,user,password);
st = conn.createStatement();
r = st.executeQuery(queryinsert2);
}
catch(Exception e)
{
return "case10";
}
如上,运行后抛出异常错误,那个queryinsert2到底该怎么写才对,我要实现的MYSQL命令是这样的
mysql> insert into mainboard values ('aaa',2000,333,444,'bbb','ccc','ddd');
参数的话数字的就是INT的了其他都是字符串了。
把sql打印出来直接放在控制台执行看报什么错。
+------------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------+--------------+------+-----+---------+-------+
| name | varchar(50) | YES | | NULL | |
| price | int(10) | YES | | NULL | |
| score | int(5) | YES | | NULL | |
| cost_performance | int(5) | YES | | NULL | |
| terrace | varchar(20) | YES | | NULL | |
| brand | varchar(20) | YES | | NULL | |
| introduction | varchar(100) | YES | | NULL | |
+------------------+--------------+------+-----+---------+-------+
数据类型如上
在MYSQL控制台里我知道怎么写的。就是要写在JAVA代码里那些双引号和加号搞的我好乱阿
这样居然也不行。
是不是r = st.executeQuery(queryinsert2); 这个语句有错阿?
select的时候是用的executeQuery是不是insert的时候不是用的这个?
我想啊,应该要这样改st.executeUpdate(queryinsert2);