amendsucc_0002ejsp_jsp.java

网上书店,JSP,MYSQL,struct,spring,hibernate

import java.sql.*;
import bookshoppingsys.*;
import java.util.Properties;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import org.apache.jasper.runtime.*;


public class AmendSucc_0002ejsp_jsp extends HttpJspBase {

    // begin [file="/common.jsp";from=(3,0);to=(3,77)]
    // end
    // begin [file="/common.jsp";from=(4,3);to=(10,0)]
        
           public String convert(String s){
            try{
             	return new String(s.getBytes("ISO-8859-1"),"GB2312");
            }catch(Exception e){return null;}
           }
    // end

    static {
    }
    public AmendSucc_0002ejsp_jsp( ) {
    }

    private static boolean _jspx_inited = false;

    public final void _jspx_init() throws org.apache.jasper.runtime.JspException {
    }

    public void _jspService(HttpServletRequest request, HttpServletResponse  response)
        throws java.io.IOException, ServletException {

        JspFactory _jspxFactory = null;
        PageContext pageContext = null;
        HttpSession session = null;
        ServletContext application = null;
        ServletConfig config = null;
        JspWriter out = null;
        Object page = this;
        String  _value = null;
        try {

            if (_jspx_inited == false) {
                synchronized (this) {
                    if (_jspx_inited == false) {
                        _jspx_init();
                        _jspx_inited = true;
                    }
                }
            }
            _jspxFactory = JspFactory.getDefaultFactory();
            response.setContentType("text/html; charset=GBK");
            pageContext = _jspxFactory.getPageContext(this, request, response,
            			"errorpage.jsp", true, 8192, true);

            application = pageContext.getServletContext();
            config = pageContext.getServletConfig();
            session = pageContext.getSession();
            out = pageContext.getOut();

            // HTML // begin [file="/AmendSucc.jsp";from=(0,48);to=(1,0)]
                out.write("\r\n");

            // end
            // HTML // begin [file="/AmendSucc.jsp";from=(1,30);to=(2,0)]
                out.write("\r\n");

            // end
            // HTML // begin [file="/common.jsp";from=(0,38);to=(1,0)]
                out.write("\r\n");

            // end
            // HTML // begin [file="/common.jsp";from=(1,37);to=(2,0)]
                out.write("\r\n");

            // end
            // HTML // begin [file="/common.jsp";from=(2,41);to=(3,0)]
                out.write("\r\n");

            // end
            // begin [file="/common.jsp";from=(3,0);to=(3,77)]
                bookshoppingsys.BookDB bookDB = null;
                boolean _jspx_specialbookDB  = false;
                 synchronized (application) {
                    bookDB= (bookshoppingsys.BookDB)
                    pageContext.getAttribute("bookDB",PageContext.APPLICATION_SCOPE);
                    if ( bookDB == null ) {
                        _jspx_specialbookDB = true;
                        try {
                            bookDB = (bookshoppingsys.BookDB) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "bookshoppingsys.BookDB");
                        } catch (ClassNotFoundException exc) {
                             throw new InstantiationException(exc.getMessage());
                        } catch (Exception exc) {
                             throw new ServletException (" Cannot create bean of class "+"bookshoppingsys.BookDB", exc);
                        }
                        pageContext.setAttribute("bookDB", bookDB, PageContext.APPLICATION_SCOPE);
                    }
                 } 
                if(_jspx_specialbookDB == true) {
            // end
            // begin [file="/common.jsp";from=(3,0);to=(3,77)]
                }
            // end
            // HTML // begin [file="/common.jsp";from=(3,77);to=(4,0)]
                out.write("\r\n");

            // end
            // HTML // begin [file="/common.jsp";from=(10,2);to=(12,0)]
                out.write("\r\n\r\n");

            // end
            // HTML // begin [file="/AmendSucc.jsp";from=(2,32);to=(5,0)]
                out.write("\r\n<html>\r\n<body>\r\n");

            // end
            // begin [file="/AmendSucc.jsp";from=(5,2);to=(70,0)]
                //onload="window.opener.reload();window.opener.focus();window.close();"
                String Updatesql="update users set realname=?,sex=?,Email=?,postcode=?,address=?,telephone=? where username=?" ;
                //String realname=new String(request.getParameter("realname").getBytes("ISO-8859-1"));
                //System.out.println(realname);
                System.out.println(convert(request.getParameter("realname")));
                System.out.println(convert(request.getParameter("sex")));
                System.out.println(request.getParameter("Email"));
                System.out.println(request.getParameter("postcode"));
                System.out.println(request.getParameter("address"));
                System.out.println(request.getParameter("telephone"));
                System.out.println(request.getParameter("username"));
                
                String tt_username=(String)session.getAttribute("t_username");
                System.out.println(tt_username);
                
                String realname=(String)session.getAttribute("realname") ;
                System.out.println(realname);
                
                String sex=(String)session.getAttribute("sex") ;
                System.out.println(sex);
                
                String Email=(String)session.getAttribute("Email");
                System.out.println(Email);
                
                String postcode=(String)session.getAttribute("postcode") ;
                System.out.println(postcode);
                
                String address=(String)session.getAttribute("address") ;
                System.out.println(address);
                
                String telephone=(String)session.getAttribute("telephone") ;
                System.out.println(telephone);
                
                try{
                	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver") ;
                	Connection con=DriverManager.getConnection("jdbc:odbc:Shopping");
                	PreparedStatement pstmt = con.prepareStatement(Updatesql);
                if(convert((String)request.getParameter("realname"))==null )
                	pstmt.setString(1,realname ) ;
                else{    pstmt.setString(1,convert((String)request.getParameter("realname"))) ;}
                
                if(convert((String)request.getParameter("sex"))==null )
                	pstmt.setString(2,sex ) ;
                else{	pstmt.setString(2,convert((String)request.getParameter("sex"))) ;}
                
                if(request.getParameter("Email")==null  )
                	pstmt.setString(3,Email ) ;
                else{	pstmt.setString(3,(String)request.getParameter("Email") ) ;}
                
                if(request.getParameter("postcode")==null )
                	pstmt.setString(4,postcode ) ;
                else{	pstmt.setString(4,(String)request.getParameter("postcode")) ;}
                
                if(convert((String)request.getParameter("address"))==null )
                	pstmt.setString(5,address) ;
                else{	pstmt.setString(5,convert((String)request.getParameter("address"))) ;}
                
                if(request.getParameter("telephone")==null )
                	pstmt.setString(6,telephone ) ;
                else{	pstmt.setString(6,(String)request.getParameter("telephone")) ;}
                	pstmt.setString(7,tt_username ) ;
                
                	pstmt.executeUpdate() ;
                	pstmt.close() ;
                
            // end
            // HTML // begin [file="/AmendSucc.jsp";from=(70,2);to=(71,0)]
                out.write("<font size=\"5\" color=\"#c00dcd\">\r\n");

            // end
            // begin [file="/AmendSucc.jsp";from=(71,2);to=(71,23)]
                out.println("修改成功！");
            // end
            // HTML // begin [file="/AmendSucc.jsp";from=(71,25);to=(73,0)]
                out.write("\r\n</font>\r\n");

            // end
            // begin [file="/AmendSucc.jsp";from=(73,2);to=(76,0)]
                
                }
                catch(Exception e){out.println("修改失败，请重新修改！");System.out.println(e.getMessage() ) ;}
            // end
            // HTML // begin [file="/AmendSucc.jsp";from=(76,2);to=(80,0)]
                out.write("\r\n<br><br>\r\n</body>\r\n</html>\r\n");

            // end

        } catch (Throwable t) {
            if (out != null && out.getBufferSize() != 0)
                out.clearBuffer();
            if (pageContext != null) pageContext.handlePageException(t);
        } finally {
            if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
        }
    }
}