java最原始连接数据库方法代码
- package com.jinhei.base;
- import java.sql.*;
- public class JDBCQuick {
- public static void main(String[] args) throws Exception {
- // 1,注册驱动
- // Class.forName("com.mysql.cj.jdbc.Driver");
- //2.获取数据库连接
- Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/jinhei", "root","root");
- //3.创建Statement对象
- Statement statement = connection.createStatement();
- //4.编写SQL语句并执行,获取结果
- String sql = "select * from t_emp";
- ResultSet resultSet = statement.executeQuery(sql);
- //5.处理结果
- while (resultSet.next()) {
- int empId = resultSet.getInt("emp_id");
- String empName = resultSet.getString("emp_name");
- String empSalary = resultSet.getString("emp_salary");
- int empAge = resultSet.getInt("emp_age");
- System.out.println(empId + "\t" + empName + "\t" + empSalary + "\t" + empAge);
- }
- //6.释放资源(先开后关原则)
- resultSet.close();
- statement.close();
- connection.close();
- }
- }
复制代码 |