JDBC连接数据库复习
没什么内容,全写在注释里了。。。~~
package wonderful.wzf;
import java.sql.*;
/**
* @author :wonderful_wzf
* @message:jdbc 的基础知识
* @Bolg :https://blog.youkuaiyun.com/wonderful_wzf
* @date :2020/5/18,19:45
*/
public class JdbcDemo {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//基本信息 ps:小心中文乱码
String url ="jdbc:mysql://localhost:3306/wonderful";
String user = "root";
String password = "root";
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
//建立连接
Connection connection = DriverManager.getConnection(url,user,password);
//执行的sql语句 快捷返回值 Ctrl+Alt+v
String sql= "select * from user";
PreparedStatement preparedStatement = connection.prepareStatement(sql);
//结果集
ResultSet resultSet = preparedStatement.executeQuery();
/* 下面👇:了解就可以,不建议使用
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(sql);*/
while (resultSet.next()){
System.out.println(resultSet.getString(2));
}
}
}
欢迎大家提问探讨~~