首页 > 代码库 > JDBC

JDBC

1 连接mysql数据库

package lianxi1;import java.io.IOException;import java.io.InputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;import java.util.Properties;import org.junit.Test;public class JdbcTest {@Test        public void test1() throws Exception{        getConnection();    }    // 1写入连接数据库的四个字符串    public Connection getConnection() throws Exception{        // 2 读取类路径下的jdbc.properites文件        InputStream is = getClass().getClassLoader().getResourceAsStream("jdbc.properties");        Properties pro = new Properties();        pro.load(is);        String driver = pro.getProperty("driverClass");        String url = pro.getProperty("url");        String user = pro.getProperty("user");        String password = pro.getProperty("password");        //3 创建连接        Class.forName(driver);        return DriverManager.getConnection(url, user,password);            }}

jdbc.properties文件:

driverClass = com.mysql.jdbc.Driverurl = jdbc\:mysql\://localhost\:3306/testuser = userpassword =1234

JDBC