jsp如何接收以及显示list?
来源:互联网 发布:手机系统加速软件 编辑:程序博客网 时间:2024/06/03 19:59
我写了一个ticket.java里面有个方法给出发地、目的地、出发时间、然后找到这些ticket对象赋给list,但我不知道jsp这边如何接收和显示,同时也不确定该list方法是否对,请各位大大解答,我的环境是myeclipse8.5,tomcat7,jdk1.7,sql2000下面是ticket.java代码
package Train;
import java.util.ArrayList;
import java.util.List;
import java.sql.*;
public class ticket {
public String tikets_no;
public String train_no;
public String train_from;
public String train_to;
public String train_time;
public String train_to_time;
public float train_price;
public String seat_typle;
public String seat_no;
public int tikets_all_num;
public int tikets_lift_num;
public List<ticket> select_tiket_train_from_to(String train_from,String train_to,String train_time) {
List<ticket> ticketList = new ArrayList<ticket>();
Connection ct=null;
ResultSet rs=null;
PreparedStatement ps=null;
// ticket[] zt = new ticket[10];
int i = 0;
boolean state = true;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动
ct=DriverManager.getConnection("jdbc:odbc:zz");//进行连接数据库
ps=ct.prepareStatement("select * from tiket_info where train_from = ? and train_to = ?");//可以给?号赋值 查询
ps.setString(1, train_from);
ps.setString(2, train_to);
rs=ps.executeQuery();
// ticket[] tmp = new ticket[20];
while(rs.next()){
ticket Ticket=new ticket();
Ticket.tikets_no=rs.getString(1);
Ticket.train_no=rs.getString(2);
Ticket.train_from=rs.getString(3);
Ticket.train_to=rs.getString(4);
Ticket.train_time=rs.getString(5);
Ticket.train_to_time=rs.getString(6);
Ticket.train_price=rs.getFloat(7);
Ticket.seat_typle=rs.getString(8);
Ticket.seat_no=rs.getString(9);
Ticket.tikets_all_num=rs.getInt(10);
Ticket.tikets_lift_num=rs.getInt(11);
ticketList.add(Ticket);
// tmp[i] = new ticket(rs.getString(1), rs.getString(2), rs.getString(3),
// rs.getString(4), rs.getString(5), rs.getString(6), rs.getFloat(7),
// rs.getString(8), rs.getString(9), rs.getInt(10),rs.getInt(11));
String zz = Ticket.train_time;
if(zz.substring(0, 10).equalsIgnoreCase(train_time))
{
i++;
}
}
// if (i != 0)
// {
// zt = new ticket[i];
// i = 0;
// while(i < zt.length){
// zt[i] = tmp[i];
// i++;
// }
// }
}
catch(Exception e){
e.printStackTrace();
state = false;
}finally{
try{
if(rs!=null)
{
rs.close();
}
if(ps!=null)
{
ps.close();
}
if(ct!=null)
{
ct.close();
}
}catch(SQLException e){
e.printStackTrace();
state = false;
}
}
if (state && i != 0)
return ticketList;
else
return null;
}
1
package Train;
import java.util.ArrayList;
import java.util.List;
import java.sql.*;
public class ticket {
public String tikets_no;
public String train_no;
public String train_from;
public String train_to;
public String train_time;
public String train_to_time;
public float train_price;
public String seat_typle;
public String seat_no;
public int tikets_all_num;
public int tikets_lift_num;
public List<ticket> select_tiket_train_from_to(String train_from,String train_to,String train_time) {
List<ticket> ticketList = new ArrayList<ticket>();
Connection ct=null;
ResultSet rs=null;
PreparedStatement ps=null;
// ticket[] zt = new ticket[10];
int i = 0;
boolean state = true;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动
ct=DriverManager.getConnection("jdbc:odbc:zz");//进行连接数据库
ps=ct.prepareStatement("select * from tiket_info where train_from = ? and train_to = ?");//可以给?号赋值 查询
ps.setString(1, train_from);
ps.setString(2, train_to);
rs=ps.executeQuery();
// ticket[] tmp = new ticket[20];
while(rs.next()){
ticket Ticket=new ticket();
Ticket.tikets_no=rs.getString(1);
Ticket.train_no=rs.getString(2);
Ticket.train_from=rs.getString(3);
Ticket.train_to=rs.getString(4);
Ticket.train_time=rs.getString(5);
Ticket.train_to_time=rs.getString(6);
Ticket.train_price=rs.getFloat(7);
Ticket.seat_typle=rs.getString(8);
Ticket.seat_no=rs.getString(9);
Ticket.tikets_all_num=rs.getInt(10);
Ticket.tikets_lift_num=rs.getInt(11);
ticketList.add(Ticket);
// tmp[i] = new ticket(rs.getString(1), rs.getString(2), rs.getString(3),
// rs.getString(4), rs.getString(5), rs.getString(6), rs.getFloat(7),
// rs.getString(8), rs.getString(9), rs.getInt(10),rs.getInt(11));
String zz = Ticket.train_time;
if(zz.substring(0, 10).equalsIgnoreCase(train_time))
{
i++;
}
}
// if (i != 0)
// {
// zt = new ticket[i];
// i = 0;
// while(i < zt.length){
// zt[i] = tmp[i];
// i++;
// }
// }
}
catch(Exception e){
e.printStackTrace();
state = false;
}finally{
try{
if(rs!=null)
{
rs.close();
}
if(ps!=null)
{
ps.close();
}
if(ct!=null)
{
ct.close();
}
}catch(SQLException e){
e.printStackTrace();
state = false;
}
}
if (state && i != 0)
return ticketList;
else
return null;
}
- jsp如何接收以及显示list?
- jsp中显示list 以及 c:forEach标签的使用
- jsp中显示list 以及 c:forEach标签的使用
- JSP中遍历显示从Action中接收到的list
- jsp显示list长度
- JSP本页查询显示,以及如何拼接SQL语句
- JSP中如何 循环显示 数据库中的数据到list.jsp页面 (转载)
- JSP中如何 循环显示 数据库中的数据到list.jsp页面 (转载)
- spring mvc接收List集合、JUI传JSP List
- {jsp 循环显示list内容}
- jsp显示request里面list
- {jsp 循环显示list内容}
- jsp中显示list长度
- 如何将Action中的Hibernate查询结果LIST输出在控制台以及JSP界面
- jsp/js中如何添加调试信息以及如何显示出来
- action中的list在JSP页面如何显示问题的总结
- action中的list在JSP页面如何显示问题的总结补30号的
- url传参数到jsp页面,jsp页面如何接收?
- java的定时器使用方法 .
- C++的RAII在WebKit中的应用
- HDFS: c/c++接口 libhdfs
- __declspec(dllimport)的作用
- SIFT算法学习
- jsp如何接收以及显示list?
- 栈应用——表达式求值
- IOS项目中AppDelegate详解
- SSL交互(握手)过程详解
- JAVAEE基础知识点
- SSH+mysql整合乱码问题
- NIOS II学习之路——关于Reset Vector和Exception Vector的解释
- JS如何读取二进制文件?
- C++-->MFC