mysql数据库连接代码

数据库驱动加载代码如下：

try {
        Class.forName("com.mysql.cj.jdbc.Driver");
        System.out.println("数据库驱动加载成功！");
    } 

修改成自己的数据库名：

shop改成自己的数据库名

pwd改成自己的密码

String url="jdbc:mysql://localhost:3306/shop";
    String name="root";//
    String pwd="123456";

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class TextConnect {
  public static Connection getConnection(){
    String driver="com.mysql.cj.jdbc.Driver";
    String url="jdbc:mysql://localhost:3306/shop";
    String name="root";//
    String pwd="123456";
    try{
      Class.forName(driver);
      Connection conn=DriverManager.getConnection(url,name,pwd);//获取连接对象
      return conn;
    }catch(ClassNotFoundException e){
      e.printStackTrace();
      return null;
    }catch(SQLException e){
      e.printStackTrace();
      return null;
    }
  }
public static void closeAll(Connection conn,PreparedStatement ps,ResultSet rs){
    try{
      if(rs!=null){
        rs.close();
      }
    }catch(SQLException e){
      e.printStackTrace();
    }
    try{
      if(ps!=null){
        ps.close();
      }
    }catch(SQLException e){
      e.printStackTrace();
    }
    try{
      if(conn!=null){
    	  conn.close();
      }
    }catch(SQLException e){
      e.printStackTrace();
    }
  }
  public static void main(String[] args) throws SQLException
  {
    Connection cc=TextConnect.getConnection();
    if(!cc.isClosed())
    System.out.println("Succeeded connecting to the Database!");
    Statement statement = cc.createStatement();
    String sql = "select * from user";
    ResultSet rs = statement.executeQuery(sql);
    while(rs.next()) {
      System.out.println(rs.getString("logname")+"");
    }
  }
}

或者

import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class TextConnect {
	private final static String username = "root";
	private final static String password = "123456";
	private final static String url = "jdbc:mysql://localhost:3306/shop";
	public static void main(String[] args){
	try {
		Class.forName("com.mysql.cj.jdbc.Driver");
		System.out.println("数据库驱动加载成功！");
	}
	catch(Exception e) {
		e.printStackTrace();
		System.out.println("连接数据库失败！");
	}
	try {
		Connection connect = DriverManager.getConnection(url,username,password);
		Statement stmt = connect.createStatement();
		ResultSet rs = stmt.executeQuery("select * from user");
		System.out.println("连接数据库成功！");
		while(rs.next()) {
			System.out.print("id:" + rs.getInt("id"));
			System.out.print("name:" + rs.getString("name"));
			System.out.println("pwd:" + rs.getString("pwd"));
		}
	}catch(Exception e) {
		e.printStackTrace();
	}
}
}