|
|
| Connection Pooling |
Expert:Vinikz
|
| Answers |
Hello ;;;;;;;;;;;;<br /><br />conpool.jsp<br />-----------<br /><%@page import="java.sql.Connection"%><br /><jsp:useBean id="pl" class="com.CoreJava.ConnectionPooling"/><br /><% Connection con = pl.getConnection(); %><br />//do something using con<br /><br />connectionPooling.java<br />-----------------------<br /><br />import com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource;<br /><br />public class ConnectionPooling <br />{<br />static Connection con=null;<br />public static Connection getConnection()<br />{<br /> try<br /> {<br /> MysqlConnectionPoolDataSource po=new MysqlConnectionPoolDataSource();<br /> po.setServerName("localhost");<br /> po.setPortNumber(3306);<br /> po.setDatabaseName("mydatabase"); //changeur database name<br /> po.setUser("root");//ur username<br /> po.setPassword("");//ur password<br /> con = po.getConnection();<br /> }<br /> catch(Exception e)<br /> {<br /> System.out.println("Exception Connection :"+e);<br /> }<br /> return con;<br />}<br /><br />thanks<br />Rajanikant<br />
|
| More Questions |
|
|
Post Answers
Ask Question
Facing Programming Problem?
|
|
|
|
|
