gencode.java.svn-base

来自「用JSP JAVA 做的 系统 只是初来扎到还望西黄！别乱来哦！」· SVN-BASE 代码 · 共 36 行

package com.chis.util;

import java.sql.Connection;
import java.util.List;

import com.stframe.dao.DaoUtil;
import com.stframe.form.DataForm;
/**
 * 生成code方法
 * @author baobao
 *
 */
public class GenCode {
	
	public static Integer genDeptCode(Connection conn,String tablename,String key){
		DataForm df= new DataForm(tablename,key);			
		List tmplist = DaoUtil.select(conn,"select isnull(max(code),998)+1 as "+key+" from "+tablename,df);
		df=(DataForm)tmplist.get(0);	
		return Integer.valueOf(String.valueOf(df.get(key)));
	}
	
	public static Integer genEmployCode(Connection conn,String tablename,String key){
		DataForm df= new DataForm(tablename,key);			
		List tmplist = DaoUtil.select(conn,"select isnull(max(EMP_CODE),10000)+1 as "+key+" from "+tablename,df);
		df=(DataForm)tmplist.get(0);	
		return Integer.valueOf(String.valueOf(df.get(key)));
	}
	public static Integer genIndex(Connection conn,String tablename){
		String key = "INDX";
		DataForm df= new DataForm(tablename);			
		List tmplist = DaoUtil.select(conn,"select isnull(max(indx),0)+1 as "+key+" from "+tablename,df);
		df=(DataForm)tmplist.get(0);	
		return Integer.valueOf(String.valueOf(df.get(key)));		
	}
}