62,635
社区成员




SQLLoader.execute("INSERT INTO user(counter,name,password,sex,age) VALUES("+Server.counter+","+user.getName()+","+user.getPassword()+ "," +user.getSex()+ ","+user.getAge()+");");
String sql="INSERT INTO studentuser(id,name,password,sex,mail,college)value" +
"(4110415,'张振',4110415,'男','zhang@gmail','计算机科学与技术学院')";
这种即时添加明确的信息,这个时候,字符串常数要用单引号(英文符合)括起来;
例2:
Scanner reader=new Scanner(System.in);
System.out.println("请输入学号:");
int id=reader.nextInt();
System.out.println("请输入姓名:");
String name,password,sex,mail,college;
name=reader.next();
System.out.println("请输入密码:");
password=reader.next();
System.out.println("请输入性别:");
sex=reader.next();
System.out.println("请输入邮件:");
mail=reader.next();
System.out.println("请输入学院:");
college=reader.next();
String sql2="INSERT INTO studentuser(id,name,password,sex,mail,college)" +
"values("+id+",'"+name+"','"+password+"','"+sex+"','"+mail+"','"+college+"')";
这种传进变量的,实际情况:‘ ”+name+" ',即一个单引号括住了双引号,(单引号和双引号之间没有空格,这里是为了看的清楚);