Coder Forum

Java Quellcode

//test-function:
public static void main(String[] args) {
   HSQLDatabase.getInstance("db").execute("INSERT INTO menschen2 (name,alter) VALUES('Karl', 13)");
   ResultSet result = HSQLDatabase.getInstance("db").query("CALL IDENTITY();");
   System.out.println(result.getRow());
 }
 
//query-function:
public ResultSet query(String expression) {
   try {
      Statement st = getConnection().createStatement();
      ResultSet rs = st.executeQuery(expression);
 
      return rs;
   } catch (SQLException ex) {
      System.err.println("Error: "+expression);
      new ErrorMessage(ex);
   }
 
   return null;
    }
 
//execute-function:
public void execute(String query) {
   try {
      Statement st = getConnection().createStatement();
      st.executeUpdate(query);
    } catch (SQLException ex) {
      System.err.println("Error: "+query);
      new ErrorMessage(ex);
   }
}

Java Quellcode

HSQLDatabase.getInstance("db").execute("INSERT INTO menschen2 (id,name,alter) VALUES(NULL,'Karl', 13)");
		ResultSet result = HSQLDatabase.getInstance("db").query("CALL IDENTITY()");
		result.next();
		System.out.println(result.getInt(1));