SQL insert 语句

String query="create table student("+"name String,"+"sex String,"+"unit String,"+"city String,"+"job String,"+"phone String,"+"email String"+")";s.executeUpdate(query);
通过上两条语句创建的表


String r="insert into student values("+"s0,s1,s2,s3,s4,s5,s6"+")";s.executeUpdate(r);
通过这两条语句添加  其中s0~s6是String类型 是自动生成的

报错SQLException:[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是6.

---

string -> varchar(100)

---

创建表的时候没有string型的吧  用varchar

---

表 字段类型没有string 类型，只有 varchar or nvarchar

---

String r="insert into student values("+"s0"+","+s1+"," + s2..

看来楼主还不会写程序。

---

string

---

sql系统中自带的数据类型应该把string转换为varchar(50)或者nvarchar(50)等

---

String query="create table student("+"name String,"+"sex String,"+"


好像不能用String的吧！楼主！

---

引用

String query="create table student("+"name String,"+"sex String,"+"unit String,"+"city String,"+"job String,"+"phone String,"+"email String"+")";s.executeUpdate(query);
通过上两条语句创建的表

<