guidkeygen.java

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

package com.chis.util;

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

/**
 * 
 * @name GUIDKeyGen
 * @notes 生成GUID
 * @create Apr 4, 2008
 * @author Ralph.c
 *
 */
public class GUIDKeyGen {

	private GUIDKeyGen() {
		
	}
	
	public static String getGUIDKey(Connection conn) {
		String guid = null;
		//Connection conn = af.getConnection();
		String sql = "select newid()";
		Statement stmt = null;
		ResultSet rs = null;
		try {
			stmt = conn.createStatement();
			rs = stmt.executeQuery(sql);
			while (rs.next()) {
				guid = rs.getString(1);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			if(rs!=null) {
				try {
					rs.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(stmt != null) {
				try {
					stmt.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		}
		return guid;
	}
}