sequenceaction.java

一套完整的工商12315的源程序jsp部分在12315里,后台JAVA部分在gs12315src里,没有打包数据库.

package com.gs.db.dbimp;

import java.io.PrintStream;
import java.sql.*;
import java.util.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


public class SequenceAction {
  private static final String NEXT_ID_0 =
      "DECLARE @result int "
      +"EXECUTE @result = nextval ?, 1 "
      +"SELECT @result AS ID "
      +"";
  public SequenceAction() {
  }
  public static String getId(String key) {
    String res = null;
    Connection con = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    try {
      con = DbConnectionManager.getConnection();
      pstmt = con.prepareStatement(NEXT_ID_0);
      pstmt.setString(1,key);
      rs = pstmt.executeQuery();
      if (rs.next())
        res = rs.getString(1);
    }
    catch (Exception e) {}
    finally {
      try {
        rs.close();
        pstmt.close();
        con.close();
      }
      catch (Exception e) {
        System.out.println(e.toString());
      }
    }
    return res;
  }

}