all_words.java

jsp实现的旅游网站 可以实现用户注册 线路查询 管理 等功能

package message_board;

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

public class all_words
{

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 board_info";
ResultSet r=statement.executeQuery(sql);

while(r.next())
{
board b=new board();
b.setBoard_title(r.getString(1));
b.setBoard_context(r.getString(2));
b.setBoard_name(r.getString(3));
b.setBoard_time(r.getString(4));
b.setResponse_context(r.getString(5));
b.setResponse_time(r.getString(6));
col.add(b);
}
}catch(SQLException ee)
{}
return col;
}

}