JDBC连接数据库

怎样和数据库建立连接如下步骤：

                         1.加载驱动。

                         2.建立数据库连接

                         3.声明一个陈述对象

                         4.返回一个结果集

                         5.关闭

                         6.如下代码简单所示：     

                        

package com;

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

public class SocketOne {
  private Connection con;
     private ResultSet rs;
     private PreparedStatement ps;
     public void getCon() {
   try {
    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    con = DriverManager
      .getConnection(
        "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=study",
        "sa", "1");
   } catch (ClassNotFoundException e) {
    e.printStackTrace();
   } catch (SQLException e) {
    e.printStackTrace();
   }
  }

  public void closeAll() {
   try {
    if (rs != null)
     rs.close();
    if (ps != null)
     ps.close();
    if (con != null)
     con.close();

   } catch (SQLException e) {
    e.printStackTrace();
   }
  }
}