Three methods of connecting MySQL with Java

From , 3 Years ago, written in Java, viewed 227 times.

import java.sql.Connection;   
import java.sql.DriverManager;   
import java.util.Properties;   
 
//java 连接MySql的三种方法
public class ConnectionUtil { 
   
        //第一种方法   
        public Connection getConnection(){   
                Connection conn = null;   
                try {   
                        //Class.forName加载驱动   
                        Class.forName("com.mysql.jdbc.Driver");   
                        //DriverManager获得连接   
                        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc_db","root","mysqladmin");   
                        return conn;   
                } catch (Exception e) {   
                        e.printStackTrace();   
                }   
                return null;   
        }  
 
  
        //第二种方法   
        public Connection getConnection(String driver,String url,String user,String password){   
                Connection conn = null;   
                try {   
                        //Class.forName加载驱动   
                        Class.forName(driver);   
                        //DriverManager获得连接   
                        conn = DriverManager.getConnection(url,user,password);   
                        return conn;   
                } catch (Exception e) {   
                        e.printStackTrace();   
                }   
                return null;   
        }   
 
 
        //第三种方法   
        public Connection openConnection(){   
                String driver = "";   
                String url = "";   
                String user = "";   
                String password = "";   
                Properties prop = new Properties();   
                Connection conn = null;   
                try {   
                        //加载属性文件   
                        prop.load(this.getClass().getClassLoader().getResourceAsStream("DBConfig.properties"));   
                        driver = prop.getProperty("driver");   
                        url = prop.getProperty("url");   
                        user = prop.getProperty("user");   
                        password = prop.getProperty("password");   
                        //Class.forName加载驱动   
                        Class.forName(driver);   
                        //DriverManager获得连接   
                        conn = DriverManager.getConnection(url,user,password);   
                        return conn;   
                } catch (Exception e) {   
                        e.printStackTrace();   
                }   
                return null;   
        }   
 
}
 

Reply to "Three methods of connecting MySQL with Java"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

import java.sql.Connection;   
import java.sql.DriverManager;   
import java.util.Properties;   
 
//java 连接MySql的三种方法
public class ConnectionUtil { 
   
        //第一种方法   
        public Connection getConnection(){   
                Connection conn = null;   
                try {   
                        //Class.forName加载驱动   
                        Class.forName("com.mysql.jdbc.Driver");   
                        //DriverManager获得连接   
                        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jdbc_db","root","mysqladmin");   
                        return conn;   
                } catch (Exception e) {   
                        e.printStackTrace();   
                }   
                return null;   
        }  
 
  
        //第二种方法   
        public Connection getConnection(String driver,String url,String user,String password){   
                Connection conn = null;   
                try {   
                        //Class.forName加载驱动   
                        Class.forName(driver);   
                        //DriverManager获得连接   
                        conn = DriverManager.getConnection(url,user,password);   
                        return conn;   
                } catch (Exception e) {   
                        e.printStackTrace();   
                }   
                return null;   
        }   
 
 
        //第三种方法   
        public Connection openConnection(){   
                String driver = "";   
                String url = "";   
                String user = "";   
                String password = "";   
                Properties prop = new Properties();   
                Connection conn = null;   
                try {   
                        //加载属性文件   
                        prop.load(this.getClass().getClassLoader().getResourceAsStream("DBConfig.properties"));   
                        driver = prop.getProperty("driver");   
                        url = prop.getProperty("url");   
                        user = prop.getProperty("user");   
                        password = prop.getProperty("password");   
                        //Class.forName加载驱动   
                        Class.forName(driver);   
                        //DriverManager获得连接   
                        conn = DriverManager.getConnection(url,user,password);   
                        return conn;   
                } catch (Exception e) {   
                        e.printStackTrace();   
                }   
                return null;   
        }   
 
}

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?

Spam protection Type in the letters

https://burned.cc - Burn After Reading Website

Pastebin.vip

Three methods of connecting MySQL with Java

Reply to "Three methods of connecting MySQL with Java"