仅4,5点需要自己更改
package com.lhh.test;
import com.mysql.jdbc.Driver;
import java.sql.*;
public class TestJDBC {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
String url ="jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8";
//useUnicode=true&characterEncoding=utf-8解决乱码
String username = "root";
String password = "root";
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
//连接数据库
Connection connection = DriverManager.getConnection(url, username, password);
//向数据库发送SQL的对象Statement:CRUD
Statement statement = connection.createStatement();
//编写SQL
String sql ="select * from users";
//执行查询sql,返回结果集
ResultSet resultSet = statement.executeQuery(sql);
while (resultSet.next()){
System.out.println("id="+resultSet.getObject("id"));
System.out.println("name="+resultSet.getObject("‘name’"));
System.out.println("password="+resultSet.getObject("‘password’"));
System.out.println("email="+resultSet.getObject("email"));
System.out.println("birthday="+resultSet.getObject("birthday"));
}
//关闭链接释放资源
resultSet.close();
statement.close();
connection.close();
}
}