flownumber.java

来自「java swing源码 欢迎下载 有问题请联系 我一定负责到底」· Java 代码 · 共 47 行

/**
 * 数字表
 */
package com.NCL;

import java.sql.*;
import com.sinosoft.common.*;

public class FlowNumber{
	public Connection conn = null;
	public PreparedStatement pstmt = null;
	/**
	 * 根据types得出numbers:首先把numbers加1，然后取得numbers的值
	 * @param Type 类型
	 * @return int
	 */
	public int getNumber(String Type){
		int result = -1;
		if(Type==null || "".equals(Type))return result;
		try {
			conn = DataConPool.getConnection();
		} catch (Exception e) {
			System.out.println("FlowNumber:getNumber() error!" + e.toString());
			return result;
		}
		CallableStatement proc = null; 
		try {
			proc = conn.prepareCall("{?=call GET_flownumber_ID(?)}");
			proc.registerOutParameter(1, Types.INTEGER);
			proc.setString(2,Type);
			proc.execute();
			result = proc.getInt(1);
		}catch(Exception ex){
			System.out.println(ex.getMessage());
			return result;
		}finally { 
			try{
				if(proc!=null)proc.close(); 
				if(conn!=null)conn.close();
			} catch(SQLException e){
				System.out.println(e.getMessage());
				return result;
			} 
		}
		return result;
	}
}