ORA-01756 sql语句连结问题求助 急

Question

我的sql部分
      mdataS = "where TORI_CODE between '" & Trim(Hincd1T.Text) & "' and '" & Trim(Hincd2T.Text) & "’ and Len(Trim(TORI_CODE)) between " & Len(Trim(Hincd1T.Text)) & " and " & Len(Trim(Hincd2T.Text))
    mysql = "select TORI_CODE,TORI_KANA,TORI_NAME,TORI_RYAKU,TORI_ZIP,TORI_ADDRESS1,TORI_ADDRESS2," _
         & "TORI_TEL,TORI_FAX,TORI_AITE_TANMEI,TORI_KIGO,TORI_AITE_BUSYO " _
         & "from M_TORI " _
         & mdataS _
         & " ORDER BY TORI_CODE"
  运行结果 ORA-01756 缺少单一引用符号

Answer 1

mdataS = "where TORI_CODE between '" & Trim(Hincd1T.Text) & "' and '" & Trim(Hincd2T.Text) & "’ and Len(Trim(TORI_CODE)) between " & Len(Trim(Hincd1T.Text)) & " and " & Len(Trim(Hincd2T.Text))//注意'" & Trim(Hincd2T.Text) & "后的那个单引号
mdataS = "where TORI_CODE between '" & Trim(Hincd1T.Text) & "' and '" & Trim(Hincd2T.Text) & "' and Len(Trim(TORI_CODE)) between " & Len(Trim(Hincd1T.Text)) & " and " & Len(Trim(Hincd2T.Text))

Answer 2

我的sql部分
      mdataS = "where TORI_CODE between '" & Trim(Hincd1T.Text) & "' and '" & Trim(Hincd2T.Text) & "’ and Len(Trim(TORI_CODE)) between " & Len(Trim(Hincd1T.Text)) & " and " & Len(Trim(Hincd2T.Text))
    mysql = "select TORI_CODE,TORI_KANA,TORI_NAME,TORI_RYAKU,TORI_ZIP,TORI_ADDRESS1,TORI_ADDRESS2," _
         & "TORI_TEL,TORI_FAX,TORI_AITE_TANMEI,TORI_KIGO,TORI_AITE_BUSYO " _
         & "from M_TORI " _
         & mdataS _
         & " ORDER BY TORI_CODE"
  运行结果 ORA-01756 缺少单一引用符号
-----------------------------------------------------------------------------------
一般不要这样写,在WHERE条件中这样写会影响性能,因为转换函数,不能利用索引.
(Hincd2T.Text) & "’ and Len(Trim(TORI_CODE)) between " & Len(Trim(Hincd1T.Text)) & " 很明显 "’标点打错了,粗心啊

Answer 3

 sql="INSERT INTO student(sid,name,sex,people,age,grade,theClass,spciality)VALUES('"+student.getSid()+"','"

     +student.getName()+"','"+student.getSex()+"','"+student.getPeople()+"','"+student.getAge()+"','"
 +student.getGrade()+"','"+student.getTheClass()+"','"+student.getSpeciality()+")";

Answer 4

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:242)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:554)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1478)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:888)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2076)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1986)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2697)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1035)
at JDBC.JDBCOracle.executUpdate(JDBCOracle.java:68)
at JDBC.JDBCOracle.InsertStudent(JDBCOracle.java:98)
at JDBC.InputStudentInformation.actionPerformed(InputStudentInformation.java:63)
at java.awt.Button.processActionEvent(Button.java:392)
at java.awt.Button.processEvent(Button.java:360)
at java.awt.Component.dispatchEventImpl(Component.java:4630)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
ORA-01756: 引号内的字符串没有正确结束