bulletin_intro.java

是用jsp开发的旅游管理网站

package bull;

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

public class bulletin_intro
{
public String bulletin_title;

public Collection col=new ArrayList();

public Connection con;

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

while(r.next())
{
bulletin bul=new bulletin();
bul.setBulletin_title(r.getString(1));
bul.setBulletin_context(r.getString(2));
bul.setBulletin_time(r.getString(3));
col.add(bul);
}
}catch(SQLException ee)
{}
return col;
}
}