MYSQL jdbc连接工具

最新推荐文章于 2024-01-16 21:56:41 发布

路呀

最新推荐文章于 2024-01-16 21:56:41 发布

阅读量376

点赞数 6

文章标签： mysql 数据库 java

本文链接：https://blog.csdn.net/weixin_48665560/article/details/126765705

版权

//工具依赖提前安装

//MyPropertiesUtil 为

public class MySQLUtil{
static  Properties properties= MyPropertiesUtil.load("config.properties");
static  String MYSQL_URL = properties.getProperty("mysql.url");
static String MYSQL_USERNAME = properties.getProperty("mysql.username");
static String MYSQL_PASSWORD = properties.getProperty("mysql.password");

public static  <T>List<T>queryList(String sql,Class<T>clazz,BooleanunderScoreToCamel ) {
try {
Class.forName("com.mysql.jdbc.Driver");
List<T>resultList= new ArrayList<T>();
Connection conn   = DriverManager.getConnection(MYSQL_URL,MYSQL_USERNAME,MYSQL_PASSWORD);
Statement stat   = conn.createStatement();
ResultSetrs= stat.executeQuery(sql );
ResultSetMetaData md  = rs.getMetaData();
while (  rs.next() ) {
T obj = clazz.newInstance();
for (int i=1;  i<= md.getColumnCount() ;i++  ) {
String propertyName;
if(underScoreToCamel) {
propertyName= CaseFormat.LOWER_UNDERSCORE.to(CaseFormat.LOWER_CAMEL,md.getColumnLabel(i));
                    }else{
propertyName=md.getColumnLabel(i);
                    }
if(rs.getObject(i)!=null){
BeanUtils.setProperty(obj,propertyName, rs.getObject(i));
                    }

                }
resultList.add(obj);
            }

stat.close();
conn.close();
return  resultList;

        } catch ( Exception e) {
e.printStackTrace();
throw  new RuntimeException("查询mysql失败！");
        }
    }

public static    <T>T  queryOne(String sql,Class<T>clazz,BooleanunderScoreToCamel ) {
List<T>queryList= queryList(sql, clazz, underScoreToCamel);
if(queryList.size()>0){
return  queryList.get(0);
        }else{
return null;
        }
    }

}