DB2sql语句

错误：

在使用它的上下文中无效。. SQLCODE=-206, SQLSTATE=42703

1.插入语句时如果有字段为自增时，插入值要加上DEFAULT

String name = user_textBox.Text;
String password = password_textBox.Text;
String commandText = "INSERT INTO TABLE_USER ( ID,USER_NAME,USER_PASSWORD) VALUES (DEFAULT" + "," + name + "," + password + " )";

2.查询语句如果字段属性为VARCHAR类型，查询条件需要加‘’（单引号）

String name = user_textBox.Text;
String password = password_textBox.Text;
String commandText = "SELECT * FROM TABLE_USER WHERE USER_NAME ='"+name+"' AND USER_PASSWORD= '"+password+"'";