mymain.java

JAVA通过连接池技术连接MYSQL数据库

import java.sql.*;

import poolsample.ConnManager;
import poolsample.ConnectionPool;
public class mymain 
{
	public static void main(String[] args)
	{
		DBConnectionManager manager=null;
		Connection conn=null;
		try
		{
			manager=DBConnectionManager.getInstance();
			if (manager!=null)
	        {
	            conn = manager.getConnection("mypool");
	            if (conn!=null)
	            {
	            ResultSet rs = null ;
	            Statement stmt = null ;
	            String sql="select * from userinfo";
	            stmt=conn.createStatement();
	            rs=stmt.executeQuery(sql);
	            while(rs.next())
	            {
	            	System.out.println("已经成功读取数据了！"+rs.getString("name")+"--"+rs.getString("password"));
	            }
	            }
	        }
		}
		catch(Exception e){System.out.println("wrong!");}
		finally
		{
			manager.freeConnection("mypool",conn);
			System.out.println("已经释放连接");
		}
	}
}