這是我的Jsp期末作業(yè)，用jsp寫一個(gè)簡(jiǎn)單的用戶管理系統(tǒng)
下面是登錄界面，Login用了幾個(gè)css就不貼上來了
LoginCheck是用來驗(yàn)證用戶名和密碼是否正確
我的數(shù)據(jù)庫(kù)用的是mysql，名字是db_01,賬號(hào)和密碼都是root
1.Login.jsp
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="utf-8"%>
<!DOCTYPE html>
<html lang="en" class="no-js">
<head>
<meta charset="utf-8">
<title>管理系統(tǒng)登錄界面</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="">
<!-- CSS -->
<link rel='stylesheet' >
<link rel="stylesheet" href="assets/css/reset.css">
<link rel="stylesheet" href="assets/css/supersized.css">
<link rel="stylesheet" href="assets/css/style.css">
<!-- HTML5 shim, for IE6-8 support of HTML5 elements -->
<!--[if lt IE 9]>
<script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
<![endif]-->
</head>
<body>
<div class="page-container">
<h1>Login</h1>
<form action="loginCh.jsp" method="post">
<input type="text" name="name" class="username" placeholder="Username">
<input type="password" name="pwd" class="password" placeholder="Password">
<button type="submit">點(diǎn)擊登錄</button>
<div class="error"><span>+</span></div>
</form>
</div>
<!-- Javascript -->
<script src="assets/js/jquery-1.8.2.min.js"></script>
<script src="assets/js/supersized.3.2.7.min.js"></script>
<script src="assets/js/supersized-init.js"></script>
<script src="assets/js/scripts.js"></script>
</body>
</html>
2.LoginCheck
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="utf-8"%>
<body>
<%
String name=new String(request.getParameter("name").getBytes("ISO8859_1"),"UTF-8");
String pwd=new String(request.getParameter("pwd").getBytes("ISO8859_1"),"UTF-8");
// 加載數(shù)據(jù)庫(kù)驅(qū)動(dòng)，注冊(cè)到驅(qū)動(dòng)管理器
Class.forName("com.mysql.jdbc.Driver");
// 數(shù)據(jù)庫(kù)連接字符串
String url = "jdbc:mysql://localhost:3306/db_01";
// 數(shù)據(jù)庫(kù)用戶名
String usename = "root";
// 數(shù)據(jù)庫(kù)密碼
String psw = "root";
// 創(chuàng)建Connection連接
Connection conn = DriverManager.getConnection(url,usename,psw);
// 判斷 數(shù)據(jù)庫(kù)連接是否為空
if(conn != null){
String sql="select * from user where usr='"+name+"' and passwd='"+ pwd + "'";
Statement stmt = conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
response.sendRedirect("success.jsp");
}else{
out.print("用戶名或密碼錯(cuò)誤，請(qǐng)重新輸入！");
%>
<a href="index.jsp">返回</a>
<%
}
// 輸出連接信息
//out.println("數(shù)據(jù)庫(kù)連接成功！");
// 關(guān)閉數(shù)據(jù)庫(kù)連接
conn.close();
}else{
// 輸出連接信息
out.println("數(shù)據(jù)庫(kù)連接失??！");
}
%>
<% session.putValue("name",name);%>
</body>
登錄界面代碼就這么多，后續(xù)還有注冊(cè)、管理、查詢等界面
查看后續(xù)代碼請(qǐng)看這里??后續(xù)代碼
