我建的mysql 表 如下:
mysql> create table t2(
-> id2 int(10) not null primary key AUTO_INCREMENT,
-> id1 int(10) not null ,//同种结构t1表的主键,也是AUTO_INCREMENT。
-> t2c1 varchar(100),
-> t2c2 varchar(100),
-> t2c3 varchar(100),
-> t2c4 varchar(100),
-> t2c5 varchar(100),
-> t2c6 varchar(100),
-> t2c7 varchar(100),
-> t2c8 varchar(100),
-> t2c9 varchar(100),
-> t2c10 varchar(100),
-> t2c11 varchar(100),
-> t2c12 varchar(100),
-> t2c13 varchar(100),
-> t2c14 varchar(100),
-> t2c15 varchar(100),
-> t2c16 varchar(100),
-> t2c17 varchar(100),
-> t2c18 varchar(100),
-> t2c19 varchar(100),
-> t2c20 varchar(100),
-> FOREIGN KEY (id1) REFERENCES t1(id1)
-> )AUTO_INCREMENT = 1;然后在使用java 访问数据库并打算更新时出错了。代码如下:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Date;
import java.util.UUID;public class connectionMysql {
public static void main(String[] args){
Connection conn=null;
Statement stmt=null;
ResultSet res=null;
Date now_time = new Date();
UUID uuid1= UUID.randomUUID();
UUID uuid2= UUID.randomUUID();
UUID uuid3= UUID.randomUUID();
UUID uuid4= UUID.randomUUID();
UUID uuid5= UUID.randomUUID();
UUID uuid6= UUID.randomUUID();
UUID uuid7= UUID.randomUUID();
UUID uuid8= UUID.randomUUID();
UUID uuid9= UUID.randomUUID();
UUID uuid10= UUID.randomUUID();
UUID uuid11= UUID.randomUUID();
UUID uuid12= UUID.randomUUID();
UUID uuid13= UUID.randomUUID();
UUID uuid14= UUID.randomUUID();
UUID uuid15= UUID.randomUUID();
UUID uuid16= UUID.randomUUID();
UUID uuid17= UUID.randomUUID();
UUID uuid18= UUID.randomUUID();
UUID uuid19= UUID.randomUUID();
UUID uuid20= UUID.randomUUID();
// System.out.println(uuid1);
long start_time=now_time.getTime();
try{
//加载Connector/J驱动
Class.forName("com.mysql.jdbc.Driver").newInstance();
//建立到MySQL的连接
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/newtest",
"root", "");
//执行SQL语句
stmt = conn.createStatement();
stmt.executeUpdate("INSERT INTO t2 values(id2,id1,uuid1,uuid2,uuid3,uuid4,uuid5,uuid6,uuid7,uuid8,uuid9,uuid10,uuid11,uuid12,uuid13,uuid14,uuid15,uuid16,uuid17,uuid18,uuid19,uuid20)");
//处理结果集
/* while (res.next()){
String t1c1 = res.getString("t1c1");
System.out.println(t1c1);
}
res.close();*/
}
catch (Exception ex){
System.out.println("Error : " + ex.toString());
}
Date now_end = new Date();
long end_time=now_end.getTime();
long use_time=end_time-start_time;
// System.out.println("<<---本页生成耗时["+use_time+"]毫秒("+((double)use_time)/1000+"秒)--->>");
}
}出错如下:Error : com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'uuid1' in 'field list'
这是为什么呢?
mysql> create table t2(
-> id2 int(10) not null primary key AUTO_INCREMENT,
-> id1 int(10) not null ,//同种结构t1表的主键,也是AUTO_INCREMENT。
-> t2c1 varchar(100),
-> t2c2 varchar(100),
-> t2c3 varchar(100),
-> t2c4 varchar(100),
-> t2c5 varchar(100),
-> t2c6 varchar(100),
-> t2c7 varchar(100),
-> t2c8 varchar(100),
-> t2c9 varchar(100),
-> t2c10 varchar(100),
-> t2c11 varchar(100),
-> t2c12 varchar(100),
-> t2c13 varchar(100),
-> t2c14 varchar(100),
-> t2c15 varchar(100),
-> t2c16 varchar(100),
-> t2c17 varchar(100),
-> t2c18 varchar(100),
-> t2c19 varchar(100),
-> t2c20 varchar(100),
-> FOREIGN KEY (id1) REFERENCES t1(id1)
-> )AUTO_INCREMENT = 1;然后在使用java 访问数据库并打算更新时出错了。代码如下:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Date;
import java.util.UUID;public class connectionMysql {
public static void main(String[] args){
Connection conn=null;
Statement stmt=null;
ResultSet res=null;
Date now_time = new Date();
UUID uuid1= UUID.randomUUID();
UUID uuid2= UUID.randomUUID();
UUID uuid3= UUID.randomUUID();
UUID uuid4= UUID.randomUUID();
UUID uuid5= UUID.randomUUID();
UUID uuid6= UUID.randomUUID();
UUID uuid7= UUID.randomUUID();
UUID uuid8= UUID.randomUUID();
UUID uuid9= UUID.randomUUID();
UUID uuid10= UUID.randomUUID();
UUID uuid11= UUID.randomUUID();
UUID uuid12= UUID.randomUUID();
UUID uuid13= UUID.randomUUID();
UUID uuid14= UUID.randomUUID();
UUID uuid15= UUID.randomUUID();
UUID uuid16= UUID.randomUUID();
UUID uuid17= UUID.randomUUID();
UUID uuid18= UUID.randomUUID();
UUID uuid19= UUID.randomUUID();
UUID uuid20= UUID.randomUUID();
// System.out.println(uuid1);
long start_time=now_time.getTime();
try{
//加载Connector/J驱动
Class.forName("com.mysql.jdbc.Driver").newInstance();
//建立到MySQL的连接
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/newtest",
"root", "");
//执行SQL语句
stmt = conn.createStatement();
stmt.executeUpdate("INSERT INTO t2 values(id2,id1,uuid1,uuid2,uuid3,uuid4,uuid5,uuid6,uuid7,uuid8,uuid9,uuid10,uuid11,uuid12,uuid13,uuid14,uuid15,uuid16,uuid17,uuid18,uuid19,uuid20)");
//处理结果集
/* while (res.next()){
String t1c1 = res.getString("t1c1");
System.out.println(t1c1);
}
res.close();*/
}
catch (Exception ex){
System.out.println("Error : " + ex.toString());
}
Date now_end = new Date();
long end_time=now_end.getTime();
long use_time=end_time-start_time;
// System.out.println("<<---本页生成耗时["+use_time+"]毫秒("+((double)use_time)/1000+"秒)--->>");
}
}出错如下:Error : com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'uuid1' in 'field list'
这是为什么呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货