Common data Sources in Java

Data Source: Stores all information that establishes a database connection. Just as you can find files in the file system by specifying a file name, you can find the appropriate database connection by providing the correct data source name.

Create DataSource in 1.JNDI mode

1.1 Configure the relevant connection information for the data source, which can be configured in the Conf/context.xml file in the Tomcat installation directory.
It is configured as follows:

[HTML]View PlainCopy

2. <Context>
4. ......
6. <!--MySql --
8. <Resource name="jdbc/orclight" auth="Container "
12. type= "Javax.sql.DataSource"maxactive= " maxidle="
16. maxwait= "10000"username= "root" password="root "
20. driverclassname="Com.mysql.jdbc.Driver"
24. url="jdbc:mysql://localhost:3306/orclight"/>
26. ......
28. </Context>

1.2 Create a data source in a Jndi way in the program to get the database connection to the appropriate operation

The code is as follows:

[Java]View PlainCopy

1. /Initialize Jndi context, create DataSource object
3. Context Initcontext = new InitialContext ();
5. Context context = (context) initcontext.lookup ("java:comp/env");
7. Datasourcedatasource = (DataSource) context.lookup ("jdbc/orclight");

2.Apache provides a dbcp way to create a data source

2.1 To create a data source in this way, you must first prepare two jar files: Commons-dbcp.jar and Commons-pool.jar.

2.2 Data sources created in this way are no longer javax.sql.DataSource. DataSource, but Org.apache.commons.dbcp.BasicDataSource.

The code is as follows:

[Java]View PlainCopy

2. Create a Basicdatasource object
6. Basicdatasource ds = new Basicdatasource ();
10. Ds.setdriverclassname ("Com.mysql.jdbc.Driver");
14. Ds.seturl ("jdbc:mysql://localhost:3306/orclight");
18. Ds.setusername ("root");
22. Ds.setpassword ("root");
26. Ds.setinitialsize (50);
30. Ds.setmaxactive (100);
32. Ds.setmaxidle (30);
34. Ds.setmaxwait (10000);
36. //Turn off data source connections
38. Ds.close ();

3.c3p0 way to create a data source

3.1 Creating a data source using C3P0 method you should first prepare a jar file: C3p0-0.9.1.2.jar, put it in the Web/lib directory,

You can use C3P0 to create a data source in your project

The data source object created by 3.2 3.2 C3p0 is also not a DataSource object, but Combopooleddatasource.

The code is as follows:

[Java]View PlainCopy

2. Create a Combopooleddatasource object
6. Combopooleddatasource ds = new Combopooleddatasource ();
10. Ds.setdriverclass ("Com.mysql.jdbc.Driver");
14. Ds.setjdbcurl ("jdbc:mysql://localhost:3306/orclight");
18. Ds.setuser ("root");
22. Ds.setpassword ("root");
26. Ds.setinitialpoolsize (50);
30. Ds.setmaxpoolsize (100);
34. Ds.setmaxidletime (10000);

Common data Sources in Java