登陆页面源代码

发布时间：2020-12-12 15:02:19 所属栏目：MsSql教程来源：网络整理

导读：?CheckServlet.class package Login; import java.io.*; import java.net.*; import java.sql.ResultSet; import java.sql.SQLException; import javax.servlet.*; import javax.servlet.http.*; public class CheckServlet extends HttpServlet { private s

?CheckServlet.class

package Login; import java.io.*; import java.net.*; import java.sql.ResultSet; import java.sql.SQLException; import javax.servlet.*; import javax.servlet.http.*; public class CheckServlet extends HttpServlet { private static final long serialVersionUID = 1L; protected void processRequest(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException { response.setContentType("text/html;charset=UTF-8"); String name = request.getParameter("uname"); String pword = request.getParameter("pword"); String path = request.getContextPath(); if (login(name,pword)) { path = path + "/success.jsp"; } else { path = path + "/index.jsp"; } response.sendRedirect(path); } protected void doGet(HttpServletRequest request,IOException { processRequest(request,response); } protected void doPost(HttpServletRequest request,response); } public String getServletInfo() { return "Short description"; } private boolean login(String uname,String pword) { boolean flag = false; String sql = "select count(*) from d_xt_yh where yh_mc='" + uname + "' and yh_mm='" + pword + "'"; try { ResultSet rs = Dbutil.executeQuery(sql); while (rs.next()) { if (rs.getInt(1) > 0) flag = true; } } catch (SQLException e) { e.printStackTrace(); } catch (ClassNotFoundException e) { e.printStackTrace(); } return flag; } }

数据库连接类文件

package Login; import java.sql.*; public class Dbutil { static String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; static String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=xmglxt"; static String user = "sa"; static String pwd = "sa"; public static Connection getConn() throws ClassNotFoundException,SQLException { Connection conn = null; Class.forName(driver); conn = DriverManager.getConnection(url,user,pwd); return conn; } public static ResultSet executeQuery(String sql) throws SQLException,ClassNotFoundException { Connection conn = Dbutil.getConn(); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql); // Dbutil.close(conn,stmt,rs); return rs; } public static void close(Connection conn,Statement stmt,ResultSet rs) throws SQLException { rs.close(); stmt.close(); conn.close(); } }

JSP文件

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<html>
??? <head>
??????? <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
??????? <title>登陆</title>
??? </head>
??? <body>
<center><br><br><br>

</center>??? </body></html>

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!