show_booked_line.java

一、 网站名称:旅游信息管理网站 二、 编程语言:JSP+javabean+sql2000 三、 编程运行:首先把数据库文件导入数据库中,然后把tour文件拷贝到D:Tomcat 5.5webap

package book_line;

import java.sql.*;
import java.util.*;
import java.io.*;

public class show_booked_line
{
public String user_name;

public Collection col=new ArrayList();

public Connection con;

public Collection show() throws Exception{
  
  try{
Statement statement=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from tour_line_book where user_name='"+user_name+"'";
ResultSet r=statement.executeQuery(sql);

while(r.next())
{
booked_line bl=new booked_line();
bl.setTour_line_name(r.getString(1));
bl.setUser_name(r.getString(2));
bl.setBook_time(r.getString(3));
col.add(bl);
}
}catch(SQLException ee)
{}
return col;
}

}