问题描述
<body><%!request.setCharacterEncoding("utf-8");Stringuser=request.getParameter("user").trim();Stringpwd=request.getParameter("pwd").trim();Stringname=request.getParameter("name").trim();Stringpho=request.getParameter("pho").trim();Stringsex=request.getParameter("sex").trim();out.println("您的账号:");out.println(user+"<br>");out.println("您的密码:");out.println(pwd+"<br>");out.println("您的姓名:");out.println(name+"<br>");out.println("您的手机号:");out.println(pho+"<br>");out.println("您的性别:");out.println(sex+"<br>");voidrecord(){Connectionconn=null;Statementstmt=null;Stringdriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";Stringurl="jdbc:sqlserver://localhost:1433;DatabaseName=text";try{Class.forName(driver);conn=DriverManager.getConnection(url,"sa","521900");stmt=conn.createStatement();Stringsql="select*fromwork1";sql="insertintowork1values(user,pwd,name,pho,sex)";stmt.executeUpdate(sql);stmt.close();conn.close();}catch(ClassNotFoundExceptione){System.out.print(e);}catch(SQLExceptionee){System.out.print(ee);}sessino.setAttribute("user",user);}我知道sessino.setAttribute("user",user);和sql="insertintowork1values(user,pwd,name,pho,sex)"错了、、谁能告诉我怎么改。。。。谢谢
解决方案
解决方案二:
发错了,我想发的程序是这个。。要怎么改???谢谢。。初学者。<body><%request.setCharacterEncoding("utf-8");Stringuser=request.getParameter("user").trim();Stringpwd=request.getParameter("pwd").trim();Stringname=request.getParameter("name").trim();Stringpho=request.getParameter("pho").trim();Stringsex=request.getParameter("sex").trim();out.println("您的账号:");out.println(user+"<br>");out.println("您的密码:");out.println(pwd+"<br>");out.println("您的姓名:");out.println(name+"<br>");out.println("您的手机号:");out.println(pho+"<br>");out.println("您的性别:");out.println(sex+"<br>");%><!%voidrecord(){Connectionconn=null;Statementstmt=null;Stringdriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";Stringurl="jdbc:sqlserver://localhost:1433;DatabaseName=text";try{Class.forName(driver);conn=DriverManager.getConnection(url,"sa","521900");stmt=conn.createStatement();Stringsql="select*fromwork1";sql="insertintowork1values(user,pwd,name,pho,sex)";stmt.executeUpdate(sql);stmt.close();conn.close();}catch(ClassNotFoundExceptione){System.out.print(e);}catch(SQLExceptionee){System.out.print(ee);}sessino.setAttribute("user",user);}
解决方案三:
你确定你代码每写错voidrecord()这个方法是用<%!%>包起来的吧怎么会是<!%%>
解决方案四:
你要是直接测试注册功能的话就这样<%Connectionconn=null;Statementstmt=null;Stringdriver="com.microsoft.sqlserver.jdbc.SQLServerDriver";Stringurl="jdbc:sqlserver://localhost:1433;DatabaseName=text";try{Class.forName(driver);conn=DriverManager.getConnection(url,"sa","521900");stmt=conn.createStatement();Stringsql="select*fromwork1";sql="insertintowork1values(user,pwd,name,pho,sex)";stmt.executeUpdate(sql);stmt.close();conn.close();}catch(ClassNotFoundExceptione){System.out.print(e);}catch(SQLExceptionee){System.out.print(ee);}sessino.setAttribute("user",user);%>想用方法封装的话最好写到后台类里面去,前台实例化一下,在调用方法传参数回去就可以了。
解决方案五:
sessino换成session