jdbc配置数据库

创建数据库连接：

package com.hl.database;

import java.sql.Connection;
import java.sql.DriverManager;

public class JDBCConnectMySQL {
    public static Connection  getConnection(){
        Connection conn = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");     
            System.out.println("Success loading Mysql Driver!");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/githubliaoliaoprojectmysql","root","root");
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println("JDBC方式连接MySQL数据库失败");
            conn = null;
        }
        return conn;
    }
}

数据连接使用和关闭：

package test;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.junit.Test;

import com.hl.database.JDBCConnectMySQL;

/**
 * 测试jdbc数据库连接方式
 * */
public class testDB {
	
	@Test
	public void tst() throws SQLException{
		Connection conn = JDBCConnectMySQL.getConnection();
		Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("select * from userInfo");
        while (rs.next()) {
        	System.out.println(rs.getString("user"));
        	System.out.println(rs.getString("name"));
        }
        if(conn!=null){conn.close();}
	       
	}
	
}