getsqlbean.java

来自「this is jave package for system parament」· Java 代码 · 共 45 行

package com.talent.publics;

import java.io.*;
import java.sql.*;
import java.util.*;
import javax.sql.*;
import javax.naming.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.transaction.UserTransaction;

public class GetSqlBean {

  public GetSqlBean() {
  }
  public String getInsertSql(String sql,String tableName,String insertId,String insertIdValue){
    int i = 0;
    int j = 0;
    int n = 0;
    i = sql.indexOf("||tableName||");
    j = sql.indexOf("||insertId||");
    n = sql.indexOf("||insertIdValue||");
    sql = sql.substring(0,i) + tableName+sql.substring(i+13,j) + insertId+sql.substring(j+12,n) + insertIdValue+")";
    System.out.println("getInsertSql======"+sql);
    return sql;
  }
  public String getUpdateSql(String sql,String tableName,String whereId){
    int i = 0;
    int j = 0;
    i = sql.indexOf("||tableName||");
    j = sql.indexOf("||whereId||");
    sql = sql.substring(0,i) + tableName+sql.substring(i+13,j) + whereId + sql.substring(j+12,sql.length());
    System.out.println("getUpdateSql======"+sql);
    return sql;
  }
  public String getCheckUpdateSql(String sql,String tableName,String whereId){
    int i = 0;
    int j = 0;
    i = sql.indexOf("||tableName||");
    j = sql.indexOf("||whereId||");
    sql = sql.substring(0,i) + tableName+ " SET SUPREAD = '0',SUPWRITE = '0',SAMEREAD = '0',SAMEWRITE = '0',SUBREAD = '0',SUBWRITE = '0' WHERE " + whereId + sql.substring(j+12,sql.length());
    System.out.println("getUpdateSql======"+sql);
    return sql;
  }
}