pkgeneratorfactory.java

来自「This project mainly deals with automatin」· Java 代码 · 共 73 行

//PKGeneratorFactory.java

package factory;
import java.sql.*;
import factory.*;

public final class PKGeneratorFactory
{

private static PKGeneratorFactory factory;
int intPK;
String stringPK;

private PKGeneratorFactory(){}

public static PKGeneratorFactory getFactory()
{
if (factory==null)
factory=new PKGeneratorFactory();
return factory;
}

public int getIntPrimaryKey(String tableName,String colName)
{
try{
	Connection con=DBConnectionFactory.getFactory().getConnection("rajeshPool");
	Statement stmt=con.createStatement();
	ResultSet rs=stmt.executeQuery("select max("+colName+") from "+tableName);
if(rs.next())
{
	intPK=rs.getInt(1);
}
else
{
intPK=0;
}
intPK++;

rs.close();
stmt.close();
con.close();
}catch(Exception e){e.printStackTrace();}
return intPK;
}


public String  getStringPrimaryKey(String tableName,String colName)
{
try{
	Connection con=DBConnectionFactory.getFactory().getConnection("rajeshPool");
	Statement stmt=con.createStatement();
	ResultSet rs=stmt.executeQuery("select max( to_number("+colName+"))from "+tableName);
if(rs.next())
{
	String s;
	s=rs.getString(1);
	if(s==null)
		stringPK="1";
	else
		stringPK=s;   
}


intPK=Integer.parseInt(stringPK);
intPK++;
stringPK=new Integer(intPK).toString();
rs.close();
stmt.close();
con.close();
}catch(Exception e){e.printStackTrace();}
return stringPK;
}
}