展开全部
select * from teacher where DATE_FORMAT(NOW(),'%Y') - DATE_FORMAT(birthday,'%Y') = key
这里的62616964757a686964616fe59b9ee7ad9431333335303466key要int类型
其中birthday是数据库表中datetime类型的字段
key表示年龄例如2013年x月x日出生的 那么key就是1
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
Connection conn = getdb.getc();
String ageStr = request.getParameter("age");
int age = Integer.parseInt(ageStr);
ServletContext context = getServletContext();
ArrayList list = null;
ResultSet rs = null;
String Sql ="select * from tea where DATE_FORMAT(NOW(),'%Y') - DATE_FORMAT(birth,'%Y') = ?";
try {
PreparedStatement ps = conn.prepareStatement(Sql);
ps.setInt(1, age);
rs = ps.executeQuery();
list = new ArrayList();
while(rs.next()){
tea t = new tea();
t.setId(rs.getInt("id"));
t.setName(rs.getString("name"));
t.setDate(rs.getDate("birth"));
System.out.println(rs.getInt("id") + " "+rs.getString("name") + " "+rs.getDate("birth"));
list.add(t);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
in