idea连接数据库

是三木呀

已于 2022-11-24 21:11:46 修改

阅读量684

点赞数

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

于 2022-11-24 20:54:10 首次发布

本文链接：https://blog.csdn.net/qq_57459645/article/details/128026624

版权

Class.forName("com.mysql.cj.jdbc.Driver");
//        2.用户信息和url
    String url = "jdbc:mysql://localhost:3306/test1?useUnicode=true&characterEncoding=utf8&useSSL=true";
    String username="test";
    String password="123456";
//        3.连接成功，数据库对象 Connection
    Connection connection = DriverManager.getConnection(url,username,password);
//        4.执行SQL对象Statement，执行SQL的对象
    Statement statement = connection.createStatement();
//        5.执行SQL的对象去执行SQL，返回结果集
    String sql = "SELECT * FROM user;";
    ResultSet resultSet = statement.executeQuery(sql);
    while(resultSet.next()) {
      System.out.println(resultSet.getString(1));
      Order1 order1=new Order1();
      order1.setUsername(resultSet.getString(1));
      order1.setRealname(resultSet.getString(2));
      order1.setSex(resultSet.getString(3));
      order1.setUserType(resultSet.getString(4));
      order1.setPassword(resultSet.getString(5));
      list.add(order1);
    }
    System.out.println(list.toString());
//    System.out.println(list);
//    while(resultSet.next()){
//      System.out.println("SNo="+resultSet.getString("SNo"));
//      System.out.println("SName="+resultSet.getString("SName"));
//      System.out.println("Birth="+resultSet.getString("Birth"));
//      System.out.println("SPNo="+resultSet.getString("SPNo"));
//      System.out.println("Major="+resultSet.getString("Major"));
//      System.out.println("Grade="+resultSet.getString("Grade"));
//      System.out.println("SInstructor="+resultSet.getString("SInstructor"));
//      System.out.println("SPwd="+resultSet.getString("SPwd"));
//    }
//        6.释放连接
      resultSet.close();
      statement.close();
      connection.close();