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();}
}
}

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！