JDBC访问MySQL数据库

1.下载所需的Connector/j版本

2.正确安装MySQL数据库

3.编写编码，进行测试

package connection.mysql;

import java.io.UnsupportedEncodingException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


public class Demo {
	public static void main(String[] args) {
		//从学生表当中获取信息
		DBHelper db = new DBHelper("select * from stu");
		ResultSet set = null;
		try {
			set = db.pst.executeQuery();
			while(set.next()){
				System.out.println(set.getString(1));
				System.out.println(set.getString(2));
				System.out.println(new String(set.getBytes(3), "gbk"));
				System.out.println(set.getString(4));
			}
			db.close();
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (UnsupportedEncodingException e) {
			e.printStackTrace();
		}
	}

}

class DBHelper{
	//数据库连接字符串
	public static final String url = "jdbc:mysql://localhost/test";
	//驱动程序类
	public static final String driver = "com.mysql.jdbc.Driver";
	//用户名
	public static final String user = "root";
	//密码
	public static final String password = "225821";
	//连接对象和预处理语句
	public Connection conn = null;
	public PreparedStatement pst = null;
	//构造器
	public DBHelper(String sql){
		try {
			//加载驱动程序类
			Class.forName(driver);
			//连接到数据库
			conn = DriverManager.getConnection(url, user, password);
			pst = conn.prepareStatement(sql);
		} catch (Exception e) {
			close();
			e.printStackTrace();
		}
	}
	
	public void close(){
		if(pst != null){
			try {
				pst.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		if(conn != null){
			try {
				
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}