jdbc读取properties文件连接数据库

jdbc驱动通过properties文件存储数据库相关信息

连接数据库模块

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ResourceBundle;

public class jdbcUtil {
    //获取connection对象
    //关闭connection
    //关闭statement对象
    private static String driver;
    private static String connectionUrl;
    private static String username;
    private  static String psw;

    static {
        //读取propertile
       ResourceBundle  bundle=ResourceBundle.getBundle("jdbc");
        driver=bundle.getString("driver");
        connectionUrl=bundle.getString("connectionUrl");
        username=bundle.getString("username");
        psw=bundle.getString("psw");

        try {
            Class.forName(driver);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
    public static Connection getConnection(){
        Connection conn=null;
        try {
            conn= DriverManager.getConnection(connectionUrl,username,psw);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return conn;
    }
    public static void closeStatement(Statement state){
        if(state!=null){
            try {
                state.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
    public static void closeConnection(Connection conn){
        if(conn!=null){
            try {
                conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

properties文件内容，注意bundle.getString(“XXX”);XXX要和该文件中的变量名一样，比如bundle.getString(“driver”);

driver =com.mysql.jdbc.Driver
connectionUrl=jdbc:mysql://localhost:端口号/数据库名?useUnicode=true&characterEncoding=utf8
username =root//（默认是root）
psw=******//（连接数据库的密码）

测试类

package jdbc;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class testJdbc {
    public void insertTable(){
        //驱动注册
        Connection conn=null;
        Statement state=null;
        try {
            conn=jdbcUtil.getConnection();
            //String str="insert into usertable values(5,'zhao','123','123@1qq')";
            String str1="select *from usertable";
            state=conn.createStatement();
            ResultSet rs=state.executeQuery(str1);
            //int flag=state.executeUpdate(str);
            //System.out.print(flag);
            while(rs.next()){
                System.out.println(rs.getString("id")+" "+rs.getString("username")+" "
                        +rs.getString("password")+" "+rs.getString("email"));
            }
            if(rs!=null){
                rs.close();
            }

        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            jdbcUtil.closeConnection(conn);
            jdbcUtil.closeStatement(state);

        }

    }
    public static void main(String[] args) {
        testJdbc test=new testJdbc();
        test.insertTable();

    }
}

运行如下

修改数据库信息时只需要在properties中修改即可