JAVA连接数据库ij_java idea 连接数据库

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

public class QueryDemo {

public static void main(String[] args) throws Exception {

QueryDemo demo = new QueryDemo();

demo.findAllDept();

}

//查找所有的部门

public void findAllDept() throws ClassNotFoundException, SQLException{

//1.注册数据库驱动

Class.forName("com.mysql.cj.jdbc.Driver");

//2.与数据库建立连接

Connection conn = DriverManager.getConnection(

"jdbc:mysql://@localhost:3306/oaec",

"root", "root");

//3.创建用来执行SQL语句的Statement对象

Statement stmt = conn.createStatement();

//4.执行SQL语句

String sql = "select id,name,region_id from s_dept";

//执行查询：exe