Java编程 JDBC连接Mysql数据库

深藏阁楼爱情的钟 2024-03-31 16:52 25阅读 0赞

JDBC连接数据库步骤参考上篇文章即可

[Java编程 JDBC连接Oracle数据库][Java_ JDBC_Oracle]

首先需要导入MySQL连接需要的jar包

![15c60186c1f44e7591bfb9cb63fdaae9.png][]

完整示例

import java.sql.*;
    public class jdbctest {
    	public static void main(String[] args) {
    		String url= "jdbc:mysql://127.0.0.1:3306/test";
    		String user="root";
    		String password="root";
    		Statement stmt=null;
    		Connection conn=null;
    		try {
    			
    			Class.forName("com.mysql.cj.jdbc.Driver");
    			conn= DriverManager.getConnection(url,user,password);
    //			System.out.println("linked successfully");
    			stmt=conn.createStatement();
    			String query="select * from user";
    			ResultSet rs=stmt.executeQuery(query);
    			while(rs.next()){
    			    System.out.println("编号为："+rs.getString("id")+"姓名为："+rs.getString("username")+"密码为："+rs.getString("passwd"));
    			}
    			rs.close();
    		} catch (SQLException se) {
    			se.printStackTrace();
    		} catch (Exception e) {
    			e.printStackTrace();
    		} finally {
    			try {
    				if (stmt!=null) {
    					stmt.close();;
    				}
    				if (conn!=null) {
    					conn.close();
    				}
    			} catch (Exception e2) {
    				e2.printStackTrace();
    			}
    			System.out.println("Over!");
    		}
    
    	}
    
    }

> 8.0版本以上的jdbc使用‘com.mysql.cj.jdbc.Driver’驱动，运行结果如下。

![187174cb53fa41afbb97f205f852b1d1.png][]

[Java_ JDBC_Oracle]: https://blog.csdn.net/weixin_49183673/article/details/128245291?csdn_share_tail=%7B%22type%22%3A%22blog%22%2C%22rType%22%3A%22article%22%2C%22rId%22%3A%22128245291%22%2C%22source%22%3A%22weixin_49183673%22%7D
[15c60186c1f44e7591bfb9cb63fdaae9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/6a305e9705ed4fdcb618e8fb8ecb4589.png
[187174cb53fa41afbb97f205f852b1d1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/aeb34f368e8448919e4692d2240da078.png