. Java Cart . Java Cart ItemDBUtil java
Java Cart ItemDBUtil java
package cart.dbUtils;
import cart.Item;
import cart.ItemBuilder;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
//ItemDBUtil
//copyright - Lawrence Truett - FluffyCat.com
//date - June 13, 2003 - San Diego, CA
public class ItemDBUtil {
public static Item getItemForKey(long key, DBConnection dbc) {
Item itemToReturn = null;
try {
Connection connection = dbc.getConnection();
PreparedStatement preparedStatement =
connection.prepareStatement(
"Select * from item where key = ?");
preparedStatement.setLong(1, key);
ResultSet resultSet = preparedStatement.executeQuery();
resultSet.first();
itemToReturn = ItemBuilder.buildItem(dbc, resultSet);
resultSet.close();
preparedStatement.close();
} catch (java.sql.SQLException sqlException) {
System.out.println("The following error occured in "+
"ItemDBUtil.getItemForKey: " + sqlException);
}
return itemToReturn;
}
public static ArrayList getAllItems(DBConnection dbc) {
ArrayList itemsToReturn = new ArrayList();
try {
Connection connection = dbc.getConnection();
PreparedStatement preparedStatement =
connection.prepareStatement("Select * from item");
ResultSet resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
itemsToReturn.add(ItemBuilder.buildItem(dbc,
resultSet));
}
resultSet.close();
preparedStatement.close();
} catch (java.sql.SQLException sqlException) {
System.out.println("The following error occured in "+
"ItemDBUtil.getAllItems: " +
sqlException);
}
return itemsToReturn;
}
public static void insert(long key,
double price,
String description,
String type,
String shortImage,
String longImage,
Connection connection) {
try {
PreparedStatement preparedStatement =
connection.prepareStatement(
"INSERT INTO item values(?,?,?,?,?,?);");
preparedStatement.setLong(1, key);
preparedStatement.setDouble(2, price);
preparedStatement.setString(3, description);
preparedStatement.setString(4, type);
preparedStatement.setString(5, longImage);
preparedStatement.setString(6, shortImage);
preparedStatement.execute();
preparedStatement.close();
} catch (java.sql.SQLException sqlException) {
System.out.println("The following error occured in "+
"ItemDBUtil.insert: " + sqlException);
}
}
}
download source, use right-click and "Save Target As..." to save with a .java extension.
| Comments |
| Sign In |
| to add the first comment for Java Cart ItemDBUtil java. |