restore.java

大型数据库课程设计源码

package servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.ListIterator;
import java.util.StringTokenizer;
import java.util.Vector;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


public class restore extends HttpServlet {

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	String[][] arr=new String[8][12];
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String usr=(String)request.getSession().getAttribute("name");
		String myacc=(String)request.getParameter("myaccount").trim();
		String pwd=(String)request.getParameter("pwd").trim();
		String gold=(String)request.getParameter("money").trim();
		String theacc=(String)request.getParameter("destaccount").trim();
		Vector<String> v=(Vector<String>)request.getAttribute("card");
		float my=new Float(gold).floatValue();
		
		String custID="";
		String sql="select * from account where accountNum='"+myacc+"' and accountkind='娲绘湡'";
		db.DBManager.getConnection();
		java.sql.ResultSet rs=db.DBManager.executeSelect(sql);
		try {
			if(!rs.next()){
				response.sendRedirect("/netservice/jsp/restoreerror.jsp");
			}
		} catch (SQLException e) {
			// TODO 鑷