pkgeneratorbean.java

生成主键生成主键生成主键生成主键生成主键生成主键生成主键生成主键生成主键生成主键生成主键生成主键

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;
    }

}