JDBC(操作数据库）

最新推荐文章于 2024-07-13 18:10:19 发布

lhj071408

最新推荐文章于 2024-07-13 18:10:19 发布

阅读量123

点赞数 4

文章标签：数据库

本文链接：https://blog.csdn.net/lhj071408/article/details/134815140

版权

一、JDBC概述

JDBC:java database connectity。java数据库链接
要求实现数据化持久保存。JDBC是java操作关系型数据库的一套标准规范

二、导入项目

1、创建web企业版项目，勾选web application
2、在web目录上右键选择新建文件夹，添加一个叫lib的目录
3、把mysql文件复制添加到lib之下
4、在mysql文件上右键展开他点右键点击add as library，就可以把驱动包添加到项目类库中了

三、使用JDBC完成增删改操作

//1.加载驱动
Class.forName("com.mysql.jdbc.Driver");
//2.创建一个连接对象
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/db001","root","root");
//3.创建执行sql语句的对象
Statement statement = connection.createStatement();
//4.执行增删改查命令
int i = statement.executeUpdate("delete from stuinfo where id=5");
if (i>0){
System.out.println("删除成功");
System.out.println(i);
}else {
System.out.println(i);
}
//5.关闭资源
connection.close();
statement.close();
jdbc:mysql://localhost:3306/news_db?serverTimezone=GMT%2B8&useUnicode=true&useSSL=false&characterEncoding=utf8
插入数据乱码问题把url地址更换为这个
USE db001
CREATE TABLE uinfoo(
uid VARCHAR(20) PRIMARY KEY NOT NULL,
unickname VARCHAR(20) NOT NULL,
uname VARCHAR(20) NOT NULL,
upwd VARCHAR(20)
)
SELECT DATABASE();

四、JDBC查询

package web;

import com.alibaba.fastjson.JSON;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import java.util.ArrayList;

@WebServlet("/select")
public class ArticleTest extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        ArrayList<ArticleClass> list = new ArrayList<>();
        resp.setContentType("text/html;charset=utf-8");
        resp.setCharacterEncoding("utf-8");
        ResultSet rs = null;
        Statement statement = null;
        Connection connection = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/db001?serverTimezone=GMT%2B8&useUnicode=true&useSSL=false&characterEncoding=utf8", "root", "root");
            statement = connection.createStatement();
            rs = statement.executeQuery("select * from article");
            while (rs.next()) {
                int aid = rs.getInt("aid");
                String atitle = rs.getString("atitle");
                String acontent = rs.getString("acontent");
                Date atime = rs.getDate("atime");
                ArticleClass arr1 = new ArticleClass(aid, atitle, acontent, atime);
                list.add(arr1);
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                rs.close();
                statement.close();
                connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
        //转换为JSON格式
        String sr = JSON.toJSONString(list);
        //输出对象
        PrintWriter out = resp.getWriter();
        out.write(sr);
        out.flush();
    }
}