每日日报2021.5.14

今天完成内容：

学习web 连接数据库 完成查询项目

package bean;

public class User {
private String dp;
private String ap;
private String ndate;
private String dtime;
private String atime;
private String dname;
private String aname;
private String flightname;
private String flightspace;
private String rate;
private String price;

public String getDp() {
return dp;
}

public void setDp(String dp) {
this.dp = dp;
}

public String getAp() {
return ap;
}

public void setAp(String ap) {
this.ap = ap;
}

public String getNdate() {
return ndate;
}

public void setNdate(String ndate) {
this.ndate = ndate;
}

public String getDtime() {
return dtime;
}

public void setDtime(String dtime) {
this.dtime = dtime;
}

public String getAtime() {
return atime;
}

public void setAtime(String atime) {
this.atime = atime;
}

public String getDname() {
return dname;
}

public void setDname(String dname) {
this.dname = dname;
}

public String getAname() {
return aname;
}

public void setAname(String aname) {
this.aname = aname;
}

public String getFlightname() {
return flightname;
}

public void setFlightname(String flightname) {
this.flightname = flightname;
}

public String getFlightspace() {
return flightspace;
}

public void setFlightspace(String flightspace) {
this.flightspace = flightspace;
}

public String getRate() {
return rate;
}

public void setRate(String rate) {
this.rate = rate;
}

public String getPrice() {
return price;
}

public void setPrice(String price) {
this.price = price;
}

public User() {
super();
// TODO Auto-generated constructor stub
}
}

package dao;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import bean.User;
import util.DBUtil;

public class UserDao {

public ArrayList<User> search(String dp,String ap,String ndate) {
ArrayList<User> list=new ArrayList<>();
Connection con=null;
Statement state=null;
ResultSet rs=null;
try {
con=DBUtil.getConn();
String sql="select * from line where dp='"+dp+"'"+"and ap='"+ ap +"'"+"and ndate='"+ ndate +"'";
state=con.createStatement();
rs=state.executeQuery(sql);
while(rs.next())
{
User bean=new User();
bean.setDp(rs.getString("dp"));
bean.setAp(rs.getString("ap"));
bean.setNdate(rs.getString("ndate"));
bean.setDtime(rs.getString("dtime"));
bean.setAtime(rs.getString("atime"));
bean.setDname(rs.getString("dname"));
bean.setAname(rs.getString("aname"));
bean.setFlightname(rs.getString("flightname"));
bean.setFlightspace(rs.getString("flightspace"));
bean.setRate(rs.getString("rate"));
bean.setPrice(rs.getString("price"));
list.add(bean);
}
} catch (SQLException e) {
e.printStackTrace();
}
DBUtil.close(rs, state, con);
return list;
}
}

看视频

遇到问题：

无

明日目标：

学习web端的开发

学习css