vlambda博客
学习文章列表

//1、注册驱动Class.forName("com.mysql.jdbc.Driver");//数据库连接所需参数String user = "root";String password = "123456";String url = "jdbc:mysql://localhost:3306/sampledb?useUnicode=true&characterEncoding=utf-8";//2、获取连接对象Connection conn = DriverManager.getConnection(url, user, password);

Connection getConnection()Connection getConnection(String username, String password)

package jdbc;import com.alibaba.druid.pool.DruidDataSource;import com.mchange.v2.c3p0.ComboPooledDataSource;import java.sql.Connection;import java.sql.ResultSet;import java.sql.Statement;import org.apache.commons.dbcp2.BasicDataSource;public class MyDataSource { public static void main(String[] args) throws Exception { String user = "root"; String password = "123456"; String url = "jdbc:mysql://localhost:3306/sampledb?useUnicode=true&characterEncoding=utf-8"; //1.获取连接 // Connection conn = getDHCPConnection(user,password,url); //Connection conn = getC3P0Connection(user,password,url); Connection conn = getDruidConnection(user, password, url); String sql = "select * from student limit 0,10"; //2、获得sql语句执行对象 Statement stmt = conn.createStatement(); //3、执行并保存结果集 ResultSet rs = stmt.executeQuery(sql); //4、处理结果集 while (rs.next()) { System.out.print("id:" + rs.getInt(1)); System.out.print(",姓名:" + rs.getString(2)); System.out.print(",年龄:" + rs.getInt(3)); System.out.println(",性别:" + rs.getString(4)); } conn.close(); stmt.close(); rs.close();}public static Connection getDruidConnection(String user, String password, String url)throws Exception { DruidDataSource ds = new DruidDataSource(); ds.setUsername(user); ds.setPassword(password); ds.setUrl(url); ds.setDriverClassName("com.mysql.jdbc.Driver"); return ds.getConnection(); }public static Connection getC3P0Connection(String user, String password, String url)throws Exception { ComboPooledDataSource cpds = new ComboPooledDataSource(); cpds.setUser(user); cpds.setPassword(password); cpds.setJdbcUrl(url); cpds.setDriverClass("com.mysql.jdbc.Driver"); return cpds.getConnection(); }public static Connection getDHCPConnection(String user, String password, String url)throws Exception { BasicDataSource dataSource = new BasicDataSource(); dataSource.setUsername(user); dataSource.setPassword(password); dataSource.setUrl(url); dataSource.setDriverClassName("com.mysql.jdbc.Driver"); Connection connection = dataSource.getConnection(); return connection; }}