介绍,概念什么的就不用说了,直接开教
1.导入jar包
在项目下创建文件夹(lib)来放置jar包
复制jar包
将jar包粘到lib文件夹下,弹出确定页面点击ok
把jar包放入到工程下并点击add Libaray,弹出确定页面点击ok
2. 加载驱动
try {
Class.forName("com.mysql.cj.jdbc.Driver");
}catch (Exception e){
e.printStackTrace();
}
3. 获取链接对象
Connection connection=DriverManager.getConnection(url,user,password);
4. 获取执行sql语句的对象:
Statement statement=connection.createStatement();
5. 执行sql语句
int row=statement.executeUpdate(sql);
ResultSet resultSet=statement.executeQuery(sql); //遍历结果集
6. 关闭资源
finally {
try {
if (resultSet != null){
resultSet.close();
}
if (ps != null){
ps.close();
}
if (connection != null){
connection.close();
}
} catch (Exception throwables) {
throwables.printStackTrace();
}
}
参考代码
public static void main(String[] args) {
ResultSet resultSet = null;
//Statement statement = null;已废弃,会有sql注入问题
PreparedStatement ps = null;//通过占位符防止sql注入
Connection connection = null;
try {
Class.forName("com.mysql.cj.jdbc.Driver");//加载驱动类
connection = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/dbname?serverTimezone=Asia/Shanghai",
"root", "root");
/*connection = DriverManager.getConnection(
"jdbc:mysql://ip地址:3306/数据库名?serverTimezone=Asia/Shanghai上海市区",
"用户名:root", "密码:root");
*/
//创建sql对象
ps = connection.createStatement();
//sql语句
String sql = "select * from tb_user";
//把从数据库中查询的结果封装到ResultSet容器中了
resultSet = ps.executeQuery(sql);
//遍历结果集
while (resultSet.next()) {//判断是否容器中有记录
System.out.println(resultSet.getInt("uid") + "\t" + resultSet.getString("uname"));
}
} catch (Exception e) {//抛出异常
e.printStackTrace();
} finally {
try {//关闭结果集
if (resultSet != null) {
resultSet.close();
}
if (ps != null) {
ps.close();
}
if (connection != null) {
connection.close();
}
}catch (Exception e){
e.printStackTrace();
}
}
}
```