使用datasource的方法建立到MySQL数据的连接。

import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;/** * 使用datasource方法建立mysql数据库连接。 * @author bestree007; * */public class MYSQLConnection {public static void main(String[] args) {com.mysql.jdbc.jdbc2.optional.MysqlDataSource ds;Connection conn2;// create connection with a datasource objectds = new com.mysql.jdbc.jdbc2.optional.MysqlDataSource();ds.setServerName("localhost");ds.setDatabaseName("bestree");ds.setPort(3306);// ds.setURL("jdbc:mysql://localhost:3306/bestree");try {conn2 = ds.getConnection("bestree", "password");if (!conn2.isClosed()) {System.out.println("Succeeded connecting to the Database!");}Statement statement = conn2.createStatement();String sql = "select * from pet";ResultSet rs = statement.executeQuery(sql);while (rs.next()) {String name = rs.getString("name");System.out.println(name);}rs.close();conn2.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}