1:带入jar包需要mysql的驱动
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.41</version>
</dependency>
2:链接数据库的配置文件
jdbc.Driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/student
jdbc.username=root
jdbc.password=123456789
3:封装DBUtil
package com.dbutil; import java.io.IOException; import java.io.InputStream; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.Properties; public class ConnectionDBUtil { private static String driver; private static String url; private static String username; private static String password; private static Connection conn; static { Properties proper = new Properties(); InputStream is = ConnectionDBUtil.class.getClassLoader().getResourceAsStream("jdbc.properties"); try { proper.load(is); driver = proper.getProperty("jdbc.Driver"); url = proper.getProperty("jdbc.url"); username = proper.getProperty("jdbc.username"); password= proper.getProperty("jdbc.password"); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } //开启数据连接 public static Connection loadConn(){ try { Class.forName(driver); conn = DriverManager.getConnection(url,username,password); } catch (SQLException | ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } return conn; } //关闭数据连接 public static void close(ResultSet rs,Statement st,Connection conn){ try { if(rs!=null){ conn.close(); } if(st!=null){ conn.close(); } if(conn!=null){ conn.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ rs = null; st = null; conn = null; } } }package worlkDemo; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.dbutil.ConnectionDBUtil; public class TestDButil { public static void main(String[] args) { Connection con = ConnectionDBUtil.loadConn(); Object obj=null; try { PreparedStatement pst = con.prepareStatement("select * from rm_user"); pst.execute(); ResultSet result = pst.getResultSet(); while (result.next()) { obj = result.getString("name"); System.out.println(obj); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }