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

来源：互联网发布：淘宝网兼职客服招聘编辑：程序博客网时间：2024/04/29 11:35

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"));//            }//        }}

0 0