String input = request.getParameter("input");
String sql = "select * from stu where stuname='"+input+"' or stuno='"+input+"'";
如果表的属性值是字符类型,写sql语句时一定要在加上单引号,被坑了好久!
String input = request.getParameter("input");
String sql = "select * from stu where stuname='"+input+"' or stuno='"+input+"'";
如果表的属性值是字符类型,写sql语句时一定要在加上单引号,被坑了好久!