jdbconne.java

基于JSP的航空机票订票系统

package com.test;

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


public final class JDBconne 
{
    
  private static Connection connection = null;
  
      public static Connection getConnetion()
      {	
          String url = "jdbc:mysql://localhost:3306/test";
          String user = "root";
          String password = "WELCOME";

                    try
                    {
                            // 注册驱动
                            DriverManager.registerDriver(new com.mysql.jdbc.Driver());
                            // 获得连接对象
                            connection = DriverManager.getConnection(url, user, password);
                    }
                    catch (SQLException e)
                    {
                    }
                    return connection;
      }
      public static void closeConnection()
	{
		try
		{
			if(connection != null) connection.close();
		}
		catch (SQLException e)
		{
		}
	}
    
}