1091c70cde86001d18b3f3489ec5d0da

来自「一个相对比较简单的留言簿！功能还比较齐全！」· 代码 · 共 32 行

package com.pure35.database;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBConn {
	private static Connection con;
	public static Connection getConnection() throws ClassNotFoundException, SQLException
	{
		String url="jdbc:mysql://localhost:3306/guestbook";
		 String user="root";
		 String pass="123";
		Class.forName("com.mysql.jdbc.Driver");
		con=DriverManager.getConnection(url, user, pass);
		System.out.println("连接数据库成功");
		return con;
	}
	 public  static void  closeConnection()
		{			
			try
			{
				con.close();
				System.out.println("数据库关闭成功");
			} catch (SQLException e)
			{
				
				e.printStackTrace();
			} 
		}
}