JDBC基础

1、使用java操作数据库是需要驱动的，查看mysql版本，在网上下载该版本的connector-jar，然后右键点击你的工-->properties-->Java Build Path-->Add External JARs-->然后找到你电脑里的mysql驱动：mysql-connector-java-5.1.22-bin.jar

2、Class.forName

一经调用,就会把类载入虚拟机.
这时java会执行该类的静态初始化.

3、程序实例:

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






public class MySQLConnection {
	public static void main(String strs[]){
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs	= null;
		String	  url	= "jdbc:mysql://localhost:3306/test";
		String	  user	= "root";
		String password = "maoshaoshuai";
		String 	  sql	= null;		
		try {
			Class.forName("com.mysql.jdbc.Driver");	
			} catch (ClassNotFoundException e) {
					System.out.print("驱动加载错误");
					e.printStackTrace();
					}
		System.out.println("加载驱动成功！");
		
		try {
		conn = DriverManager.getConnection(url, user, password);
		} catch (Exception e) {
		System.out.println("连接失败！");
		e.printStackTrace();
		}
		System.out.println("连接成功！");
		
		
		try {
			stmt =  conn.createStatement();
			sql	 =	"select * from customer";
			rs	 =	stmt.executeQuery(sql);
			while (rs.next()) {
				String midString = rs.getString("mid");
				String nam 		 = rs.getString("nam");
				Date birth 	 = rs.getDate("birth");
				String sex		 = rs.getString("sex");
				System.out.print("编号：" + midString);
				System.out.print("  名字：" + nam);
				System.out.print("  生日："+ birth);
				System.out.println(" 性别" + sex);
				
			}
		} catch (SQLException e) {
			// TODO: handle exception
			System.out.println("数据操作错误！");
			e.printStackTrace();
		}
		
		  try {
			   if(rs != null) {
			    rs.close();
			    rs = null;
			   }
			   if(stmt != null) {
			    stmt.close();
			    stmt = null;
			   }
			   if(conn != null) {
			    conn.close();
			    conn = null;
			   }
			  } catch(Exception e) {
			   System.out.println("数据库关闭错误");
			   e.printStackTrace();
			  }
	}
}