📄 jsourcecodewizardfunction.java
字号:
stmt.executeUpdate("DROP TABLE function");
}finally{
stmt.close();
}
}
/**
* function(function of wizard) 偺DB昞憓擖<BR>
*
* @param Connection 愙懕僐僱僋僔儑儞
* @return 僥乕僽儖憓擖偵惉岟偟偨審悢
* @throws SQLException
*/
public int sqlInsertInto(java.sql.Connection conn)
throws java.sql.SQLException
{
java.sql.PreparedStatement stmt=conn.prepareStatement("INSERT INTO function VALUES (?,?,?,?,?,?,?,?,?,?,?)");
try{
int iColumn=1;
stmt.setString(iColumn++,((""+(getUseDebug()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseSql()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseXml()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseCsv()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseTsv()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseTest()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseServlet()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseSwing()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseMain()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseInit()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseConstracter()?'t':'f'))));
return stmt.executeUpdate();
}finally{
stmt.close();
}
}
/**
* function(function of wizard) 偺DB昞慡専嶕<BR>
*
* @param Connection 愙懕僐僱僋僔儑儞
* @return 専嶕寢壥
* @throws SQLException
*/
public static java.sql.PreparedStatement sqlSelect(java.sql.Connection conn)
throws java.sql.SQLException
{
java.sql.PreparedStatement stmt=conn.prepareStatement("SELECT useDebug,useSql,useXml,useCsv,useTsv,useTest,useServlet,useSwing,useMain,useInit,useConstracter FROM function ORDER BY ");
return stmt;
}
/**
* function(function of wizard) 偺DB昞慡専嶕 List栠傝抣斉<BR>
*
* @param Connection 愙懕僐僱僋僔儑儞
* @return ArrayList 専嶕寢壥
* @throws SQLException
*/
public static ArrayList sqlSelectList(java.sql.Connection conn)
throws java.sql.SQLException
{
ArrayList vecResult=new ArrayList();
java.sql.PreparedStatement stmt=sqlSelect(conn);
try{
java.sql.ResultSet resultSet=stmt.executeQuery();
for(;resultSet.next();)
{
JSourceCodeWizardFunction datafunction=new JSourceCodeWizardFunction();
datafunction.parse(resultSet);
vecResult.add(datafunction);
}
return vecResult;
}finally{
stmt.close();
}
}
/**
* function(function of wizard) 偺DB昞専嶕 WHERE斉<BR>
*
* @param Connection 愙懕僐僱僋僔儑儞
* @param String 忦審. null側傜僷儔儊乕僞柍偟
* @param Object[] 僷儔儊乕僞. null側傜僷儔儊乕僞柍偟
* @param String 僜乕僩弴. null側傜僜乕僩柍偟
* @return 専嶕寢壥
* @throws SQLException
*/
public static java.sql.PreparedStatement sqlSelectWhereOrderBy(java.sql.Connection conn,String strWhere,Object[] params,String strOrderBy)
throws java.sql.SQLException
{
StringBuffer strbufSql=new StringBuffer();
strbufSql.append("SELECT useDebug,useSql,useXml,useCsv,useTsv,useTest,useServlet,useSwing,useMain,useInit,useConstracter FROM function");
if(strWhere!=null && strWhere.length()>0)strbufSql.append(" WHERE "+strWhere);
if(strOrderBy!=null && strOrderBy.length()>0)strbufSql.append(" ORDER BY "+strOrderBy);
java.sql.PreparedStatement stmt=conn.prepareStatement(strbufSql.toString());
try{
if(params!=null)for(int iColumn=0;iColumn<params.length;iColumn++)
{
if(params[iColumn] instanceof String)
{
stmt.setString(iColumn+1,(String)params[iColumn]);
}
else if(params[iColumn] instanceof Integer)
{
stmt.setInt(iColumn+1,((Integer)params[iColumn]).intValue());
}
else if(params[iColumn] instanceof java.math.BigDecimal)
{
stmt.setBigDecimal(iColumn+1,((java.math.BigDecimal)params[iColumn]));
}
}
}catch(java.sql.SQLException ex){
stmt.close();
throw ex;
}
return stmt;
}
/**
* function(function of wizard) 偺DB昞峴嶍彍<BR>
*
* @param Connection 愙懕僐僱僋僔儑儞
* @return int 嶍彍幚峴寢壥審悢
* @throws SQLException
*/
public int sqlDelete(java.sql.Connection conn)
throws java.sql.SQLException
{
java.sql.PreparedStatement stmt=conn.prepareStatement("DELETE FROM function WHERE ");
int iColumn=1;
try{
return stmt.executeUpdate();
}finally{
stmt.close();
}
}
/**
* function(function of wizard) 偺DB昞峴峏怴<BR>
*
* @param Connection 愙懕僐僱僋僔儑儞
* @return int 峏怴幚峴寢壥審悢
* @throws SQLException
*/
public int sqlUpdate(java.sql.Connection conn)
throws java.sql.SQLException
{
java.sql.PreparedStatement stmt=conn.prepareStatement("UPDATE function SET useDebug=?,useSql=?,useXml=?,useCsv=?,useTsv=?,useTest=?,useServlet=?,useSwing=?,useMain=?,useInit=?,useConstracter=? WHERE ");
try{
int iColumn=1;
stmt.setString(iColumn++,((""+(getUseDebug()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseSql()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseXml()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseCsv()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseTsv()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseTest()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseServlet()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseSwing()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseMain()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseInit()?'t':'f'))));
stmt.setString(iColumn++,((""+(getUseConstracter()?'t':'f'))));
return stmt.executeUpdate();
}finally{
stmt.close();
}
}
/**
* 梌偊傜傟偨暥帤楍傪壜擻側尷傝悢帤壔偟傑偡丅<BR>
* 偙偺儊僜僢僪偼敿妏悢帤偺傒桳岠偱偡丅
* 偨偩偟扨懱僥僗僩偟偰傒偨偲偙傠丄Integer.parseInt()偼慡妏暥帤傕
* 埖偊偰偟傑偊傞 (偮傑傝 偙偺傔偦偭偳偱傕棙梡壜擻側) 柾條偱偡丅(at JDK1.3.1)
*
* @param String strInput 擖椡暥帤楍
* @return int 拪弌偝傟偨悢帤
*/
public static final int toInteger(String strInput)
{
if(strInput==null
|| strInput.length()==0)
{
return 0;
}
try{
return Integer.parseInt(strInput);
}catch(java.lang.NumberFormatException ex){
return 0;
}
}
/**
* 梌偊傜傟偨暥帤楍傪巜掕挿偝偵傄偭偨傝偵廂傑傞傛偆壛岺偡傞儊僜僢僪<BR>
* 2僶僀僩1暥帤偺暥帤偼2暥帤偲偟偰僇僂儞僩偟傑偡丅<BR>
* 亂拲堄亃偙偺儊僜僢僪偵偮偄偰偼 JSourceCodeWizard僋儔僗偑嶌惉偡傞傂側宍僜乕僗僐乕僪
* 偺堦晹偲偟偰棙梡偝傟傑偡丅偛棟夝偲偛嫤椡偺傎偳 偳偆偧傛傠偟偔偍婅偄偄偨偟傑偡丅<BR>
* <BR>
* 側偍丄尰嵼偺幚憰偱偼 EUC偵偍偄偰敿妏僇僞僇僫偑2僶僀僩偵側傞審偵偮偄偰懳墳偟偰偄傑偣傫<BR>
*
* @param String strInput 擖椡暥帤楍
* @param int iLength 惗惉偟偨偄挿偝
* @param char cFill 杽傔傞暥帤
* @return String 晹暘暥帤楍
*/
public static final String fitRight(String strInput,int iLength,char cFill)
{
try{
StringReader reader=new StringReader(strInput);
StringWriter writer=new StringWriter();
for(int iCurrentLength=0;;)
{
int iRead=reader.read();
if(iRead<0)break;
if(iRead>0xff)
{
iCurrentLength+=2;
}
else
{
iCurrentLength+=1;
}
if(iCurrentLength<=iLength)
{
writer.write(iRead);
}
else
{
break;
}
}
reader.close();
writer.flush();
writer.close();
return padRight(writer.toString(),iLength,cFill);
}catch(IOException ex){
System.out.println(ex.toString());
ex.printStackTrace();
return null;
}
}
/**
* 梌偊傜傟偨暥帤楍傪巜掕挿偝傑偱塃懁偵巜掕暥帤傪杽傔傞儊僜僢僪<BR>
* 2僶僀僩1暥帤偺暥帤偼2暥帤偲偟偰僇僂儞僩偟傑偡丅<BR>
* 亂拲堄亃偙偺儊僜僢僪偵偮偄偰偼 JSourceCodeWizard僋儔僗偑嶌惉偡傞傂側宍僜乕僗僐乕僪
* 偺堦晹偲偟偰棙梡偝傟傑偡丅偛棟夝偲偛嫤椡偺傎偳 偳偆偧傛傠偟偔偍婅偄偄偨偟傑偡丅<BR>
*
* @param String strInput 擖椡暥帤楍
* @param int iLength 惗惉偟偨偄挿偝
* @param char cFill 杽傔傞暥帤丅
* @return String 晹暘暥帤楍
*/
public static final String padRight(String strInput,int iLength,char cFill)
{
try{
int iInputLength=strInput.getBytes().length;
StringWriter writer=new StringWriter();
writer.write(strInput);
for(int iCurrentLength=iInputLength;;)
{
if(cFill>0xff)
{
iCurrentLength+=2;
if(iCurrentLength>iLength)
{
if(iCurrentLength==(iLength+1))
{
writer.write(' ');
}
break;
}
}
else
{
iCurrentLength+=1;
}
if(iCurrentLength<=iLength)
{
writer.write(cFill);
}
else
{
break;
}
}
writer.flush();
writer.close();
return writer.toString();
}catch(IOException ex){
System.out.println(ex.toString());
ex.printStackTrace();
return null;
}
}
/**
* 梌偊傜傟偨暥帤楍偺塃懁傪愗傝偮傔傞儊僜僢僪
* 敿妏嬻敀偲慡妏嬻敀傪愗傝偮傔傑偡
* 亂拲堄亃偙偺儊僜僢僪偵偮偄偰偼 JSourceCodeWizard僋儔僗偑嶌惉偡傞傂側宍僜乕僗僐乕僪
* 偺堦晹偲偟偰棙梡偝傟傑偡丅偛棟夝偲偛嫤椡偺傎偳 偳偆偧傛傠偟偔偍婅偄偄偨偟傑偡丅<BR>
*
* @param String strInput 擖椡暥帤楍
* @return String 愗傝偮傔屻暥帤楍
*/
public static final String trimRight(String strInput)
{
try{
StringReader reader=new StringReader(strInput);
StringWriter writer=new StringWriter();
StringBuffer strbufWhiteSpace=new StringBuffer();
for(;;)
{
int iRead=reader.read();
if(iRead<0)break;
if(iRead==' '
|| iRead=='丂')
{
strbufWhiteSpace.append((char)iRead);
}
else
{
writer.write(strbufWhiteSpace.toString());
strbufWhiteSpace=new StringBuffer();
writer.write(iRead);
}
}
reader.close();
writer.flush();
writer.close();
return writer.toString();
}catch(IOException ex){
System.out.println(ex.toString());
ex.printStackTrace();
return null;
}
}
/**
* 梌偊傜傟偨暥帤楍偺堦晹暘傪庢摼偡傞儊僜僢僪
* 2僶僀僩1暥帤偺暥帤偼2暥帤偲偟偰僇僂儞僩偟傑偡丅
* Unicode揑側摦嶌偼峴偄傑偣傫丅
* 暥帤偑搑拞偱暘抐偝傟傞応崌偼 偦偺暥帤偼徣偒 敿妏嬻敀傪杽傔傑偡丅<BR>
* 亂拲堄亃偙偺儊僜僢僪偵偮偄偰偼 JSourceCodeWizard僋儔僗偑嶌惉偡傞傂側宍僜乕僗僐乕僪
* 偺堦晹偲偟偰棙梡偝傟傑偡丅偛棟夝偲偛嫤椡偺傎偳 偳偆偧傛傠偟偔偍婅偄偄偨偟傑偡丅<BR>
*
* @param String strInput 擖椡暥帤楍
* @param int iStart 奐巒埵抲 (0僆儕僕儞)
* @param int iLength 庢摼挿偝
* @return String 晹暘暥帤楍
*/
public static final String subString(String strInput,int iStart,int iLength)
{
if(strInput==null)return null;
if(iLength<=0)return "";
try{
StringReader reader=new StringReader(strInput);
StringWriter writer=new StringWriter();
int iTotalLength=0;
// 僗僞乕僩抧揰傑偱憗憲傝
for(int iCurrentLength=0;iCurrentLength<iStart;)
{
int iRead=reader.read();
if(iRead<0)
{
// 僗僞乕僩抧揰偵撏偔慜偵廔椆
return "";
}
if(iRead>0xff)
{
iCurrentLength+=2;
if(iCurrentLength>=iStart)
{
if(iCurrentLength>iStart)
{
writer.write(' ');
iTotalLength++;
}
break;
}
}
else
{
iCurrentLength+=1;
}
}
// 巜掕挿偝偩偗撉傒偲傝
for(;iTotalLength<iLength;)
{
int iRead=reader.read();
if(iRead<0)break;
if(iRead>0xff)
{
iTotalLength+=2;
if(iTotalLength>iLength)
{
writer.write(' ');
break;
}
}
else
{
iTotalLength+=1;
}
writer.write(iRead);
}
writer.flush();
writer.close();
return writer.toString();
}catch(IOException ex){
System.out.println(ex.toString());
ex.printStackTrace();
return null;
}
}
/**
* 梌偊傜傟偨Node傪僷乕僗偟偰僼傿乕儖僪偵戙擖偟傑偡
*
* @param Node nodeLook 擖椡僲乕僪
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -