无法使用vscode从popsql连接到mysql数据库

Question

#用于连接jdbc的java代码

导入java。sql。*；公共类abc{

public static void main(String args[])throws Exception{

#我正在使用的驱动程序

    String url = "jdbc:mysql://localhost:3306//kushagra";

    String user="root@localhost";

    String password="kushagra";

#用popsql写的查询这是一个mysql查询

    String query = "Select student_name From students where student_id =1";

    Class.forName("com.mysql.cj.jdbc.Driver");



    Connection con =  DriverManager.getConnection(url, user, password);

    Statement st = con.createStatement();

    ResultSet rs = st.executeQuery(query);

    rs.next();

    String name = rs.getString("student_name");

    System.out.println(name);

    st.close();
    con.close();



}

}

Answer 1

用户更改为“root”

java prettyprint-override">String user="root";