?? slimsy.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 + -