JDBC Link database version three, using C3P0, using jar files of two

Jdbcutil class:

[Java]View PlainCopy

2. Package com.xiaohui.jdbc.util;
6. Import java.sql.Connection;
8. Import java.sql.PreparedStatement;
10. Import Java.sql.ResultSet;
12. Import java.sql.SQLException;
14. Import Javax.sql.DataSource;
16. Import Com.mchange.v2.c3p0.ComboPooledDataSource;
18. Public Final class Jdbcutil {
20. private static Combopooleddatasource DataSource;
22. Static {
24. DataSource = new Combopooleddatasource ();
26. }
28. //Get links
30. public static Connection getmysqlconnection () throws SQLException {
32. return datasource.getconnection ();
34. }
36. //  
38. public static DataSource Getdatasource () {
40. return dataSource;
42. }
46. //Close link
48. public static void Close (Connection conn) throws SQLException {
50. if (conn! = null) {
52. try {
54. Conn.close ();
56. } catch (SQLException e) {
58. E.printstacktrace ();
60. throw E;
62. }
64. }
66. }
70. public static void Close (PreparedStatement pstate) throws SQLException {
72. if (pstate!=null) {
74. Pstate.close ();
76. }
78. }
80. public static void Close (ResultSet rs) throws SQLException {
82. if (rs!=null) {
84. Rs.close ();
86. }
88. }
92. }

C3p0-config.xml [HTML]View PlainCopy

2. <? XML version= "1.0" encoding="UTF-8"?>
4. <c3p0-config>
6. <default-config>
8. < name="Driverclass">com.mysql.jdbc.driver</ Property >
10. < name="user">root </Property>
12. < name="password">root </Property>
14. < name="Jdbcurl">jdbc:mysql://127.0.0.1:3306/mysql4</ Property >
16. </default-config>
18. </c3p0-config>

One DAO for pagination: [Java]View PlainCopy

2. Package Com.xiaohui.cusSys.dao;
6. Import java.sql.SQLException;
8. Import java.util.List;
10. Import Org.apache.commons.dbutils.QueryRunner;
12. Import Org.apache.commons.dbutils.handlers.BeanHandler;
14. Import Org.apache.commons.dbutils.handlers.BeanListHandler;
16. Import Org.apache.commons.dbutils.handlers.ScalarHandler;
18. Import Com.xiaohui.cusSys.domain.Customer;
20. Import Com.xiaohui.cusSys.util.JdbcUtil;
24. Public class Dao {
26. private Queryrunner qr = new Queryrunner (Jdbcutil.getdatasource ());
30. //Return Customer object by ID
32. Public Customer Getcustomerbyid (int id) throws SQLException {
34. String sql = "SELECT * FROM customer where id =?";
36. Customer cus = (customer) qr.query (SQL,
38. New Beanhandler (Customer.   Class), id);
40. return cus;
42. }
46. //Paging back
48. Public list<customer> getfylist (int start, int size) throws SQLException {
50. list<customer> list = null;
52. String sql = "SELECT * FROM Customer limit?,?";
54. List = Qr.query (sql, new Beanlisthandler (Customer. Class), new object[] {
56. Start, size});
58. return list;
60. }
64. //Returns the total number of records
66. public int Getallrecordscount () throws SQLException {
68. String sql = "SELECT COUNT (*) from customer";
70. Long temp = qr.query (sql, new Scalarhandler ());
72. return Temp.intvalue ();
74. }
78. //Delete the specified records by ID
80. public void Deleterecordbyid (int id) throws SQLException {
82. String sql = "Delete from customer where id =?";
84. Qr.update (SQL, id);
86. }
90. //update record information by ID
92. public void Updaterecordbyid (Customer newcus) throws SQLException {
94. String sql = "Update customer set name=?", address=?, tel=?, mail=?, birthday=? where id=? ";
96. Qr.update (
98. Sql
100. New object[] {newcus.getname (), newcus.getaddress (),
102. Newcus.gettel (), Newcus.getmail (),
104. Newcus.getbirthday (), Newcus.getid ()});
106. }
110. //Add a record
112. public void AddRecord (Customer newcus) throws SQLException {
114. String sql = "INSERT into customer (Name,address,tel,mail,birthday) VALUES (?,?,?,?,?)";
116. Qr.update (SQL, new object[] {newcus.getname (), newcus.getaddress (),
118. Newcus.gettel (), Newcus.getmail (),
120. //// convert java.util.Date to Java.sql.Date
122. //New Java.sql.Date (Newcus.getbirthday (). GetTime ())
124. Newcus.getbirthday ()});
126. }
130. }

Jar file: C3p0-0.9.1.2.jar (Critical) Mysql-connector-java-5.1.22-bin.jar (critical) used in DAO to Commons-dbutils-1.5.jar

Top

JDBC Link database version three, using C3P0, using jar files of two