db_config.java

This is module used JSP

/*
 * Created on Mar 10, 2009
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package config;

import java.sql.Connection;
import java.sql.DriverManager;

/**
 * @author VietHung Romano
 * 
 * TODO To change the template for this generated type comment go to Window -
 * Preferences - Java - Code Style - Code Templates
 */
public class db_config {
	private static Connection conn;

	private final static String url = "jdbc:odbc:hrm";

	public static Connection getConnection() {
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn = DriverManager.getConnection(url, "sa", "nguyen");
			if (conn != null) {
				System.out.println("Success");
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
		return conn;
	}

	public static db_config getInstance() {
		return new db_config();
	}
}