大佬们帮我看看121行代码,说是空结果集。我想把数据库表中time的数据拿出来存起来然后与系统时间进行比较(time数据类型已经改成char)。
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<%@page import="java.util.ArrayList" %>
<%@page import="com.plane.*" %>
<%@page import="java.text.SimpleDateFormat"%>
<%@page import="java.util.Date" %>
航班动态
<% request.setCharacterEncoding("UTF-8"); String pno=request.getParameter("pno"); String url = "jdbc:mysql://localhost:3306/scms?"+ "useSSL=false&serverTimezone=CST&characterEncoding=utf-8"; //连接串 String user="root"; String password="2001511ty"; Class.forName("com.mysql.cj.jdbc.Driver"); //加载驱动 Connection conn=DriverManager.getConnection(url,user,password); //创建与数据库的连接 Statement stmt=conn.createStatement(); //执行sql语句 String sql="SELECT * FROM plane WHERE pno='"+pno+"'"; ResultSet rs=stmt.executeQuery(sql); /*SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");//设置日期格式 Date date = new Date(); String string = df.format(date); Date Time1 = df.parse(string); Date Time2=df.parse(rs.getString("time")); int i = Time1.compareTo(Time2); String a; if(i<0){ a="pass"; } else{ a="wait"; }*/ java.util.Date date = new java.util.Date(); java.text.SimpleDateFormat dateFormat = new java.text.SimpleDateFormat("yyyy-MM-dd hh:mm:ss"); String currentdata = dateFormat.format(date); java.util.Date currenttime = dateFormat.parse(currentdata); String time2=rs.getString("time"); java.util.Date time = dateFormat.parse("time2"); String status; if(currenttime.before(time)){ status="未起飞"; } else{ status="已起飞"; } while(rs.next()) { %> <%}
%>
航班号 | 起飞城市 | 到达城市 | 起飞时间 | 舱位类型 | 航班动态 |
---|---|---|---|---|---|
<%=rs.getString("pno")%> | <%=rs.getString("city")%> | <%=rs.getString("city2")%> | <%=rs.getString("time")%> | <%=rs.getString("leixing")%> | <%=status%> |