JDBC关于Druid的自制框架

最新推荐文章于 2022-06-06 21:21:44 发布

砂糖有盐

最新推荐文章于 2022-06-06 21:21:44 发布

阅读量139

点赞数

文章标签： java druid JDBC

本文链接：https://blog.csdn.net/HappySugatLife/article/details/99050189

版权

简单创建一下类并在参数中输SQL语句和占位符所需参数即可。
import com.alibaba.druid.pool.DruidDataSourceFactory;
import javax.sql.DataSource;
import java.sql.;
import java.util.;

public class JDBCUnlit {
Connection conn=null;
PreparedStatement ps =null;
ResultSet rs=null;
public void setps(String sql,Object…a){
try {
Properties p = new Properties();
System.out.println(“请您输入要加载的配置文件的名称”);
new Scanner(System.in).nextLine();
p.load(JDBCUnlit.class.getClassLoader().getResourceAsStream(new Scanner(System.in).nextLine()+".properties"));
DataSource dataSource = DruidDataSourceFactory.createDataSource§;
conn = dataSource.getConnection();
ps = conn.prepareStatement(sql);
ParameterMetaData pmd = ps.getParameterMetaData();
int b = pmd.getParameterCount();
if (a.length!=b){
System.out.println(“您输入的参数错误”);
}
for (int i = 1; i <= b; i++) {
ps.setObject(i,a[i-1]);
}
rs = ps.executeQuery();
if (rs!=null){
ResultSetMetaData md = rs.getMetaData();
int i = md.getColumnCount();
ArrayList objects = new ArrayList<>();
while (rs.next()) {
LinkedHashMap<String, Object> oh = new LinkedHashMap<>();
for (int i1 = 0; i1 < i; i1++) {
String c = md.getColumnName(i1 + 1);
Object object = rs.getObject(i);
oh.put(c,object);
}
objects.add(oh);
}
for (Map object : objects) {
System.out.println(object);
}
}
ps.execute();
if (rs!=null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (ps!=null){
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (conn!=null){
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
} catch (Exception e) {
e.printStackTrace();