JDBC连接数据库的性能



package com.study.security;

 

import java.io.UnsupportedEncodingException;

import java.security.NoSuchAlgorithmException;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.Date;

 

public class SecurityApp {

     private static String user = "root" ;

     private static String password = "" ;

     private static String url = "jdbc:mysql://localhost:3306/tangsystemdb?useUnicode=true&characterEncoding=UTF-8" ;

 

     private static Connection con = null ;

 

     public static void main(String[] args) throws NoSuchAlgorithmException, UnsupportedEncodingException, SQLException {

         query();

         query();

         query();

         if (con != null )

             con.close();

     }

 

     public static void query() throws SQLException {

         PreparedStatement statement = null ;

         ResultSet rs = null ;

         try {

             long start = new Date().getTime();

             con = con == null ? DriverManager.getConnection(url, user, password) : con;

             statement = con.prepareStatement( "select count(1) from t_user" );

             rs = statement.executeQuery();

             System.out.println( "耗时：" + ( new Date().getTime() - start));

         } catch (Exception e) {

 

         } finally {

             if (rs != null )

                 rs.close();

             if (statement != null )

                 statement.close();

         }

 

     }

}