JDBC里写MySQL查询，没有反应

Question

JDBC里写MySQL查询，没有反应

MySQL语句 select * from environment where name = '温度' or name = '湿度';在Navicat里面可以查出结果
但是在eclipse 里无法运行，是为什么呢？

package com.briup.Demo;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Timestamp;

import com.mysql.jdbc.Statement;

public class Test {
    //本环境是MySQL5驱动->MySQL5的数据库
    public static void main(String[] args) throws Exception {
        // JDBC6大步骤   java语言连接数据库
        // 1.注册驱动
        Class.forName("com.mysql.jdbc.Driver");
        // 2.获取连接  如果是本机地址 jdbc:mysql://localhost:3306/env
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/env", "root", "xz19911005");
        //System.out.println(conn);
        // 3.获取会话执行器
        String sql="select *  from environment where name=? or name=?";
        PreparedStatement ps = conn.prepareStatement(sql);
        ps.setObject(1, "温度");
        ps.setObject(2, "湿度");
        // 4.准备SQL 并执行
        ResultSet rs = ps.executeQuery();
        // 5.如果有结果,处理结果集
        while(rs.next()) {
            String name = rs.getString("name");
            String src_id = rs.getString("src_id");
            String des_id = rs.getString("des_id");
            String dev_id = rs.getString("dev_id");
            String sersor_address = rs.getString("sersor_address");
            int count = rs.getInt("count");
            String cmd = rs.getString("cmd");
            float data = rs.getFloat("data");
            int status = rs.getInt("status");
            Timestamp gather_date = rs.getTimestamp("gather_date");
            System.out.println(name + " " + src_id + " " + des_id 
                    + " " + dev_id + " " +sersor_address+ " " +count
                    + " " +cmd + " " + data  + " " + status+ " " +gather_date);
        }
        // 6.关闭物理资源
        rs.close();
        ps.close();
        conn.close();
    }
}

Answer 1

返回的结果集为空，ps.setString试试