gpt4 book ai didi

java - Selenium 与 postgreSQL

转载 作者:行者123 更新时间:2023-11-29 14:17:38 25 4
gpt4 key购买 nike

<分区>

我正在尝试将 Selenium 与 Postgres 连接,但显示以下错误:

FAILED: selectQuery org.postgresql.util.PSQLException: ERROR: relation "login" does not exist

我的代码如下:

package Posgress;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import org.testng.annotations.Test;

@Test public class PosgressTest {
public static void selectQuery() throws SQLException, ClassNotFoundException {
//Load MySQL JDBC Driver
Class.forName("org.postgresql.Driver");
Connection connection =
DriverManager
.getConnection("jdbc:postgresql://localhost:5432/DIC","postgres", "root");

Statement st = connection.createStatement();
System.out.println("Connection");
String selectquery = "Select * from Login";
System.out.println("Connection1");

// Executing the SQL Query and store the results in ResultSet
ResultSet rs = st.executeQuery(selectquery);

// While loop to iterate through all data and print results
while (rs.next()) {
System.out.println(rs.getString("username"));
System.out.println(rs.getString("password"));
}

// Closing DB Connection
connection.close();
}
}

我有一个表'Login inside schema'DICschema'。我也写了这样的选择查询“Select * from DICschema.Login”然​​后也是同样的错误

enter image description here

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com