java链接mysql

Question

 if(choice  == 1){
    System.out.println("请输入要删除的学号");
     int  no = scanner.nextInt();
     sql = " delete from students where sno = " +no+ ' ';
            }

   sql = " delete from students where sno = "+no+ ' ';
  //这句sql语句写成下面这样 删除就失效了?
   sql = " delete from students where sno =  '"+no+ "'";

原因是啥呀?

Answer 1

如果 no = 1;
sql = " delete from students where sno = "+no+ ' '; ==> delete from students where sno = 1
sql = " delete from students where sno = '"+no+ "'"; ==> delete from students where sno = '1'
因为sno需要的是数字 1，而下边的语句变成了字符串 '1' 所以会执行失败了