【Java开源代码栏目提醒】:网学会员为需要Java开源代码的朋友们搜集整理了HotelInfo.java相关资料,希望对各位网友有所帮助!
package flashRemoting.javaBeansTest;
import java.sql.*;
import java.io.Serializable;
import java.util.*;
import javax.sql.*;
public class HotelInfo
implements Serializable {
private List HotelArray;
public List GetHotelInfo(Object selectedHotel_name,
Object selectedHotel_flavor,
Object selectedHotel_location) {
List HotelArray = new ArrayList();
String sql = "select * from main WHERE Hotel_name LIKE ? OR Hotel_flavor LIKE ? OR Hotel_location LIKE ?";
Connection connection = null;
PreparedStatement stmt = null;
ResultSet rs = null;
try {
Driver theDriver = (Driver)Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
connection = DriverManager.getConnection("jdbc:odbc:restaurant","","");
stmt = connection.prepareStatement(sql);
stmt.setObject(1, selectedHotel_name);
stmt.setObject(2, selectedHotel_flavor);
stmt.setObject(3, selectedHotel_location);
rs = stmt.executeQuery();
System.out.println("对于每一个结果集创建一个哈希表,并添加到数组");
List restaurantArray = new ArrayList();
while (rs.next()) {
Map restaurant = new HashMap();
restaurant.put("hotel_level", rs.getObject("hotel_level"));
restaurant.put("hotel_name", rs.getObject("hotel_name"));
restaurant.put("hotel_flavor", rs.getObject("hotel_flavor"));
restaurant.put("hotel_location", rs.getObject("hotel_location"));
restaurant.put("hotel_phone", rs.getObject("hotel_phone"));
HotelArray.add(restaurant);
}
}
catch (Exception e) {
System.out.println(e);
}
finally {
try {
rs.close();
stmt.close();
connection.close();
}
catch (Exception e) {}
}
return HotelArray;
}
public List GetHotelInfoAll() {
List HotelArray = new ArrayList();
String sql = "select * from main";
Connection connection = null;
PreparedStatement stmt = null;
ResultSet rs = null;
//if (HotelArray!= null) {
// System.out.println("应用JavaBeans的有状态属性,如果存在HotelArray,就直接返回");
// return HotelArray;
//}
try {
Driver theDriver = (Driver)Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
connection = DriverManager.getConnection("jdbc:odbc:restaurant","","");
stmt = connection.prepareStatement(sql);
rs = stmt.executeQuery();
System.out.println("对于每一个结果集创建一个哈希表,并添加到数组");
List restaurantArray = new ArrayList();
while (rs.next()) {
Map restaurant = new HashMap();
restaurant.put("hotel_level", rs.getObject("hotel_level"));
restaurant.put("hotel_name", rs.getObject("hotel_name"));
restaurant.put("hotel_flavor", rs.getObject("hotel_flavor"));
restaurant.put("hotel_location", rs.getObject("hotel_location"));
restaurant.put("hotel_phone", rs.getObject("hotel_phone"));
HotelArray.add(restaurant);
}
}
catch (Exception e) {
System.out.println(e);
}
finally {
try {
rs.close();
stmt.close();
connection.close();
}
catch (Exception e) {}
}
return HotelArray;
}
}
上一篇:
HotelDao.java
下一篇:
中小学生社会教育市场调查综述