JDBC连接问题

Question

public class TTTT {
public static void main(String[] args) throws Exception{
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; // 加载JDBC驱动
String dbURL = "jdbc:sqlserver://localhost:1434; DatabaseName=DairySystem"; // 连接服务器和数据库
String userName = "sa"; // 默认用户名
String userPwd = "zhang"; // 密码Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn = DriverManager.getConnection(dbURL, userName, userPwd);
DatabaseMetaData metaData=conn.getMetaData();
System.out.println(metaData.getMaxConnections());
conn.close();//conn不关闭是，下面这句报错
DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("OK");
}
}
sqlserver 2005的并发连接不是无限制的嘛 为什么一定要关闭前面那个连接 然后才能新建连接？？？？？

Answer 1

class Test 
{
      public static void main (String[] args) 
      {
            try
            {
                  Connection conn = getConnection();
                  Statement stat = conn.createStatement();
                  ResultSet result = stat.executeQuery( "SELECT * FROM AAA");
                  result.next();
                  System.out.println(result.getString(1));
                  result.close();
                  stat.close();
                  conn.close();
            }
            catch(SQLException ex)
            {
                  while(ex != null)
                  {
                        ex.printStackTrace();
                        ex = ex.getNextException();
                  }
            }
            catch(IOException ioe)
            {
                  ioe.printStackTrace();
            }
      }      public static Connection getConnection()
            throws SQLException,IOException
      {
            Properties props = new Properties();
            FileInputStream in = new FileInputStream("database.properties");
            props.load(in);
            in.close();
            String drivers = props.getProperty( "jdbc.drivers ");
            if   (drivers != null)
                  System.setProperty("jdbc.drivers",drivers);
            String url = props.getProperty( "jdbc.url");
            String username = props.getProperty("jdbc.username");
            String password = props.getProperty("jdbc.password");
            return DriverManager.getConnection(url,username,password);
      }
}