package com.qidi;

import java.sql.*;
public class PkGeneratorBean  {
    private String tableName;
    private String pk;
    public PkGeneratorBean() {
    }
    public String getPk() {
        Connection conn=DBconnection.getConnection();
       try {
           CallableStatement cs = conn.prepareCall("{call pk_generator(?,?)}");
           cs.registerOutParameter(2,java.sql.Types.VARCHAR);
           cs.setString(1, tableName);
           cs.execute();
           pk=cs.getString(2);
       } catch (SQLException ex) {
           ex.printStackTrace();
       }
        return pk;
    }

    public String getTableName() {
        return tableName;
    }

    public void setPk(String pk) {
       this.pk=pk;
    }

    public void setTableName(String tableName) {
        this.tableName = tableName;
    }

}