Java Web实现简单注册、登录程序(链接数据库)

最新推荐文章于 2025-04-30 23:24:00 发布

大图书馆的牧羊人

最新推荐文章于 2025-04-30 23:24:00 发布

阅读量5.9k

点赞数 10

CC 4.0 BY-SA版权

分类专栏： Java Web学习

本文链接：https://blog.csdn.net/qwqc262/article/details/109276192

1.工程文件
在这里插入图片描述
至于如何配值数据库和连接数据库，网上有很多教程，我就不多说，关键就是连接数据库用的JDBC.jar一定要有并且把它放在图中的位置（sqljdbc4.jar）。其他诸如CSS和JS可以自由发挥，不用局限于我的工程文件。工作软件我用的是eclipse和SQL2008R2（官网可下）

2.Chack.jsp

<%@ page language="java" import="java.util.*,java.sql.*" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Check Page</title>
</head>
<body>
<% 
  String username="";
  String password="";
  username=request.getParameter("username");
  username=new String(username.getBytes("iso-8859-1"),"UTF-8");//编码转换，保证识别中文登录名
  password=request.getParameter("password");
  //out.println(username);
  String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
  String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=login";
  String userName="sa";//数据库用户名
  String userPwd="123456";//数据库密码
  String sql="select Username from users where Username='"+username+"'";
  String sql1="select Password from users where Password='"+password+"'";
  //out.println(sql);
  Class.forName(driverName);
  Connection stmt=DriverManager.getConnection(dbURL,userName,userPwd);
  
  Statement stmt1=stmt.createStatement();
  Statement stmt2=stmt.createStatement();
  ResultSet rs=stmt1.executeQuery(sql);
  ResultSet rs1=stmt2.executeQuery(sql1);
  if(rs.next()&&rs1.next()){
   
	  request.getRequestDispatcher("suc.jsp").forward(request, response);
  }
  else{
   
	  request.getRequestDispatcher("fail.jsp").forward(request, response);
  }
%>
</body>
</html>

3.fail.jsp

<%@ page language="java" import="java.util.*,java.sql.*" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>登录失败</title>
</head>
<body>
<%
String username="";
String password="";
username=request.getParameter("username");
password=request.getParameter("password");
//out.println(username);
//out.println(username);
  String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
  String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=login";
  String userName="sa";
  String userPwd="123456";
  String sql="select Username from users where Username='"+username+"'";
  String sql1="select Password from users where Password='"+password+"'";
  //out.println(sql);
  Class.forName(driverName);
  Connection stmt=DriverManager.getConnection(dbURL,userName,userPwd);
  
  Statement stmt1=stmt.createStatement();
  Statement stmt2=stmt.createStatement();
  ResultSet rs=stmt1.executeQuery(sql);
  ResultSet rs1=stmt2.executeQuery(sql1);
  if(rs.next()){
   
	  out.println("密码错误，请重新登录！");
	  %

最低0.47元/天解锁文章