java连接数据库

需要下载数据库包
我这里使用的是mysql

package com.jdbc.util;

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

import java.sql.PreparedStatement;

public class Jdbc {
   private final static String DRIVER="com.mysql.jdbc.Driver";
   private final static String  URL="jdbc:mysql://localhost:3306/weare";
   private final static String  USER="root";
   private final static String  PWD="root";
   static {
	   try {
		Class.forName(DRIVER);
	} catch (ClassNotFoundException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
   }
   public static Connection con() {
	   Connection con=null;
	   try {
	       con = DriverManager.getConnection(URL, USER, PWD);
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	  return con;
  }
   public static void close(Connection con,PreparedStatement pstm) {
        if(pstm!=null) {
        	try {
				pstm.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
        }
        if(con!=null) {	
        	try {
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
        }
  }
}