个人简历管理系统（2）-数据库连接

矫情吗；* 2022-01-09 19:41 342阅读 0赞

### 数据库连接 ###

在com.resume.jdbc文件夹下创建jdbc java类，运行前导入jar包  
![示意图][20190620180041490.png]  
jar下载  
[官网下载][Link 1]  
[博客下载][Link 2]

package com.resume.jdbc;
    
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;
    
    public class jdbc { 
    	private final static String driver="com.mysql.jdbc.Driver";
    	private final static String url = "jdbc:mysql://127.0.0.1:3306/resume?useSSL=false";
    	private final static String user = "root";
    	private final static String password  ="";
    	public static Connection getConn() { 
    		Connection connection = null;
    		try { 
    			Class.forName(driver);
    			connection=DriverManager.getConnection(url, user, 
                password);
    		} catch (ClassNotFoundException e) { 
    			System.out.println("数据库驱动加载失败");
    			e.printStackTrace();
    		}catch (SQLException e) { 
    			System.out.println("数据库连接失败");
    			e.printStackTrace();
    		}
    		return connection;
    	}
    	
    	public static void close (Connection connection ,Statement 
        statement , ResultSet resultSet) { 
    		try { 
    			if(connection!=null)connection.close();
    			if(statement!=null)statement.close();
    			if(resultSet!=null)resultSet.close();
    		} catch (SQLException e) { 
    			System.out.println("数据库关闭异常");
    			e.printStackTrace();
    		}
    	}
    	
    	//测试数据库连接是否成功
    	public static void main(String []args) { 
    		Connection connection=null;
    		connection = getConn();
    		System.out.println(connection);
    		close(connection, null, null);
    		
    	}
    }

右击运行  
![示意图][20190620175824689.png]  
运行结果  
![示意图][2019062017591298.png]  
项目相关博客  
[个人简历管理系统（1）-数据库创建][1_-]

参考博客  
[用eclipse创建一个javaweb项目][eclipse_javaweb]  
[封装一个泛型类的JDBC工具类][JDBC]

[20190620180041490.png]: /images/20220109/c0026571121047c6827414fb1200501d.png
[Link 1]: https://mvnrepository.com/
[Link 2]: https://download.csdn.net/download/qq_41146650/11251042
[20190620175824689.png]: /images/20220109/03d4ceb591e048cba834e3d62d79350d.png
[2019062017591298.png]: /images/20220109/b9d9917c0ec94d568aa747db88a89a75.png
[1_-]: https://blog.csdn.net/qq_41146650/article/details/93052508
[eclipse_javaweb]: https://blog.csdn.net/qq_41146650/article/details/93058845
[JDBC]: https://blog.csdn.net/qq_41146650/article/details/92192495