链接数据库

本次我们项目连接数据库暂时用jdbc

package net.m;

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

public class DBUtil {
	private static final String DRIVER_CLASS = ProUtil.getDriver();
	private static final String USERNAME = ProUtil.getUser();
	private static final String PASSWORD = ProUtil.getPwd();
	private static final String URL = ProUtil.getUrl();

	static {
		try {
			Class.forName(DRIVER_CLASS);
			System.out.println("ok");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	//建立连接
	public static Connection getConnection() throws SQLException{
		return DriverManager.getConnection(URL, USERNAME, PASSWORD);
	}
	
	/*java.sql
  * 1，DriverManager 负责 驱动的管理者   类
  * 2，Connection 连接数据库      接口
  * 3, Statement 执行SQL语句    接口
  * 4, ResultSet 存放结果         接口
  */
  
	public static void closeALL(ResultSet rst, Statement stmt, Connection conn) {
		//关闭
		if(rst != null) {
			try {
				rst.close();
			} catch (SQLException e) {
				e.printStackTrace();
			} finally {
				rst = null;
			}
		if(stmt != null) {
			try {
				stmt.close();
			} catch (SQLException e) {
				e.printStackTrace();
			} finally {
				stmt = null;
			}
		}
		if(conn != null) {
			try {
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			} finally {
				conn = null;
			}
		}	
	}	
}

再创建一个类

package net.m;
	
import java.util.ResourceBundle;
//创建ProUtil目的是解析我们自己定义的属性文件
public class ProUtil {
	public static final ResourceBundle rb = ResourceBundle.getBundle("db");
	public static String getUser() {
		//user是属性文件中的Key
		return rb.getString("username");
	}
	public static String getPwd() {
		//通过解析属性文件，获取属性文件中的值
		return rb.getString("pwd");	
	}
	public static String getDriver() {
		return rb.getString("driver");
	}
	public static String getUrl() {
		//属性文件中的数据是以 键=值（键值对）的形式存放数据的
		return rb.getString("url");
	}
}