📄 slimsy.java

📁 网上银行管理系统
💻 JAVA
字号:
package cn.edu.ccut;

import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
import java.io.PrintWriter;

import java.util.Date;

/**
 * Created by IntelliJ IDEA.
 * User: hvst
 * Date: 2008-8-26
 * Time: 15:01:19
 * To change this template use File | Settings | File Templates.
 */
public class Slimsy extends HttpServlet {

    public void doGet(HttpServletRequest request, HttpServletResponse response) {

        String strSql = "";
        String strSqll = "";

        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        PrintWriter out = null;
        String 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();

            strSql = " select userid,operated,timed,operatedmoney " +
                    " from `useroperationt`" +
                    " where userid='" + strUserID + "'";
            rs = stmt.executeQuery(strSql);

            out.println("<html>                                                                   ");
            out.println("  <head><title>你的余额</title></head>                                    ");
            out.println(" <body>                                                                  ");
            out.println("     <fieldset>                                                          ");
            out.println("       <legend><font size='6'>Wecome To Chuan Jin</font></legend>        ");
            out.println("         <form action='../slimsy' method='post'>                         ");
            out.println("             <table cellpadding='3' align='center'>                      ");
            out.println("                 <tr>                                                    ");
            out.println("                    <td colspan='4'><strong>您的操作明细是：</Strong></td>");
            out.println("                 </tr>                                                   ");
            out.println("                 <tr>                                                    ");
            out.println("                     <td>用户帐号</td>                                    ");
            out.println("                     <td>操作类型</td>                                    ");
            out.println("                     <td>操作时间</td>                                    ");
            out.println("                     <td>操作金额</td>                                    ");
            out.println("                 </tr>                                                   ");


            while (rs.next()) {

                String strUserId = rs.getString("userid");
                String strOpeated = rs.getString("operated");
                RecordsVO recordsVO = new RecordsVO();
                recordsVO.setDate(rs.getString("timed"));
                String strTimed = recordsVO.getDate().toString();
                String strOperatedM = rs.getString("operatedmoney");
                out.println("                  <tr>                                                   ");
                out.println("                   <td>" + strUserId + "</td>         ");

                if(strOpeated.equals("1")){
                    out.println("                   <td>" + "存款" + "</td>         ");
                }else if(strOpeated.equals("2")){
                    out.println("                   <td>" + "取款" + "</td>         ");
                }else{
                    out.println("                   <td>" + "注册帐号" + "</td>      ");
                }

                out.println("                   <td>" + strTimed + "</td>   ");
                out.println("                   <td>" + strOperatedM + "元</td>          ");
                out.println("                 </tr>                                               ");
            }

            out.println("                 <tr>                                                    ");
            out.println("                 <td></td>                                               ");
            out.println("                 <td></td>                                               ");
            out.println("                 <td></td>                                               ");
            out.println("                 <td align='right'><input type='button' value='返回' onClick='history.back();'></td></tr>");
            out.println("               </tr>                                                     ");
            out.println("             </table>                                                    ");
            out.println("         </form>                                                         ");
            out.println("     </fieldset>                                                         ");
            out.println("</body>                                                                  ");
            out.println("</html>                                                                  ");

        } 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 + -