java c3p0 连接 mysql_Java c3p0 连接 MySQL

packagecn.zr.testfilter.Utils;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.util.ArrayList;importjava.util.List;importjavax.sql.DataSource;importcn.zr.testfilter.pojo.User;importcom.mchange.v2.c3p0.ComboPooledDataSource;public classConnectionUtils {public static voidmain(String[] args) {

ConnectionUtils utils= newConnectionUtils();

List list =utils.getData();

System.out.println(list);

}public ListgetData(){

List list = new ArrayList();

Connection connection=ConnectionUtils.getConnection();

String sql= "SELECT NAME,AGE FROM USERTEST";

PreparedStatement pStatement= null;

ResultSet rSet= null;try{

pStatement=(PreparedStatement) connection.prepareStatement(sql);

rSet=pStatement.executeQuery();while(rSet.next()) {

User user= new User(rSet.getString("name"), rSet.getInt("age"));

list.add(user);

}returnlist;

}catch(SQLException e) {

e.printStackTrace();

}finally{try{if (rSet != null) {

rSet.close();

}if (pStatement != null) {

pStatement.close();

}if (connection != null) {

connection.close();

}

}catch(SQLException e) {

e.printStackTrace();

}

}return null;

}public staticConnection getConnection() {

DataSource ds= new ComboPooledDataSource("mysqlConnection");try{

Connection connection=ds.getConnection();returnconnection;

}catch(SQLException e) {

e.printStackTrace();

}return null;/*String driver = "com.mysql.jdbc.Driver";

String url = "jdbc:mysql://localhost:3306/mysql";

String user = "root";

String password = "";

try {

Class.forName("com.mysql.jdbc.Driver");

} catch (ClassNotFoundException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

Connection connection = null;

try {

connection = DriverManager.getConnection(url, user, password);

} catch (SQLException e) {

e.printStackTrace();

}

return connection;*/}

}