一、导包
工具包下载地址:http://www.runoob.com/java/java-mysql-connect.html
工具包放在项目中的位置
①Java项目放置位置
右键点击工具包,选择Build Path----------Add to Build Path
②Web项目
复制工具包放置到WebContent------WEB-INF------lib 目录下即可,不需要右键点击导包
二、Java 代码连接 MySQL 数据库
info.properties
driverName=com.mysql.jdbc.Driver url=jdbc\:mysql\://localhost\:3306/day02 username=root password=123
DBUtils.java
public class DBUtils { public static String driverName; public static String url; public static String username; public static String password; static{ //获取配置文件信息 ResourceBundle rb = ResourceBundle.getBundle("info"); driverName = rb.getString("driverName"); url = rb.getString("url"); username = rb.getString("username"); password = rb.getString("password"); } public static Connection getConnection() { try { //注册驱动 Class.forName(driverName); //获取数据库连接对象 Connection connection = DriverManager.getConnection(url, username, password); return connection; } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return null; } }