模糊查询,查中文和英文报错,但是可以查数字服务类public ArrayList queryXm(String Fname){\x05\x05 \x05\x05\x05\x05 \x05\x05Fname = "%"+Fname+"%";\x05\x05 \x05\x05ArrayList al = null\x05\x05 \x05\x05try {\x05\x05 \x05 String sql = "s
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/30 23:09:06
![模糊查询,查中文和英文报错,但是可以查数字服务类public ArrayList queryXm(String Fname){\x05\x05 \x05\x05\x05\x05 \x05\x05Fname =](/uploads/image/z/12501689-41-9.jpg?t=%E6%A8%A1%E7%B3%8A%E6%9F%A5%E8%AF%A2%2C%E6%9F%A5%E4%B8%AD%E6%96%87%E5%92%8C%E8%8B%B1%E6%96%87%E6%8A%A5%E9%94%99%2C%E4%BD%86%E6%98%AF%E5%8F%AF%E4%BB%A5%E6%9F%A5%E6%95%B0%E5%AD%97%E6%9C%8D%E5%8A%A1%E7%B1%BBpublic+ArrayList+queryXm%28String+Fname%29%7B%5Cx05%5Cx05+%5Cx05%5Cx05%5Cx05%5Cx05+%5Cx05%5Cx05Fname+%3D+%22%25%22%2BFname%2B%22%25%22%3B%5Cx05%5Cx05+%5Cx05%5Cx05ArrayList+al+%3D+null%5Cx05%5Cx05+%5Cx05%5Cx05try+%7B%5Cx05%5Cx05+%5Cx05+String+sql+%3D+%22s)
模糊查询,查中文和英文报错,但是可以查数字服务类public ArrayList queryXm(String Fname){\x05\x05 \x05\x05\x05\x05 \x05\x05Fname = "%"+Fname+"%";\x05\x05 \x05\x05ArrayList al = null\x05\x05 \x05\x05try {\x05\x05 \x05 String sql = "s
模糊查询,查中文和英文报错,但是可以查数字
服务类
public ArrayList queryXm(String Fname){
\x05\x05 \x05\x05
\x05\x05 \x05\x05Fname = "%"+Fname+"%";
\x05\x05 \x05\x05ArrayList al = null
\x05\x05 \x05\x05try {
\x05\x05 \x05 String sql = "select * from oldcustomer where Fname like "
\x05\x05 \x05 al = (ArrayList)jt.query(sql,new OldRowMapper(),Fname);
\x05\x05 \x05 } catch (DataAccessException e) {
\x05\x05 \x05 e.printStackTrace(); //To change body of catch statement use File | Settings | File Templates.
\x05\x05 \x05 }
\x05\x05 \x05\x05return al;
\x05\x05 \x05}
报错
type Exception report
message java.lang.NullPointerException
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException:java.lang.NullPointerException\x05org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:502)\x05org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:430)\x05org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)\x05org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)\x05javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
root cause
模糊查询,查中文和英文报错,但是可以查数字服务类public ArrayList queryXm(String Fname){\x05\x05 \x05\x05\x05\x05 \x05\x05Fname = "%"+Fname+"%";\x05\x05 \x05\x05ArrayList al = null\x05\x05 \x05\x05try {\x05\x05 \x05 String sql = "s
模糊查询需要单引号.Fname = "'%"+Fname+"%'";