JDBC入门开发过程

【1】写配置文件 db.properties

               driver = com.mysql.jdbc.Driver
url = jdbc:mysql://127.0.1:3306/mydb2
user= root
password =root

【2】JDBC工具类，读取配置文件，取得连接，关闭流

     

package cn.itcast.web.jdbc;

import java.io.InputStream;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;
//JDBC工具类，关闭流和取得连接
public final class JdbcUtil {

	private static String driver;
	private static String url;
	private static String user;
	private static String password;
	// 加载文件
	static {
		InputStream is = Demo3.class.getClassLoader().getResourceAsStream(
				"cn/itcast/web/jdbc/db.properties");
		Properties props = new Properties();
		try {
			props.load(is);

		} catch (Exception e) {
			e.printStackTrace();
		}
		driver = props.getProperty("driver");
		url = props.getProperty("url");
		user = props.getProperty("user");
		password = props.getProperty("password");

	}
	// 注册驱动
	static {

		try {
			Class.forName(driver);

		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	public static Connection getMySqlConnection() throws SQLException {
		Connection conn = null;
		try {
			conn = (Connection) DriverManager
					.getConnection(url, user, password);

		} catch (Exception e) {
			e.printStackTrace();
		}

		return conn;

	}

	// 關閉連接
	public static void close(Statement stmt) {
		if (stmt != null) {
			try {
				stmt.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}

	}

	public static void close(Connection conn) {
		if (conn != null) {
			try {
				conn.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}

	}

	public static void close(ResultSet rs) {
		if (rs != null) {
			try {
				rs.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}

	}

}

【3】使用jdbc工具类

package cn.itcast.web.jdbc;

import java.io.InputStream;

import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

import com.mysql.jdbc.Connection;
import com.mysql.jdbc.Statement;

public class Demo3 {

	public static void main(String[] args) {
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		String sql = "select * from user";
		try {
			conn = JdbcUtil.getMySqlConnection();
			stmt = (Statement) conn.createStatement();
			rs = stmt.executeQuery(sql);
			while (rs.next()) {

				String name = rs.getString("name");
				System.out.println(name);

			}
		} catch (Exception e) {

			e.printStackTrace();
		} finally {
			JdbcUtil.close(rs);
			JdbcUtil.close(stmt);
			JdbcUtil.close(conn);

		}
	}

}