Java 登陆系统

Java 简单登陆系统：

index.jsp：

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>




欢迎登陆






欢迎登录系统

请输入身份：






请输入学号：

请输入密码：

succeed.jsp

<%@page import="java.util.Date"%>
<%@page import="java.text.SimpleDateFormat"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>




登陆成功




目前登录的用户：<%=session.getAttribute("name") %>
退出登录
<% out.print(""); 
%>



登录的时间:
<%
    SimpleDateFormat nowdate =new SimpleDateFormat(
		"yyyy年MM月dd日HH时mm分ss秒");
  out.print(nowdate.format(new Date()));
%>




现在的时间：





当前的等级：




升级需时间：

check.jsp:

<%@page import="java.sql.*"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>




判断



<%

String username=request.getParameter("user");//全参 
String password=request.getParameter("psd");
String shenfen=request.getParameter("sel");
//String x="账号";//后台
//String y="密码";
String str="jdbc:sqlserver://127.0.0.1:1433;databaseName=work";
String u="sa";
String p="123456";
String s1="";
String s2="";
String s3="";
String s4="";
String s5="";



//PreparedStatement ps=null;
PreparedStatement ps=null;
Connection c=null;
ResultSet rs=null;
Statement stmt=null;

try{
	Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
	//System.out.println("加载驱动成功");
}catch(Exception e){
	e.printStackTrace();
	System.out.println("加载驱动失败");
}

try{
	c=DriverManager.getConnection(str,u,p);
	//System.out.println("连接成功");
}catch(Exception e){
	e.printStackTrace();
	System.out.println("连接失败");
}finally{
	
}

try{
	stmt=c.createStatement();
	String sql="select * from student where uid="+username;
	rs=stmt.executeQuery(sql);
	while(rs.next()){
		s1=rs.getString("uid");
		s2=rs.getString("psd");
		s3=rs.getString("name");
		s4=rs.getString("lv");
		s5=rs.getString("time");
		session.setAttribute("name", s3);
		session.setAttribute("lv", s4);
		session.setAttribute("time", s5);
		//System.out.println("学号:"+s1+"t"+"密码:"+s2+"t"+"姓名:"+s3+"t");
	}
}catch(Exception e){
	e.printStackTrace();
	System.out.println("执行数据库语句失败");
}finally{
	rs.close();
	stmt.close();
	c.close();
}
if(shenfen.equals("x")){
if(username.equals(s1) && password.equals(s2)){
		response.sendRedirect("success.jsp");
    }else{
	out.print("");
	response.setHeader("refresh","0;url=index.jsp");
}
}else if(shenfen.equals("y")){
	try{
		stmt=c.createStatement();
		String sql="select * from teacher where uid="+username;
		rs=stmt.executeQuery(sql);
		while(rs.next()){
			s1=rs.getString("uid");
			s2=rs.getString("psd");
			s3=rs.getString("name");
			s4=rs.getString("lv");
			s5=rs.getString("time");
			session.setAttribute("name", s3);
			session.setAttribute("lv", s4);
			session.setAttribute("time", s5);
			//System.out.println("学号:"+s1+"t"+"密码:"+s2+"t"+"姓名:"+s3+"t");
		}
	}catch(Exception e){
		e.printStackTrace();
		System.out.println("执行数据库语句失败");
	}finally{
		rs.close();
		stmt.close();
		c.close();
	}
	if(username.equals(s1) && password.equals(s2)){
		response.sendRedirect("teacher.jsp");
    }else{
	out.print("");
	response.setHeader("refresh","0;url=index.jsp");
}
}

%>

Check.java

package testSRC;

import java.sql.*;

public class Check {
	
	public String Connection() throws SQLException{
		String username="";//全参 
		String password="";
		String shenfen="";
	
		String s1="";
		String s2="";
		String s3="";
		String s4="";
		String s5="";
		
		Connection c=null;
		ResultSet rs=null;
		Statement stmt=null;
		
		String str="jdbc:sqlserver://127.0.0.1:1433;databaseName=work";
		String u="sa";
		String p="123456";

		try{
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			//System.out.println("加载驱动成功");
		}catch(Exception e){
			e.printStackTrace();
			System.out.println("加载驱动失败");
		}

		try{
			c=DriverManager.getConnection(str,u,p);
			//System.out.println("连接成功");
		}catch(Exception e){
			e.printStackTrace();
			System.out.println("连接失败");
		}finally{
			
		}

		try{
			stmt=c.createStatement();
			String sql="select * from student where uid="+username;
			rs=stmt.executeQuery(sql);
			while(rs.next()){
				s1=rs.getString("uid");
				s2=rs.getString("psd");
				s3=rs.getString("name");
				s4=rs.getString("lv");
				s5=rs.getString("time");
				//session.setAttribute("name", s3);
				//session.setAttribute("lv", s4);
				//session.setAttribute("time", s5);
				//System.out.println("学号:"+s1+"t"+"密码:"+s2+"t"+"姓名:"+s3+"t");
			}
		}catch(Exception e){
			e.printStackTrace();
			System.out.println("执行数据库语句失败");
		}finally{
			rs.close();
			stmt.close();
			c.close();
		}
		
			try{
				stmt=c.createStatement();
				String sql="select * from teacher where uid="+username;
				rs=stmt.executeQuery(sql);
				while(rs.next()){
					s1=rs.getString("uid");
					s2=rs.getString("psd");
					s3=rs.getString("name");
					s4=rs.getString("lv");
					s5=rs.getString("time");
					//session.setAttribute("name", s3);
					//session.setAttribute("lv", s4);
					//session.setAttribute("time", s5);
					//System.out.println("学号:"+s1+"t"+"密码:"+s2+"t"+"姓名:"+s3+"t");
				}
			}catch(Exception e){
				e.printStackTrace();
				System.out.println("执行数据库语句失败");
			}finally{
				rs.close();
				stmt.close();
				c.close();
			}
			return p;
			
		}

		
	}
 表：
uid psd name lv time phone fid

Java 登陆系统

Java相关栏目本月热门文章