。1234 2019-11-20 11:13 采纳率: 0%
浏览 1260

java连接数据库返回数据为空

package servlet;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class Demo2 {
/*
查询所有student对象
*/
public static void main(String[] args){
List list = new Demo2().findAll();
System.out.println(list);
}
public List findAll(){
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
List list = null;
try {
//注册驱动
Class.forName("com.mysql.jdbc.Driver");
//获取连接
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/kaorou","root", "root");
//定义sql
String sql = "select * from user ";
//获取执行sql的对象
stmt = conn.createStatement();
//执行sql
rs = stmt.executeQuery(sql);
//便利结果集,封装对象,装载集合
Student stu = null;
list = new ArrayList();
while(rs.next()){ //rs如果有下一个就循环,括号中的参数与数据库中的字段名一致
int id = rs.getInt("id");
String name = rs.getString("name");
int email = rs.getInt("email");
int age = rs.getInt("age");

            //创建stu对象
            stu = new Student();
            stu.getId(id);
            stu.getName(name);
            stu.getEmail(email);
            stu.getAge(age);


            //装载集合
             list.add(stu);
         }

     } catch (ClassNotFoundException | SQLException e) {
         e.printStackTrace();
     }finally { //先声明的后关
         if (rs != null) {
             try {
                 rs.close();
             } catch (SQLException e) {
                 e.printStackTrace();
             }
         }
         if (stmt != null){
             try {
                 stmt.close();
             } catch (SQLException e) {
                 e.printStackTrace();
             }
         }
         if (conn != null){
             try {
                 conn.close();
             } catch (SQLException e) {
                 e.printStackTrace();
             }
         }
     }
     return list;
 }

}

package servlet;
/*
封装student表数据
*/
public class Student {
private int id;
private String name;
private int email;
private int age;

public int getId(int id) {
    return this.id;
}

public void setId(int id) {
    this.id = id;
}

public void getName(String name) {
}

public void setName(String name) {
    this.name = name;
}

public int getEmail(int email) {
    return this.email;
}

public void setEmail(int email) {
    this.email = email;
}

public int getAge(int age) {
    return this.age;
}

public void setAge(int age) {
    this.age = age;
}


@Override
public String toString() {
    return "Student{" +
            "id=" + id +
            ", name='" + name + '\'' +
            ", sex='" + email + '\'' +
            ", age=" + age +

            '}';
}

}

控制台报错:
[Student{id=0, name='null', sex='0', age=0}, Student{id=0, name='null', sex='0', age=0}, Student{id=0, name='null', sex='0', age=0}, Student{id=0, name='null', sex='0', age=0}, Student{id=0, name='null', sex='0', age=0}]

  • 写回答

4条回答

  • 呓语的风 2019-11-20 11:23
    关注

    这不是已经查询出来了吗,有5条记录啊

    评论

报告相同问题?

悬赏问题

  • ¥15 如何在scanpy上做差异基因和通路富集?
  • ¥20 关于#硬件工程#的问题,请各位专家解答!
  • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
  • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
  • ¥30 截图中的mathematics程序转换成matlab
  • ¥15 动力学代码报错,维度不匹配
  • ¥15 Power query添加列问题
  • ¥50 Kubernetes&Fission&Eleasticsearch
  • ¥15 報錯:Person is not mapped,如何解決?
  • ¥15 c++头文件不能识别CDialog