?? withdrawal.java
字號:
package cn.edu.ccut;
import javax.naming.Context;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.sql.DataSource;
import java.io.PrintWriter;
import java.io.IOException;
import java.sql.*;
/**
* Created by IntelliJ IDEA.
* User: hvst
* Date: 2008-8-26
* Time: 16:01:19
* To change this template use File | Settings | File Templates.
*/
public class WithDrawal extends HttpServlet {
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
String strUserId = "";
String strOperated = "";
String strOperatedMoney = "";
Double strLeftOver = 0.0;
Double nowLeftOver = 0.0;
String strSql = "";
String strSqll = "";
Context ctx = null;
DataSource ds = null;
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
PrintWriter out = null;
strUserId = (String)request.getSession().getAttribute("userId");
try {
response.setContentType("text/html;charset=gb2312");
out = response.getWriter();
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost/bank?useUnicode=true&characterEncoding=gb2312", "root", "");
stmt = conn.createStatement();
strOperatedMoney = request.getParameter("withdrawal1");
strSql = " select leftover " +
" from `slimsy`" +
" where userid='" + strUserId + "'";
rs = stmt.executeQuery(strSql);
while(rs.next()){
strLeftOver = rs.getDouble("leftover");
}
if(Double.parseDouble(strOperatedMoney) <= strLeftOver){
nowLeftOver = strLeftOver- Double.parseDouble(strOperatedMoney);
strSqll = " update `slimsy` " +
" set leftover='" + nowLeftOver + "'" +
" where userid='" + strUserId + "'";
stmt.executeUpdate(strSqll);
String strSqlv="";
strSqlv = " insert into `useroperationt` (userid,operated,timed,operatedmoney)" +
" values ('" + strUserId + "','2',sysdate(),'" + strOperatedMoney + "')";
stmt.execute(strSqlv);
RequestDispatcher dispatcher = request.getRequestDispatcher("/jsp/operate.jsp");
dispatcher.forward(request,response);
} else{
out.println("<script language='javascript'>");
out.println(" alert('取款失敗!');");
out.println(" window.history.back();");
out.println("</script>");
}
} catch (Exception e) {
e.printStackTrace(); //To change body of catch statement use File | Settings | File Templates.
} finally {
try {
if (rs != null) rs.close();
if(stmt != null) stmt.close();
if(conn != null) conn.close();
} catch (SQLException e) {
e.printStackTrace(); //To change body of catch statement use File | Settings | File Templates.
}
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -