数据库的简单封装

package com.chinasoft.diancan.a;

import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;

public class jdbcutil {
  
    
    
     public static Connection getConection(){
    	 try {
			Class.forName("com.mysql.jdbc.Driver");
			System.out.println("驱动加载成功");
		} catch (ClassNotFoundException e1) {
			// TODO 自动生成的 catch 块
			e1.printStackTrace();
		}
		 System.out.println("成功加载mysql驱动");
         Connection conn=null;
         String URL = "jdbc:mysql://localhost:3306/我的数据库";
   	     String USERRNAME = "root";
   	     String PASSWORD = "123456";
         try{
         conn=DriverManager.getConnection(URL, USERRNAME, PASSWORD);
         System.out.println("数据库连接成功");
         }
         catch (Exception e) {
                 e.printStackTrace();
             }
          return conn;
        }
     public static void close(Connection conn) {
           try {
               if (conn != null)
                    conn.close();
              } catch (Exception e) {
                e.printStackTrace();
              }
          }
     
       }