注意空格
con =DriverManager.getConnection("jdbc:odbc:A");
stmt = con.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
//就是这个query!!!!!
String query= "INSERT INTO B(Name,Password,Company) VALUES( '"+
Name.getText()+"','"+Psw.getPassword()+"','"+Company.getText()+")";
stmt.executeUpdate( query );
con =DriverManager.getConnection("jdbc:odbc:A");
stmt = con.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
//就是这个query!!!!!
String query= "INSERT INTO B(Name,Password,Company) VALUES( '"+
Name.getText()+"','"+Psw.getPassword()+"','"+Company.getText()+")";
stmt.executeUpdate( query );
是不是sql语句没有正确结束?
但是报错是说INSERT INTO语法错误
Name.getText()+"','"+Psw.getPassword()+"','"+Company.getText()+")";
最后一列列名少一个单引号
String query= "INSERT INTO B(Name,Password,Company)VALUES( '"+
Name.getText()+"','"+Psw.getPassword()+"','"+Company.getText()+"')";
会不会是Name.getText()等的错误