package vc; import java.io.IOException; import java.io.InputStream; import java.sql.*; import java.util.*; public class Dbutil { private String version ="1.0"; private String danme="stu"; private String user="root"; private String url="jdbc:mysql://localhost:3306/stu"; private String driver="com.mysql.cj.jdbc.Driver"; private String password="123456"; private Connection conn=null; private int currPage=1; private int pageSize=3; private int pageCount=0; private int recordCount=0; private InputStream is; Properties p=new Properties(); //建立连接 public Dbutil(){ InputStream is= Thread.currentThread().getContextClassLoader().getResourceAsStream("db.properties"); if(is==null){ try { Class.forName(this.driver); this.conn= DriverManager.getConnection(this.url,this.user,this.password); } catch (SQLException | ClassNotFoundException e) { e.printStackTrace(); } }else{ init(); } } //连接数据库 public void connect(String host, String db,String user,String password,int port){ try { this.url=String.format("jdbc:mysql://%s:%d/%s?useUnicode=true&characterEncoding=utf8&serverTimezone=PRC",host,port,db); this.user=user; this.password=password; this.pageSize= Integer.parseInt(p.getProperty("db.pagesize","10")); Class.forName(this.driver); this.co
jdbc工具类的封装
于 2022-03-12 17:09:48 首次发布
这个Java类封装了JDBC连接,提供了连接数据库、执行SQL(查询、增删改)、获取数据库和表名等方法。通过加载配置文件获取数据库连接参数,并处理了异常情况。
摘要由CSDN通过智能技术生成