dbconnection.java

来自「07年做得人力资源管理系统」· Java 代码 · 共 43 行

package com.buat.hr.share;

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

public class DBConnection {
	/*    
	 * 功能：连接数据库
	 * 
	 */
	
	private static String drivers="com.mysql.jdbc.Driver";         //保存驱动类
	private String url="jdbc:mysql://localhost:3306/hr";             
	
	private String username="root";                                //登陆用户名
	private String passwords="root";                               //登陆密码
	
	static{
		try {                                                      //加载驱动
			Class.forName(drivers);
		} catch (ClassNotFoundException e) {
		}
	}
	
	public Connection getConnection(){                             //获得连接
		Connection con=null;
		try {
			con=DriverManager.getConnection(url,username,passwords);
			System.out.println("连接成功!");
		} catch (SQLException e) {			
			e.printStackTrace();
			System.out.println("连接失败!");
		}		
		return con;
	}

	public static void main(String[] args) {
		new DBConnection().getConnection();
	}

}