getmaxid.java

来自「对数据库中的信息进行撮合匹配」· Java 代码 · 共 35 行

package com.cuohe.dblic;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;


public class GetmaxId {
	public int getId(String tablename,Connection conn)
	{
		String sql = "select max(id) from Mth_MatchInfo";
		int ID = 0;
		try
		{
			Statement stmt = conn.createStatement();
			ResultSet res = stmt.executeQuery(sql);
			if(res.next())
			{
				ID = res.getInt(1) + 1;
			}
			else
			{
				ID = 1;
			}
			return ID;
		}
		catch(Exception ex)
		{
			System.out.println("getid error msg :" + ex);
		}
		
		return 0;
	}
}