?? customeroperation.java
字號:
preparedStatement.setString(8, useBean.getUserAdds());
preparedStatement.setInt(9, useBean.getUserCode());
preparedStatement.setString(10, useBean.getUserWork());
preparedStatement.setString(11, useBean.getUserCard());
preparedStatement.setInt(12, useBean.getUserAge());
preparedStatement.setInt(13, useBean.getUserId());
// 執行更新操作
int flag = preparedStatement.executeUpdate();
if (flag == 0) {
bool = false;
}
} catch (SQLException ex) {
ex.printStackTrace();
bool = false;
}
return bool;
}
/**
* 判斷特定用戶是否已經存在
*
* @param userName
* @return
*/
public boolean hasUser(String userName) {
boolean bool = true;
// 查詢特定用戶數量的SQL語句
String sql = "select count(*) from users where userName=?";
try {
// 創建Statement對象
preparedStatement = connection.prepareStatement(sql);
// 設置Statement對象的相關參數
preparedStatement.setString(1, userName);
// 執行查詢
resultSet = preparedStatement.executeQuery();
resultSet.next();
int flag = resultSet.getInt(1);
if (flag > 0) {
bool = true;
} else {
bool = false;
}
} catch (SQLException ex) {
ex.printStackTrace();
bool = true;
}
return bool;
}
/**
* 根據bookID取得相應的圖書信息
*
* @param bookId
* @return
*/
public BookBean getBookBean(String bookId) {
BookBean bbean = new BookBean();
// 查詢圖書信息的SQL語句
String sql = "select * from information where BookId=?";
try {
// 創建Statement對象
preparedStatement = connection.prepareStatement(sql);
// 設置Statement對象相應的參數
preparedStatement.setString(1, bookId);
// 執行查詢操作
resultSet = preparedStatement.executeQuery();
while (resultSet.next()) {
bbean.setBookCompany(resultSet.getString("BookCompany"));
bbean.setBookCount(1);
bbean.setBookData(resultSet.getDate("BookDate"));
bbean.setBookId(Integer.parseInt(bookId));
bbean.setBookImage(resultSet.getString("BookImage"));
bbean.setBookName(resultSet.getString("BookName"));
bbean.setBookPenster(resultSet.getString("BookPenster"));
bbean.setBookPrice(resultSet.getInt("BookPrice"));
bbean.setBookSell(resultSet.getInt("BookSell"));
bbean.setBookStep(resultSet.getInt("BookStep"));
bbean.setBookStorage(resultSet.getInt("BookStorage"));
bbean.setBookSynopsis(resultSet.getString("BookSynopsis"));
bbean.setBookType(this.queryType(""
+ resultSet.getInt("BookType")));
bbean.setBookAllPrice(bbean.getBookPrice());
}
} catch (SQLException ex) {
ex.printStackTrace();
return null;
}
return bbean;
}
/**
* 查詢等級信息
*
* @param typeId
* @return
*/
public String queryType(String typeId) {
try {
// 創建Statement對象，從Type表中查詢等級屬性
java.sql.PreparedStatement prepar1 = connection
.prepareStatement("select Display from Type where TypeId=?");
// 設置Statement對象的相應參數
prepar1.setInt(1, Integer.parseInt(typeId));
// 執行查詢
ResultSet res1 = prepar1.executeQuery();
res1.next();
return res1.getString("Display");
} catch (SQLException ex) {
return null;
}
}
public int getPageCount(int page, int bookNum, int bookType, int bookStep) {
int count = 0;
try {
callableStatement = connection
.prepareCall("{call proc_page (?,?,?,?,?)}");
callableStatement.setInt(1, page);
callableStatement.setInt(2, bookNum);
callableStatement.setInt(3, bookType);
callableStatement.setInt(4, bookStep);
callableStatement.registerOutParameter(5, Types.INTEGER);
callableStatement.execute();
count = callableStatement.getInt(5);
} catch (SQLException ex) {
ex.printStackTrace();
}
return count;
}
public ArrayList getPageData(int page, int bookNum, int bookType,
int bookStep) // 取出分頁的記錄
{
ArrayList bookList = new ArrayList(); // 返回的分頁的List數據
System.out.println(bookNum + " ");
// 需要填充的bookBean book的信息
try {
callableStatement = connection
.prepareCall("{call proc_page(?,?,?,?,?)}"); // 存儲過程 分頁
// proc_page(?,?,?,?)
callableStatement.setInt(1, page); // 參數1 第幾頁
callableStatement.setInt(2, bookNum); // 參數2 多少個結果
callableStatement.setInt(3, bookType); // 參數3 書的類型
callableStatement.setInt(4, bookStep);
callableStatement.registerOutParameter(5, Types.INTEGER); // OUTPUT參數
// 返回結構共多少頁
resultSet = callableStatement.executeQuery(); // 接收存儲過程的結果集
while (resultSet.next()) // 提取結果集的每條記錄(主要問題在這里!!!!!!)
{
BookBean bbean = new BookBean();
bbean.setBookName(resultSet.getString("bookName"));
bbean.setBookId(resultSet.getInt("BookId"));
bbean.setBookPenster(resultSet.getString("BookPenster"));
bbean.setBookCompany(resultSet.getString("BookCompany"));
bbean.setBookData(resultSet.getDate("BookDate"));
bbean.setBookImage(resultSet.getString("BookImage"));
bbean.setBookPrice(resultSet.getInt("BookPrice"));
bbean.setBookSell(resultSet.getInt("BookSell"));
bbean.setBookStep(resultSet.getInt("BookStep"));
bbean.setBookStorage(resultSet.getInt("BookStorage"));
bbean.setBookSynopsis(resultSet.getString("BookSynopsis"));
bbean.setBookType(queryType("" + resultSet.getInt("BookType")));
/* */
bookList.add(bbean); // 加入到booklist
}
} catch (SQLException ex) {
ex.printStackTrace();
}
return bookList;
}
public int getSearchCountPage() {
return this.pagecount;
}
public int getSearchCountdata() {
return this.pagedata;
}
public ArrayList getSearchPage(int page, int bookNum, String action,
String searchkey, String stepid, String typeid) {
ArrayList bookList = new ArrayList();
try {
callableStatement = connection
.prepareCall("{call proc_searchpage(?,?,?,?,?,?,?,?)}");
callableStatement.setInt(1, page); // 參數1 第幾頁
callableStatement.setInt(2, bookNum); // 參數2 多少個結果
callableStatement.setInt(3, Integer.parseInt(typeid)); // 參數3 書的類型
callableStatement.setInt(4, Integer.parseInt(stepid));
callableStatement.setString(5, searchkey);
callableStatement.setString(6, action);
callableStatement.registerOutParameter(7, Types.INTEGER); // OUTPUT參數
// 返回結構共多少頁
callableStatement.registerOutParameter(8, Types.INTEGER);
resultSet = callableStatement.executeQuery(); // 接收存儲過程的結果集
while (resultSet.next()) // 提取結果集的每條記錄(主要問題在這里!!!!!!)
{
BookBean bbean = new BookBean();
bbean.setBookId(resultSet.getInt("BookId"));
bbean.setBookName(resultSet.getString("BookName"));
bbean.setBookPenster(resultSet.getString("BookPenster"));
bbean.setBookCompany(resultSet.getString("BookCompany"));
bbean.setBookData(resultSet.getDate("BookDate"));
bbean.setBookImage(resultSet.getString("BookImage"));
bbean.setBookPrice(resultSet.getInt("BookPrice"));
bbean.setBookSell(resultSet.getInt("BookSell"));
bbean.setBookStep(resultSet.getInt("BookStep"));
bbean.setBookStorage(resultSet.getInt("BookStorage"));
bbean.setBookSynopsis(resultSet.getString("BookSynopsis"));
bbean.setBookType(queryType("" + resultSet.getInt("BookType")));
/* */
bookList.add(bbean); // 加入到booklist
}
pagecount = callableStatement.getInt(7);
pagedata = callableStatement.getInt(8);
} catch (SQLException ex) {
ex.printStackTrace();
}
return bookList;
}
public String getDate() {
SimpleDateFormat lFormat;
Calendar MyDate = Calendar.getInstance();
MyDate.setTime(new java.util.Date());
java.util.Date date = MyDate.getTime();
// 格式可以自己根據需要修改
lFormat = new SimpleDateFormat("yyyyMMddHHmmss");
String gRtnStr = lFormat.format(date);
return gRtnStr;
}
/**
* 插入定單信息
*
* @param ofb
* @return
*/
public boolean insertOrder(OrderFormBean ofb) {
int flag = 0;
try {
// 創建Statement對象，向OrderForm表中插入一條新記錄
preparedStatement = connection
.prepareStatement("insert into OrderForm(UserId,BookId,amount,OrderData,money) values(?,?,?,?,?)");
// 設置其相應的參數
preparedStatement.setInt(1, ofb.getUserId());
preparedStatement.setInt(2, ofb.getBookId());
preparedStatement.setInt(3, ofb.getAmount());
preparedStatement.setString(4, ofb.getOrderData());
preparedStatement.setInt(5, ofb.getMoney());
// 執行更新
flag = preparedStatement.executeUpdate();
} catch (SQLException ex) {
ex.printStackTrace();
}
if (flag > 0) {
return true;
} else {
return false;
}
}
/**
* 關閉與數據庫的連接
*/
public void Close() {
try {
if (resultSet != null) {
// 關閉ResultSet
resultSet.close();
}
if (preparedStatement != null) {
// 關閉Statement對象
preparedStatement.close();
}
if (connection != null) {
// 關閉Connection對象
connection.close();
}
} catch (SQLException ex) {
ex.printStackTrace();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -