?? purchase.java~2~
字號:
if (Userid==null || Userid.equals(""))
{
isLogin = false;
return false;
}else {
try
{
userid = Long.parseLong(Userid);
}
catch (NumberFormatException e)
{
return false;
}
}
purchaselist = (Vector)session.getAttribute("shopcar");
if (purchaselist==null || purchaselist.size()<0)
{
return false;
}
String Content = request.getParameter("content");
if (Content==null)
{
Content="";
}
Content = getGbk(Content);
String IP = request.getRemoteAddr();
String TotalPrice = request.getParameter("totalprice");
sqlStr = "select max(id) from My_indent";
rs = stmt.executeQuery(sqlStr);
if (rs.next())
{
IndentNo = "HYD" + userid + "" + rs.getString(1);
} else {
IndentNo = "HYD" + userid + "0";
}
rs.close();
sqlStr = "insert into My_indent (IndentNo,UserId,SubmitTime,ConsignmentTime,TotalPrice,content,IPAddress,IsPayoff,IsSales) values ('";
sqlStr = sqlStr + IndentNo + "','";
sqlStr = sqlStr + userid + "',getdate(),getdate()+7,'";
sqlStr = sqlStr + TotalPrice + "','";
sqlStr = sqlStr + strFormat.toSql(Content) + "','";
sqlStr = sqlStr + IP + "',1,1)";
try
{
stmt.execute(sqlStr);
sqlStr= "select max(id) from My_indent where UserId = " + userid;
rs = stmt.executeQuery(sqlStr);
long indentid = 0;
while (rs.next())
{
indentid = rs.getLong(1);
}
rs.close();
for (int i=0; i<purchaselist.size() ;i++ )
{
indentlist iList = (indentlist) purchaselist.elementAt(i);
int newid2 = 1;
sqlStr = "select max(id)+1 as newid from My_indentlist";
rs = stmt.executeQuery(sqlStr);
if (rs.next())
{
newid2 = rs.getInt("newid");
}
// sqlStr = "insert into My_indentlist (id,IndentNo,BookNo,Amount) values ("+newid+",";
// sqlStr = sqlStr + indentid + ",'";
// sqlStr = sqlStr + iList.getBookNo() + "','";
// sqlStr = sqlStr + iList.getAmount() + "')";
sqlStr = "insert into My_indentlist (IndentNo,BookNo,Amount) values (";
sqlStr = sqlStr + indentid + ",'";
sqlStr = sqlStr + iList.getBookNo() + "','";
sqlStr = sqlStr + iList.getAmount() + "')";
stmt.execute(sqlStr);
sqlStr = "update My_book set leav_number=leav_number - " + iList.getAmount() + " where id = " + iList.getBookNo();
stmt.execute(sqlStr);
}
return true;
}
catch (SQLException e)
{
return false;
}
}
public boolean getIndent(long userid) {
sqlStr = "select * from My_indent where userid = '" +userid+ "' order by id desc";//查詢符合查詢條件的記錄結果集按userid降序排列
try
{
rs = stmt.executeQuery(sqlStr);//執行sql查詢語句
my_indent = new Vector();
while (rs.next())
{
indent ind = new indent();
ind.setId(rs.getLong("Id"));
ind.setIndentNo(rs.getString("IndentNo"));
ind.setUserId(rs.getLong("UserId"));
ind.setSubmitTime(rs.getString("SubmitTime"));
ind.setConsignmentTime(rs.getString("ConsignmentTime"));
ind.setTotalPrice(rs.getFloat("TotalPrice"));
ind.setContent(rs.getString("content"));
ind.setIPAddress(rs.getString("IPAddress"));
if (rs.getInt("IsPayoff")==1)
ind.setIsPayoff(false);
else
ind.setIsPayoff(true);
if (rs.getInt("IsSales")==1)
ind.setIsSales(false);
else
ind.setIsSales(true);
my_indent.addElement(ind);
}
rs.close();
return true;
}
catch (SQLException e)
{
return false;
}
}
public boolean getOneIndent(long iid) {
sqlStr = "select * from My_indent where id = '" +iid+ "' order by id desc";//查詢符合查詢條件的記錄結果集按id降序排列
try
{
rs = stmt.executeQuery(sqlStr);//執行sql查詢語句
my_indent = new Vector();
while (rs.next())
{
indent ind = new indent();
ind.setId(rs.getLong("Id"));
ind.setIndentNo(rs.getString("IndentNo"));
ind.setUserId(rs.getLong("UserId"));
ind.setSubmitTime(rs.getString("SubmitTime"));
ind.setConsignmentTime(rs.getString("ConsignmentTime"));
ind.setTotalPrice(rs.getFloat("TotalPrice"));
ind.setContent(rs.getString("content"));
ind.setIPAddress(rs.getString("IPAddress"));
if (rs.getInt("IsPayoff")==1)
ind.setIsPayoff(false);
else
ind.setIsPayoff(true);
if (rs.getInt("IsSales")==1)
ind.setIsSales(false);
else
ind.setIsSales(true);
my_indent.addElement(ind);
}
rs.close();
return true;
}
catch (SQLException e)
{
return false;
}
}
public boolean getIndent() {
sqlStr = "select count(*) from My_indent"; //取出My_indent數據表中記錄數
int rscount = pageSize;//設置頁數
try
{
ResultSet rs1 = stmt.executeQuery(sqlStr);//執行sql語句
if (rs1.next()) recordCount = rs1.getInt(1);
rs1.close();
}
catch (SQLException e)
{
return false;
}
/*設定pageCount*/
if (recordCount < 1)//如果recordCount小于1
pageCount = 0;
else
pageCount = (int)(recordCount - 1) / pageSize + 1;//調整pageCount為整數
/*檢查查看的頁面數是否在范圍內*/
if (page < 1)
page = 1;
else if (page > pageCount)
page = pageCount;
rscount = (int) recordCount % pageSize; // 最后一頁記錄數
/*查詢結果集按Id 降序排列*/
sqlStr = "select * from My_indent ";
if (page == 1)
{
sqlStr = sqlStr + " order by Id desc";
}else {
sqlStr = sqlStr + " where Id not in ( select Id from My_indent order by Id ) and Id in " +
"(select Id from My_indent order by Id ) " + " order by Id desc";
}
try
{
rs = stmt.executeQuery(sqlStr);
my_indent = new Vector();
while (rs.next())
{
indent ind = new indent();
ind.setId(rs.getLong("Id"));
ind.setIndentNo(rs.getString("IndentNo"));
ind.setUserId(rs.getLong("UserId"));
ind.setSubmitTime(rs.getString("SubmitTime"));
ind.setConsignmentTime(rs.getString("ConsignmentTime"));
ind.setTotalPrice(rs.getFloat("TotalPrice"));
ind.setContent(rs.getString("content"));
ind.setIPAddress(rs.getString("IPAddress"));
if (rs.getInt("IsPayoff")==1)
ind.setIsPayoff(false);
else
ind.setIsPayoff(true);
if (rs.getInt("IsSales")==1)
ind.setIsSales(false);
else
ind.setIsSales(true);
my_indent.addElement(ind);
}
rs.close();
return true;
}
catch (SQLException e)
{
System.out.println(e);
return false;
}
}
public boolean getIndentList(long nid) {
sqlStr = "select * from my_indentlist where IndentNo = '" + nid + "'";
try
{
rs = stmt.executeQuery(sqlStr);
indent_list = new Vector();
while (rs.next())
{
indentlist identlist = new indentlist();
identlist.setId(rs.getLong("Id"));
identlist.setIndentNo(rs.getLong("IndentNo"));
identlist.setBookNo(rs.getLong("BookNo"));
identlist.setAmount(rs.getInt("Amount"));
indent_list.addElement(identlist);
}
rs.close();
return true;
}
catch (SQLException e)
{
return false;
}
}
public boolean update(HttpServletRequest res) {
request = res;
int payoff = 1;
int sales = 1;
long indentid =0;
try
{
payoff = Integer.parseInt(request.getParameter("payoff"));//獲取payoff參數并轉換格式
sales = Integer.parseInt(request.getParameter("sales"));
indentid = Long.parseLong(request.getParameter("indentid"));
sqlStr = "update My_indent set IsPayoff = '" + payoff + "',IsSales='"+ sales +"' where id =" + indentid;//更新IsPayoff、IsSales兩個字段
stmt.execute(sqlStr);//執行sql語句
return true;
}
catch (Exception e)
{
return false;
}
}
public boolean delete(long id) {
try
{
sqlStr = "delete from My_indentlist where indentNo =" + id;// 刪除My_indentlist數據表中的記錄
stmt.execute(sqlStr);
sqlStr = "delete from My_indent where id= " + id ;// 刪除My_indent數據表中的記錄
stmt.execute(sqlStr);//執行sql語句
return true;
}
catch (SQLException e)
{
return false;
}
}
};
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -