ONLY__MJ ONLY__MJ
关注数: 62 粉丝数: 95 发帖数: 1,236 关注贴吧数: 50
那位兄弟帮我看看这段代码 package javabean; import java.io.IOException; import java.io.PrintWriter; import java.sql.*; import javax.servlet.ServletException; import javax.servlet.http.*; public class updateServlet extends HttpServlet { public void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{ response.setContentType("text/html"); request.setCharacterEncoding("gb2312"); PrintWriter out=response.getWriter(); this.doPost(request, response); out.flush(); out.close(); } public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException{ response.setContentType("text/html;charset=gb2312"); request.setCharacterEncoding("gb2312"); PrintWriter out=response.getWriter(); Connection conn=null; PreparedStatement psm=null; ResultSet rs=null; Statement stmt=null; String username=request.getParameter("username"); String password=request.getParameter("password"); String phone=request.getParameter("phone"); String email=request.getParameter("email"); String address=request.getParameter("address"); try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); String url = "jdbc:sqlserver://localhost:1433;databaseName=wssd"; conn = DriverManager.getConnection(url, "sa", "sa"); String sql="update userinfo Set username=?,password=?,phone=?,email=? address=?where username=?"; psm=conn.prepareStatement(sql); psm.setString(1,username); psm.setString(2,password); psm.setString(3,phone); psm.setString(4,email); psm.setString(5,address); psm.executeUpdate(); System.out.println("修改成功"); stmt=conn.createStatement(); rs=stmt.executeQuery("select * from userinfo"); out.println("<html>"+ "<head><title>用户信息</title></head>"+"<body>"); out.println(" <h1>修改后信息如下</h1><br><br>"); while(rs.next()){ out.print("用户:"); out.print(rs.getString(1)+"\t"); out.print("密码:"); out.print(rs.getString(2)+"\t"); out.print("电话:); out.print(rs.getString(3)+"\t"); out.print("邮箱:"); out.print(rs.getString(4)+"\t"); out.print("地址:"); out.print(rs.getString(5)+"\t"); out.println("<br>"); } out.println("</body></html>"); out.close(); }catch(Exception e){} out.flush(); out.close(); } } 我运行后弹出空白页面什么都没
1 下一页