DBUtils工具

最新推荐文章于 2022-09-19 23:47:47 发布

秋刀鱼的族谱

最新推荐文章于 2022-09-19 23:47:47 发布

阅读量1k

点赞数 1

文章标签： java 数据库 mysql

本文链接：https://blog.csdn.net/qq_55689615/article/details/121885907

版权

本文详细介绍了如何在JDBC库中创建user表，包括BaseDao类的实现，User类的设计，以及使用不同数据库连接方式（DBCP、配置文件和C3P0）进行数据库操作。展示了如何通过Example01-04类进行连接测试和获取元数据。

摘要由CSDN通过智能技术生成

1、在jdbc库中创建user表
在这里插入图片描述
2、复制JDBCUtils.java文件到cn.itcast.chapter10.example包下
3、在包中创建BaseDao类

package cn.itcast.chapter10.example;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.apache.commons.dbutils.ResultSetHandler;

public class BaseDao {
public static Object query(String sql,ResultSetHandler<?> rsh,Object...params) throws SQLException {
	Connection conn=null;
	PreparedStatement pstmt=null;
	ResultSet rs=null;
	Object obj=null;
	try {
		conn=JDBCUtils.getConnection();
		pstmt=conn.prepareStatement(sql);
		for(int i=0;params!=null && i<params.length;i++) {
			pstmt.setObject(i+1, params[i]);
		}
		rs=pstmt.executeQuery();
	    obj=rsh.handle(rs);
	}catch(Exception e) {
		return new Exception(e.getMessage());
	}
	finally {
		JDBCUtils.release(rs,pstmt,conn);
	}
	return rs;
	
}
}

4、创建User类

package cn.itcast.chapter10.example;

public class User {
private int id;
private String name;
private String password;
public int getId() {
	return id;
}
public void setId(int id) {
	this.id=id;
}
public String getName() {
	return name;
}
public void setName(String name) {
	this.name=name;
}
public String getPassword() {
	return password;
}
public void setPassword(String password) {
	this.password=password;
}
}

5、创建ResultSetTest1、2、3、4这4个类

package cn.itcast.chapter10.example;
import java.sql.DatabaseMetaData;
import java.sql.SQLException;

import javax.sql.DataSource;

import org.apache.commons.dbcp.BasicDataSource;


import java.sql.Connection;
public class example01 {
public static DataSource ds=null;
static {
	BasicDataSource bds=new BasicDataSource();
	bds.setDriverClassName("com.mysql.jdbc.Driver");
	bds.setUrl("jdbc:mysql://localhost:3306/jdbc");
	bds.setUsername("root");
	bds.setPassword("123456");
	bds.setInitialSize(5);
	bds.setMaxActive(5);
	ds=bds;
}
public static void main(String[] args) throws SQLException {
	Connection conn=ds.getConnection();
	DatabaseMetaData metadata=conn.getMetaData();
	System.out.println(metadata.getURL()+",UserName="+metadata.getUserName()+","+metadata.getDriverName());
}
}

package cn.itcast.chapter10.example;

import java.io.InputStream;
import java.sql.DatabaseMetaData;
import java.sql.SQLException;
import java.util.Properties;

import javax.sql.DataSource;

import org.apache.commons.dbcp.BasicDataSourceFactory;

import java.sql.Connection;

public class example02 {
public static DataSource ds=null;
static {
	Properties prop=new Properties();
	try {
		InputStream in=new example02().getClass().getClassLoader().getResourceAsStream("dbcp.properties");
		prop.load(in);
		ds=BasicDataSourceFactory.createDataSource(prop);
	}catch (Exception e) {
		e.printStackTrace();
	}
}
public static void main(String[] args) throws SQLException{
	Connection conn=ds.getConnection();
	DatabaseMetaData metadata=conn.getMetaData();
	System.out.println(metadata.getURL());
	System.out.println(metadata.getUserName());
	System.out.println(metadata.getDriverName());
}
}

package cn.itcast.chapter10.example;

import java.beans.PropertyVetoException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.SQLException;

import javax.sql.DataSource;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class example03 {
public static DataSource ds=null;
static {
ComboPooledDataSource cpds=new ComboPooledDataSource();
try {
cpds.setDriverClass(“com.mysql.jdbc.Driver”);
cpds.setJdbcUrl(“jdbc:mysql://localhost:3306/jdbc”);
cpds.setUser(“root”);
cpds.setPassword(“123456”);
cpds.setInitialPoolSize(5);
cpds.setMaxPoolSize(10);
ds=cpds;
}catch(PropertyVetoException e) {
e.printStackTrace();
}
}
public static void main(String[] args) throws SQLException{
Connection conn=ds.getConnection();
DatabaseMetaData metadata=conn.getMetaData();
System.out.println(metadata.getURL());
System.out.println(metadata.getUserName());
System.out.println(metadata.getDriverName());

}
}

package cn.itcast.chapter10.example;

import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.SQLException;

import javax.sql.DataSource;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class example04 {
public static DataSource ds=null;
static {
ComboPooledDataSource cpds=new ComboPooledDataSource(“dashuju”);
ds=cpds;
}
public static void main(String[] args) throws SQLException{
Connection conn=ds.getConnection();
DatabaseMetaData metadata=conn.getMetaData();
System.out.println(metadata.getURL());
System.out.println(metadata.getUserName());
System.out.println(metadata.getDriverName());
}
}