登陆功能:
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script src="../jQuery/jquery.js"></script>
</head>
<body>
<form>
用户名:<input type="text" id="username" />
<input type="button" onclick="send()" value="登陆" />
<input type="button" onclick="post()" value="注册" />
<br>
密码:<input type="password" id="password" />
</form>
</body>
<script>
function send(){
var username=$('#username').val();
var password=$('#password').val();
$.ajax({
type:"GET",
url:"../Denglu",
dataType:"JSON",
data:{
"username":username,
"password":password,
},
success:function(data){
if(data.flag=="000"){
alert("成功");
}else if(data.flag=="111"){
alert("失败");
}
},
error:function(){
alert("===");
}
});
}
function post(){
window.location.href="./Zhuce.html";
}
</script>
</html>
注册:
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<script src="../jQuery/jquery.js"></script>
<style>
#jiemian{
width:300px;
height:300px;
margin-left:300px;
margin-top:150px;
}
#username{
margin-left:20px;
}
#password{
float:left;
margin-left:20px;
}
#password1{
float:left;
margin-left:20px;
}
#denglu{
float:left;
margin-left:20px;
}
.zi{
margin-left:10px;
}
</style>
</head>
<body>
<div id="jiemian">
<p class="zi">用户名:</p>
<input type="text" id="username" />
<p class="zi">密码:</p>
<input type="password" id="password" />
</br>
<p class="zi">请确认密码:</p>
<input type="password" id="password1"/>
</br>
<input type="button" value="登陆"onclick="send()"id="denglu"/>
</div>
</body>
<script>
function send(){
var username=$('#username').val();
var password=$('#password').val();
var password1=$('#password1').val();
if(password!=password1){
alert("密码不一致,请重新输入");
}
else if(password==password1){
window.location.href="./denglu.html";
}
if(username!=""&&password!=""){
$.ajax({
type:"POST",
url:"../Servlet",
dataType:"JSON",
data:{
"username":username,
"password":password,
}
})
}else{
alert("请检查您的输入!");
}
}
</script>
</html>
登陆的servlet
package com.denglu;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/Denglu")
public class Denglu extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* Default constructor.
*/
public Denglu() {
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
@SuppressWarnings("unlikely-arg-type")
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/json;charset=utf-8");
response.setCharacterEncoding("utf-8");
String username=request.getParameter("username");
String password=request.getParameter("password");
try {
Class.forName("com.mysql.cj.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/learn?serverTimezone=GMT%2B8";
String user="root";
String shujukupassword="password";
Connection connection=DriverManager.getConnection(url,user,shujukupassword);
PreparedStatement preparedstatement=connection.prepareStatement("select Password from user where Username=? and Password=?");
preparedstatement.setString(1,username);
preparedstatement.setString(2,password);
ResultSet rs = preparedstatement.executeQuery();
if(rs.next()) {
request.getSession().setAttribute("username", username);
request.getSession().setAttribute("password",password);
String json = "{\"flag\":\"000\",\"message\":\"\"}";
response.getWriter().append(json);
}
else {
String json = "{\"flag\":\"111\",\"message\":\"\"}";
response.getWriter().append(json);
}
}catch (ClassNotFoundException e)
{
e.printStackTrace();
}
catch (SQLException e) {
e.printStackTrace();
}
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
@SuppressWarnings("unlikely-arg-type")
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
}
}
注册的servlet
package com.denglu;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class Servlet
*/
@WebServlet("/Servlet")
public class Servlet extends HttpServlet {
private static final long serialVersionUID = 1L;
/**
* Default constructor.
*/
public Servlet() {
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
response.getWriter().append("Served at: ").append(request.getContextPath());
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html");
String username=request.getParameter("username");
String password=request.getParameter("password");
try {
Class.forName("com.mysql.cj.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/learn?serverTimezone=GMT%2B8";
String user="root";
String shujukupassword="password";
Connection connection=DriverManager.getConnection(url,user,shujukupassword);
PreparedStatement preparedStatement=connection.prepareStatement("insert into user (Username,Password) values (?,?)");
preparedStatement.setString(1,username);
preparedStatement.setString(2,password);
preparedStatement.executeUpdate();
}catch (ClassNotFoundException e)
{
e.printStackTrace();
}
catch (SQLException e) {
e.printStackTrace();
}
}
public static void main(String []args) {
int a=0;
for(int i=0;i<10;i++) {
a=a++;
System.out.println("a");
}
}
}