JAVA连接mysql数据库

package com.sp.test;
import java.sql.*;
public class TestMysql {
	
	//测试如何操作mysql数据库
	public static void main(String [] args){
		Connection ct = null;
		PreparedStatement ps  = null;
		ResultSet rs = null;
		try{
			//1.加载驱动
			Class.forName("com.mysql.jdbc.Driver");
			//2.得到连接
			//ct = DriverManager.getConnection("url");
			ct = DriverManager.getConnection("jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8","root","123456");
			//test为所要连接的数据库,useUnicode,characterEncoding为保证输出汉字
			//3.创建ps:预编译的sql对象
			ps = ct.prepareStatement("select * from student");
			//4.执行
			rs = ps.executeQuery();
			while(rs.next()){
				System.out.println("用户名："+rs.getString("usera")+" "+"密码："+rs.getString("pass"));
			}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			//关闭
			if(rs!=null){
				try{
					rs.close();
				}catch(SQLException e){
					e.printStackTrace();
				}
				rs=null;
			}
			if(ps!=null){
				try{
					ps.close();
				}catch(SQLException e){
					e.printStackTrace();
				}
				ps=null;
			}
			if(ct!=null){
				try{
					ct.close();
				}catch(SQLException e){
					e.printStackTrace();
				}
				ct=null;
			}
		}
	}

}