jdbc连接数据库

import  java.sql. * ;

public   class  TestJDBC  ... {

    public static void main(String[] args) ...{
        ResultSet rs = null;
        Statement stmt = null;
        Connection conn = null;
        try ...{
            /**//*连接   oracle  一定要记住要先加载驱动包
            // Load the Driver
            //1.Class.forName("")或Class.forName("").newInstance()或new DriverName("")
            //2.实例化是自动向DriverManager注册，不需要显示调用DriverManager.registerDriver方法
            Class.forName("oracle.jdbc.driver.OracleDriver");
            String url="jdbc:oracle:thin:@10.11.47.10:1521:ieshow";
            String user="scott";
            String password="123456";
            conn = DriverManager.getConnection(url, user, password);//连接到数据库
            stmt = conn.createStatement();
            rs = stmt.executeQuery("select * from user");
            while(rs.next()) {
                System.out.println(rs.getInt("id"));
                System.out.println(rs.getString("name"));
                System.out.println(rs.getString("address"));
            }
            */
            //连接MySql       一定要记住要先加载驱动包
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://localhost/data?user=root&password=123456";
            conn = DriverManager.getConnection(url);
            stmt = conn.createStatement();
            rs = stmt.executeQuery("select * from user");
            while(rs.next()) ...{
                System.out.println(rs.getInt("id"));
                System.out.println(rs.getString("name"));
                System.out.println(rs.getString("address"));
            }
            
            /**//*连接sqlServer
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
            String user="wangjun";
            String password="123456";
            conn = DriverManager.getConnection(url, user, password);
            */
        } catch (ClassNotFoundException e) ...{
            e.printStackTrace();
        } catch (SQLException e) ...{
            e.printStackTrace();
        } finally ...{
            try ...{
                if(rs != null) ...{  //关闭结果集
                    rs.close();
                    rs = null;
                }
                if(stmt != null) ...{ //关闭查询语句
                    stmt.close();
                    stmt = null;
                }
                if(conn != null) ...{ //半闭连接
                    conn.close();
                    conn = null;
                }
            } catch (SQLException e) ...{
                e.printStackTrace();
            }
        }
    }

}