Java 链接数据库postgres操作

1、确保安装了数据库
2、maven库中下载数据库链接驱动，每个数据库不一样
3、编写代码

package com.yk.test;

import java.awt.dnd.DragGestureEvent;
import java.sql.*;

public class Longin {
    public static void main(String[] args) {
        Connection connection=null;
        try {
            String url="jdbc:postgresql://127.0.0.1:5432/postgres";
            String user="postgres";
            String password="123456";
            Class.forName("org.postgresql.Driver");
            connection= DriverManager.getConnection(url,user,password);

            String user1="yankai";
            String pass="123456";
            String sql="select * from t_user where username=? and password=?";
            PreparedStatement preparedStatement=connection.prepareStatement(sql);
            preparedStatement.setString(1,user1);
            preparedStatement.setString(2,pass);
            ResultSet resultSet= preparedStatement.executeQuery();
//            System.out.println( sql);
//            Statement statement=connection.createStatement();
//            ResultSet resultSet=statement.executeQuery(sql);
            if(resultSet.next()){
                System.out.println("用户登录成功");
            }else{
                System.out.println("用户名或者密码错误");
            }
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }

    }
}