快捷導(dǎo)航

maven項目連接MySQL方式(使用原生的jdbc)

更新時間：2026年03月12日 10:40:37 作者：小石潭記丶

文章介紹了如何在項目中添加依賴、組織目錄結(jié)構(gòu)、配置數(shù)據(jù)庫連接屬性以及編寫工具類,并分享了個人經(jīng)驗,鼓勵讀者參考和支持腳本之家

1.引入依賴

<dependency>

<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.45</version>

</dependency>

2.項目目錄結(jié)構(gòu)

jdbc.properties內(nèi)容

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/shiro?useUnicode=true&characterEncoding=utf-8&useSSL=false

username=root

password=123456

util類

package com.cxb.shiro;


import java.io.IOException;
import java.util.Properties;


/**
 * 獲取資源文件的util
 * @author 81046
 *
 */
public class PropertiesUtil {
static Properties properties = new Properties();


    public PropertiesUtil() {
    }
    public static boolean loadFile(String fileName){
        try {
            properties.load(PropertiesUtil.class.getClassLoader().getResourceAsStream(fileName));
        } catch (IOException e) {
            e.printStackTrace();
            return false;
        }
        return true;
    }
    public static String getPropertyValue(String key){
        return properties.getProperty(key);
    }


}

package com.cxb.shiro;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;


public class JdbcUtils {


//通過上面的工具就可以獲取到properties文件中的鍵值從而可以加載驅(qū)動 獲取鏈接 從而 可以增刪改查
    private static Connection conn = null;




    public static Connection getConn(){
        PropertiesUtil.loadFile("jdbc.properties");
        String driver = PropertiesUtil.getPropertyValue("driver");
        String url = PropertiesUtil.getPropertyValue("url");
        String username  = PropertiesUtil.getPropertyValue("username");
        String password = PropertiesUtil.getPropertyValue("password");


        try {
            Class.forName(driver);
            conn = DriverManager.getConnection(url,username,password);


        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
            close();
        }
        return conn;
    }
    
    
    public static void close(){
        try {
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

}



/**
* 通過用戶名到數(shù)據(jù)庫中獲取憑證密碼
* @param userName
* @return
*/
private static String getPasswordByUserName(String userName) {
//SQL語句  
String sql = "select password from users where username = " +"'" + userName+"'";
    Connection conn = JdbcUtils.getConn();
    Statement stmt=null; 
    ResultSet ret = null;  
    String password=null;
try {
stmt = conn.createStatement();
//執(zhí)行語句，得到結(jié)果集  
ret = stmt.executeQuery(sql);
            while (ret.next()) {  
            //這里只查詢的密碼
            password = ret.getString(1);  
            }
            ret.close();  
            conn.close();//關(guān)閉連接  
} catch (SQLException e1) {
e1.printStackTrace();
}  
return password;
}