jsp，点击提交后出现个异常卡住了

YXTS122 2017-07-04 11:28:41

<%@ page language="java" import="java.util.*" pageEncoding="GB2312" %>

<html>

   <head>

       <title>用户注册页面</title>

   </head>

   <body>

      <h3 align=center>新用户注册</h3>

      <center>

        <table>

            <form action="userregister.jsp" method="get">

              <tr>

                 <td>用户名:</td>

                 <td>

                     <input type="text" name="userName">

                 </td>

              </tr>

              <tr>

                <td>输入密码:</td>

                <td>

                   <input type="password" name="userPass">

                </td>

             </tr>

               <tr>

                 <td>确认密码:</td>

                 <td>

                     <input type="password" name="verifyPass">

                 </td>

              </tr>

                <tr>

                 <td>电子邮箱:</td>

                 <td>

                     <input type="text" name="email">

                 </td>

              </tr>

                <tr>

                 <td>真实姓名:</td>

                 <td>

                     <input type="text" name="trueName">

                 </td>

              </tr>

                <tr>

                 <td>联系地址:</td>

                 <td>

                     <input type="text" name="address">

                 </td>

              </tr>

                <tr>

                 <td>联系电话:</td>

                 <td>

                     <input type="text" name="telephone">

                 </td>

              </tr>

              <tr>

                 <td>   

          <input type="submit" value="提交">

          </td>

          <td>   

           <input type="reset" value="重置">

           </td>

         </tr>

        </table>

      </center>

    </body>

</html>

 <%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="GB2312" %>

<html>

   <body>

       <%! 

             public String getString(String str)

             {

                if (str==null)

                {

                    str="";

                }

                else

                {

                    try

                    {

                        byte[] b=str.getBytes("ISO-8859-1");

                        str=new String(b);

                    }

                    catch (Exception e)

                    {

                        e.printStackTrace();

                    }

                }

                return str;

             }

         %>

         <%

            String userName=request.getParameter("userName");

            String userPass=request.getParameter("userPass");

            String email=request.getParameter("email");

            String trueName=request.getParameter("trueName");

            String address=request.getParameter("address");

            String telephone=request.getParameter("telephone");

            userName=getString(userName);

            userPass=getString(userPass);

            email=getString(email);

            trueName=getString(trueName);

            address=getString(address);

            telephone=getString(telephone);

          %>

          <%

              Connection con=null;

              Statement stmt=null;

              ResultSet rs=null;

              String driver="com.microsoft.jdbc.sqlserver.SQLServerDriver";

              String url=" jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=JSPDB";

              try

              {

                Class.forName(driver);

                con=DriverManager.getConnection(url,"sa","123");

                stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

            String sql="insert into usertable values("+"'"+userName+"','"+userPass+"','"+email+"','"+trueName+"','"+address+"','"+telephone+"')'";

            int i=stmt.executeUpdate(sql);

            if (i>0)

            {

                out.println("客户注册成功");

            }

            else

            {

                out.println("请重新注册!");

            }

            rs.close();

            stmt.close();

            con.close();

              }

              catch (Exception e)

              {

                out.println("e="+e.toString());

              }

           %>

           </body>

           </html>

...全文

320 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

街头小贩 2017-07-08

打赏
举报

https://docs.microsoft.com/en-us/sql/connect/jdbc/using-the-jdbc-driver

..
String connectionUrl = "jdbc:sqlserver://localhost:1433;" +  
   "databaseName=AdventureWorks;user=MyUserName;password=*****;";  
Connection con = DriverManager.getConnection(connectionUrl);