String[] handlepinyin=pinyin.split("[ ]");
int i=handlepinyin[0].length();
System.out.println(i);
// '"+i+"'
sql="select sentenc from versecontent where substring(pinyin,1,convert(int,'"+i+"')='"+handlepinyin[0]+"'";
这是抛出的异常 ,调试每次运行到 Statement s=conn.createStatement();这句就出异常,各位帮看看怎么回事Exception in thread "main" java.lang.NullPointerException
at iwit.sp.versecontent.VerseCodeTest.getHomophonySentence(VerseCodeTest.java:601)
at iwit.sp.versecontent.VerseCodeTest.getsentence(VerseCodeTest.java:621)
at iwit.sp.versecontent.VerseCodeTest.main(VerseCodeTest.java:631)
我怀疑是SQL语句出错,因编译扣变量 i 还是有单引号,我不是已强制转换了吗,搞不懂,望指教,谢谢
这是编译打出来的 select sentenc from versecontent where substring(pinyin,1,convert(int,'4')='long'