List l = new ArrayList();
Connection conn = null;
try {
conn = MySqlConnnection.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM Book");
String s = null;
while (rs.next()) {
s = MyEncode.ISOtoGB(rs.getString(2));
l.add( new Book (rs.getInt(1), s, rs.getString(3))) ;
}
stmt.close();
} catch (Exception ex) {
ex.printStackTrace();
} finally {
MySqlConnnection.closeConnection(conn);
}
return l.iterator();
}
public static void main(String[] args) {
}
2、DBCard
//增加会员卡
public static void addCard(Card a) {
Connection conn = null;
try {
conn = MySqlConnnection.getConnection();
PreparedStatement ps = conn
.prepareStatement("INSERT INTO Card
(CardName,CardNumber) VALUES (?,?)");
ps.setString(1, MyEncode.GBtoISO(a.getCardName()));
ps.setString(2, a.getCardNumber());
ps.executeUpdate();
ps.close();
} catch (Exception ex) {
ex.printStackTrace();
} finally {
MySqlConnnection.closeConnection(conn);
}