数据库连接代码

来源：互联网发布：maven java web项目编辑：程序博客网时间：2024/06/07 07:47
package jdbc;import java.io.FileInputStream;import java.io.InputStream;import java.sql.Connection;import java.sql.DriverManager;import java.util.Properties;/** * 获得数据库连接 * @author Administrator * */public class CONN {    private static String url;    private static String user;    private static String pwd;    private static Connection conn;    static{        getProp();        try {            Class.forName("com.mysql.jdbc.Driver");            conn=DriverManager.getConnection(url, user, pwd);        } catch (Exception e) {            e.printStackTrace();        }    }    /**     * 获取配置文件     */    public static void getProp(){        try {            InputStream is=new FileInputStream("src/config.properties");            Properties prop=new Properties();            prop.load(is);//加载配置信息            url=prop.getProperty("url");            user=prop.getProperty("user");            pwd=prop.getProperty("pwd");        } catch (Exception e) {            e.printStackTrace();        }    }    public static Connection getConn(){        return conn;    }}/**//配置文件信息url=jdbc:mysql://localhost:3306/mailuser=rootpwd=root
0 0