PHP Classes

File: programtemplates/template_java_code_generator.html

Recommend this page to a friend!
  Classes of Valics Lehel   PHP or Java Class Code Generator   programtemplates/template_java_code_generator.html   Download  
File: programtemplates/template_java_code_generator.html
Role: Auxiliary data
Content type: text/plain
Description: template for generating for Java
Class: PHP or Java Class Code Generator
Generate PHP or Java database access classes
Author: By
Last change: filename changed
Date: 16 years ago
Size: 4,294 bytes
 

Contents

Class file image Download
/* CODE GENERATED BY: GRAFXSOFTWARE CODE GENERATOR http://www.grafxsoftware.com ====================================== CLASS MADE BY: {AUTHOR} DATE: {DATE} PROJECT: {PROJECT_NAME} ====================================== */ /* {NAME} {CLASSVAR}=new {NAME}(); <!-- BEGIN DYNAMIC BLOCK: getfunctionsvar --> {CLASSVAR}.get{FUNC_NAME}(); <!-- END DYNAMIC BLOCK: getfunctionsvar --> <!-- BEGIN DYNAMIC BLOCK: setfunctionsvar --> {CLASSVAR}.set{FUNC_NAME}(); <!-- END DYNAMIC BLOCK: setfunctionsvar --> {CLASSVAR}.save(); */ package {PACKAGE}; import Config; import java.sql.*; import ro.grafx.utils.StringUtil; public class {NAME} { <!-- BEGIN DYNAMIC BLOCK: row --> private {VARIABLES_TYPE} {VARIABLES}; <!-- END DYNAMIC BLOCK: row --> private Connection con; public {NAME}(int {IDCLASS}, Connection con) throws SQLException { this.{IDCLASS} = {IDCLASS}; this.con =con; if(this.{IDCLASS}!=0) { Statement statement = con.createStatement(); StringBuffer stringbuffer = new StringBuffer(); stringbuffer.append("SELECT {LIST} FROM {DBNAME} WHERE `{IDCLASS}`="); stringbuffer.append({IDCLASS}); ResultSet resultset = statement.executeQuery(stringbuffer.toString()); if(resultset.next()) { <!-- BEGIN DYNAMIC BLOCK: value --> this.{FIELD_NAME} = resultset.get{TYPE}("{FIELD_NAME}"); <!-- END DYNAMIC BLOCK: value --> } else { <!-- BEGIN DYNAMIC BLOCK: nullvalue --> this.{FIELD_NAME} = {FIELD_NAME_VALUE}; <!-- END DYNAMIC BLOCK: nullvalue --> } resultset.close(); statement.close(); } } //end constructor <!-- BEGIN DYNAMIC BLOCK: getfunctions --> public {FUNC_NAME_TYPE} get{FUNC_NAME}() { return this.{VAR_NAME}; }// end get{FUNC_NAME}() <!-- END DYNAMIC BLOCK: getfunctions --> <!-- BEGIN DYNAMIC BLOCK: setfunctions --> public void set{FUNC_NAME}({FUNC_NAME_TYPE} {VAR_NAME}) { this.{VAR_NAME}={VAR_NAME}; } // end set{FUNC_NAME}() <!-- END DYNAMIC BLOCK: setfunctions --> public void save() throws SQLException { Statement statement = con.createStatement(); StringBuffer stringbuffer = new StringBuffer(); StringUtil su=new StringUtil(); if(this.{IDCLASS} == 0) { stringbuffer.setLength(0); stringbuffer.append("INSERT INTO {DBNAME} ({LIST}) VALUES("); <!-- BEGIN DYNAMIC BLOCK: insert --> stringbuffer.append("{ENTER}"); stringbuffer.append({VAR_NAME}); stringbuffer.append("{EXIT}"); <!-- END DYNAMIC BLOCK: insert --> stringbuffer.append(")"); int test=statement.executeUpdate(stringbuffer.toString()); if(test>0) { stringbuffer.setLength(0); stringbuffer.append("SELECT max({IDCLASS}) as max FROM {DBNAME};"); ResultSet resultset = statement.executeQuery(stringbuffer.toString()); if(resultset.next()) this.{IDCLASS}=resultset.getInt("max"); else this.{IDCLASS}=0; resultset.close(); } else this.{IDCLASS}=0; statement.close(); return; } else { stringbuffer.setLength(0); stringbuffer.append("UPDATE {DBNAME} SET "); <!-- BEGIN DYNAMIC BLOCK: update --> stringbuffer.append("{ENTER}"); stringbuffer.append({VAR_NAME}); stringbuffer.append("{EXIT}"); <!-- END DYNAMIC BLOCK: update --> stringbuffer.append(" WHERE `{IDCLASS}`="); stringbuffer.append(this.{IDCLASS}); statement.executeUpdate(stringbuffer.toString()); return; } } //end save() public void delete() throws SQLException { Statement statement = con.createStatement(); StringBuffer stringbuffer = new StringBuffer(); stringbuffer.setLength(0); stringbuffer.append("DELETE FROM {DBNAME} WHERE `{IDCLASS}`="); stringbuffer.append(this.{IDCLASS}); statement.executeUpdate(stringbuffer.toString()); statement.close(); } // end delete() } //end {NAME}