对于JDBC数据库的初始化操作

package com.bluesky.connection;

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

public class connection {
        private static final String URL="jdbc:mysql://localhost/test";
        private static final String USER="root";
        private static final String PASSWORD="1234";
        private static Connection conn=null;
        static{

            try {
                //1.加载驱动程序
                Class.forName("com.mysql.jdbc.Driver");
                //2.获取数据库连接
                conn=DriverManager.getConnection(URL, USER, PASSWORD);
            } catch (ClassNotFoundException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        public static Connection getConnnection(){
            return conn;
        }
//        public static void main(String[] args) throws Exception {
//
//            //3.操作数据库
//            Statement stmt=conn.createStatement();
//            ResultSet rs=stmt.executeQuery("Select * from user");
//            while (rs.next()) {
//                System.out.println(rs.getString("id")+rs.getString("password"));
//            }
//        }
}