package tour_lines;

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

public class line_intro
{
public String tour_line_name;
public Collection col=new ArrayList();
public Connection con;
public Collection intro() throws Exception{
  
  try{
Statement statement=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from tour_line_info where tour_line_name='"+tour_line_name+"'";
ResultSet r=statement.executeQuery(sql);

while(r.next())
{
line li=new line();
li.setTour_line_name(r.getString(1));
li.setTour_line_intro(r.getString(2));
li.setHot_tour_line(r.getString(4));
col.add(li);
}
}catch(SQLException ee)
{}
return col;
}

}