JDBC连接数据库,在idea中链接数据库

最新推荐文章于 2022-10-01 14:16:16 发布

我想要德玛西亚

最新推荐文章于 2022-10-01 14:16:16 发布

阅读量385

点赞数

文章标签： intellij-idea 数据库 java

本文链接：https://blog.csdn.net/qq_57740280/article/details/124645357

版权

盖伦：阿巴阿巴阿巴阿巴

一、驱动导入

下载驱动包
https://mvnrepository.com/artifact/mysql/mysql-connector-java/8.0.29

点它下载就好了
导入到idea中去
- 将下载好的包复制到idea项目中
- 右键选中导入的包选择add as library

二、代码编写

首先你要mysql的用户名，密码，端口号，
还要知道你有哪些数据库，哪些表
那该怎么去知道？
下面我写了一段代码，别问为什么没有注解，因为idea自动给我生成的。
算是实现了
查看删除插入吧

package com.example.myweb;

import java.sql.*;

public class connect {


    static String url = "jdbc:mysql://localhost:3306/information?useUnicode=true&character=utf8&useSSL=false&serverTimezone=UTC";
    static String username = "root";
    static String password = "123456";
    static  Connection connection;

    static {
        try {
            connection = DriverManager.getConnection(url,username,password);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
   static Statement statement;

    static {
        try {
            statement = connection.createStatement();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public static void selectAll() throws  SQLException {


        String sql = "select * from student";
        System.out.printf("%-10s","name" );
        System.out.printf("%-10s","sno");
        System.out.printf("%-10s\n","password");
        ResultSet resultSet = statement.executeQuery(sql);
        while (resultSet.next()){
            System.out.printf("%-10s", resultSet.getString("name"));
            System.out.printf("%-10s", resultSet.getString("sno"));
            System.out.printf("%-10s\n",resultSet.getString("password"));
        }

        resultSet.close();

    }

    public static void delete(String sno ) throws  SQLException {


        String sql = "delete  from student where sno = "+sno;

        statement.execute(sql);

       System.out.println("删除成功");
    }
    public static void insert (String name ,String sno,String password ) throws  SQLException {

        System.out.println("213");
        String sql = "insert into student values ('"+name+"','"+sno+"','"+password+"')";
        System.out.println("213");
        statement.execute(sql);

        System.out.println("插入成功");
    }
    public static void main(String[] args) throws SQLException {

        System.out.println("连接成功");
        selectAll();
        delete("001");
        selectAll();
        insert("demacia","004","456789");
        selectAll();
        statement.close();
        connection.close();
    }
}