Java代码与mysql数据库的连接

最新推荐文章于 2023-03-30 18:22:55 发布

YonGet

最新推荐文章于 2023-03-30 18:22:55 发布

阅读量537

点赞数

本文链接：https://blog.csdn.net/YonGet/article/details/52223991

版权

第一步建立一个JdbcMysqlpool类

public class JdbcMysqlpool {
	static{
		try {

<span style="white-space:pre">			</span>// 动态引入数据库驱动类
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	
	public Connection getConnection(){
		Connection con =null;
		String url = "jdbc:mysql://192.168.13.21/java6?useUnicode=true&characterEncoding=utf-8&useSSL=false";
		String user = "user01";
		String password = "Password1!";
		try {

<span style="white-space:pre">			// 发起连接</span>
			con = DriverManager.getConnection(url, user, password);
		} catch (SQLException e) {
			e.printStackTrace();
		}

		return con;
	}
}

第二部建立一个JdbcConnectionTest测试类

public class JdbcConnectionTest {
	public static void main(String[] args){
		JdbcMysqlpool jdbc = new JdbcMysqlpool();
		
		Connection con = jdbc.getConnection();
		try {
			System.out.println(con.isClosed());
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				if(con!=null)
				con.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}