Java连接mysql数据库详细步骤

1、首先下载驱动（mysql官网），解压得到jar包，如：mysql-connector-java-5.1.39-bin.jar；

2、加载驱动：右击项目点击 Build Path——>Configure Build Path...

3、接下来，程序实现数据库的连接，首先创建一个类实现数据库的打开和关闭，程序如下：

Connect.jar

package GPS_Data;
import java.sql.*;

import org.omg.CORBA.PUBLIC_MEMBER;
public class Connect {
	public static final String url="jdbc:mysql://localhost:3306/lunwen";
	public static final String name="com.mysql.jdbc.Driver";
	public static final String user="root";
	public static final String password="root";
	
	public Connection conn=null;
	public PreparedStatement pst=null;
			
			
public Connect(String sql){
	try{
		Class.forName(name);
		conn=DriverManager.getConnection(url,user,password);
		pst=conn.prepareStatement(sql);
	}catch(Exception e){
		e.printStackTrace();
	}
	
}
public void close(){
	 try{
		 this.conn.close();
		 this.pst.close();
		 
	 }catch (SQLException e){
		 e.printStackTrace();
	 }
}
}

4、接下来，main函数实现引用，输出查询操作

Preprocess_Model.jar

package GPS_Data;
import java.sql.*;
import GPS_Data.Connect;
public class Preprocess_Model {
static String sql=null;
static Connect mysql1=null;
static ResultSet ret=null;

	public static void main(String[] args) {
		sql="select * from gps_data2";// TODO Auto-generated method stub
        mysql1= new Connect(sql);
        try{
        	ret=mysql1.pst.executeQuery();
        	while (ret.next()){
        		 String lie1 = ret.getString(1);  
                 String lie2 = ret.getString(2);  
                 String lie3 = ret.getString(3);  
                 String lie4 = ret.getString(4);  
                 System.out.println(lie1 + "\t" + lie2 + "\t" + lie3 + "\t" + lie4 );  
        		
        	}
        	
        	ret.close();
        	mysql1.close();
        	
        }catch(SQLException e){
        	e.printStackTrace();
        }
        
        
        
	}

}

查询结果如下：