Package tilda.db

Class UpdateQuery


  • public class UpdateQuery
    extends QueryHelper
    LDH-NOTE This class helps build queries more safely, but it's not a compile-time tool. Therefore, there is no point in trying to catch syntax errors as the database will do that plenty fine.
    It's tempting to add extra features to catch mismatched parentheses, checking there is no duplicate table names in the From clause. The only thing that was interesting is that using operators in the SET part of a select or update causes weird things. For example, select a=3 evaluates as a boolean expression which i find weird, so i check for it. Other than that, nothing except major issues like
    Author:
    ldh
    • Constructor Detail

      • UpdateQuery

        public UpdateQuery​(Connection C,
                           java.lang.String SchemaName,
                           java.lang.String TableName)
                    throws java.lang.Exception
        Throws:
        java.lang.Exception
    • Method Detail

      • execute

        public int execute()
                    throws java.lang.Exception
        Throws:
        java.lang.Exception