Android Studio 实现登录注册-源代码 二（Servlet + 连接MySql数据库）

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import entity.User;

public class UserDao {

public boolean login(String name,String password){

String sql = “select * from users where name = ? and password = ?”;

Connection con = JDBCUtils.getConn();

try {

PreparedStatement pst=con.prepareStatement(sql);

pst.setString(1,name);

pst.setString(2,password);

if(pst.executeQuery().next()){

return true;

}

} catch (SQLException throwables) {

throwables.printStackTrace();

}finally {

JDBCUtils.close(con);

}

return false;

}

public boolean register(User user){

String sql = “insert into users(name,username,password,age,phone) values (?,?,?,?,?)”;

Connection con = JDBCUtils.getConn();

try {

PreparedStatement pst=con.prepareStatement(sql);

pst.setString(1,user.getName());

pst.setString(2,user.getUsername());

pst.setString(3,user.getPassword());

pst.setInt(4,user.getAge());

pst.setString(5,user.getPhone());

int value = pst.executeUpdate();

if(value>0){

return true;

}

} catch (SQLException throwables) {

throwables.printStackTrace();

}finally {

JDBCUtils.close(con);

}

return false;

}

public User findUser(String name){

String sql = “select * from users where name = ?”;

Connection con = JDBCUtils.getConn();

User user = null;

try {

PreparedStatement pst=con.prepareStatement(sql);

pst.setString(1,name);

ResultSet rs = pst.executeQuery();

while (rs.next()){

int id = rs.getInt(1);

String namedb = rs.getString(2);

String username = rs.getString(3);

String passworddb = rs.getString(4);

int age = rs.getInt(5);

String phone = rs.getString(6);

user = new User(id,namedb,username,passworddb,age,phone);

}

} catch (SQLException throwables) {

throwables.printStackTrace();

}finally {

JDBCUtils.close(con);

}

return user;

}

}

5、创建对应的LoginServlet

package servlet;

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import dao.UserDao;

public class LoginServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

doPost(request, response);

}

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

String name = request.getParameter(“name”);

String password = request.getParameter(“password”);

response.setCharacterEncoding(“UTF-8”);

UserDao dao = new UserDao();

boolean login = dao.login(name, password);

String msg = “”;

if(login){

msg = “成功”;

}else{

msg = “失败”;

}

PrintWriter out = response.getWriter();

out.println(msg);

out.flush();

out.close();

}

}

三、在Android Studio当中调用Servlet

---

（一）实现登录功能

1、创建连接Servlet的工具类（PostUtil）

package com.example.application01.utils;

import java.io.BufferedReader;

import java.io.IOException;

import java.io.InputStream;

import java.io.InputStreamReader;

import java.io.OutputStream;

import java.net.HttpURLConnection;

import java.net.URL;

import java.net.URLEncoder;

//访问servlet

public class PostUtil {

//访问的serlver不一样

//传递的参数不一样

public static String Post(String url,String data)

{

String msg = “”;

try{

//http://ms-yffprtappszi:8080/AndroidWeb/LoginServlet

HttpURLConnection conn = (HttpURLConnection) new URL(“http://10.0.2.2:8080/AndroidWeb/”+url).openConnection();

//设置请求方式,请求超时信息

conn.setRequestMethod(“POST”);

conn.setReadTimeout(5000);

conn.setConnectTimeout(5000);

//设置运行输入,输出:

conn.setDoOutput(true);

conn.setDoInput(true);

//Post方式不能缓存,需手动设置为false

conn.setUseCaches(false);

//我们请求的数据:

//获取输出流

OutputStream out = conn.getOutputStream();

out.write(data.getBytes());

out.flush();

if (conn.getResponseCode() == 200) {

// 获取响应的输入流对象

InputStream is = conn.getInputStream();

BufferedReader reader = new BufferedReader(new InputStreamReader(is));

StringBuffer response = new StringBuffer();

String line=null;

while ((line = reader.readLine()) != null) {

response.append(line);

}

msg=response.toString();

}

}catch(Exception e)

{

e.printStackTrace();

}

return msg;

}

}

2、在MainActivity调用这个类

package com.example.application01;

import androidx.appcompat.app.AppCompatActivity;

import android.content.Intent;

import android.os.Bundle;

import android.os.Handler;

import android.os.Message;

import android.view.View;

import android.widget.EditText;

import android.widget.Toast;

import com.example.application01.dao.UserDao;

import com.example.application01.utils.PostUtil;

import java.io.UnsupportedEncodingException;

import java.net.URLEncoder;

public class MainActivity extends AppCompatActivity {

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_main);

}

public void reg(View view){

startActivity(new Intent(getApplicationContext(),RegisterActivity.class));

}

public void login(View view){

EditText EditTextname = (EditText)findViewById(R.id.name);

EditText EditTextpassword = (EditText)findViewById(R.id.password);

new Thread(){

@Override

public void run() {

String data=“”;

try {

data = “name=”+ URLEncoder.encode(EditTextname.getText().toString(), “UTF-8”)+

“&password=”+ URLEncoder.encode(EditTextpassword.getText().toString(), “UTF-8”);

} catch (UnsupportedEncodingException e) {

e.printStackTrace();

}

String request = PostUtil.Post(“LoginServlet”,data);

int msg = 0;

if(request.equals(“成功”)){

msg = 1;

}

hand1.sendEmptyMessage(msg);

}

}.start();

}

final Handler hand1 = new Handler()

{

@Override

public void handleMessage(Message msg) {

if(msg.what == 1)

{

Toast.makeText(getApplicationContext(),“登录成功”,Toast.LENGTH_LONG).show();

}

else

{

Toast.makeText(getApplicationContext(),“登录失败”,Toast.LENGTH_LONG).show();

}

}

};

}

在开启web项目的情况下运行Android项目

（二）实现注册功能

1、在web工程当中创建RegisterServlet

package servlet;

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import dao.UserDao;

import entity.User;

public class RegisterServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

doPost(request, response);

}

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

System.out.println(“-----------------”);

response.setCharacterEncoding(“UTF-8”);

String name = request.getParameter(“name”);

String username = request.getParameter(“username”);

String password = request.getParameter(“password”);

String phone = request.getParameter(“phone”);

int age = Integer.parseInt(request.getParameter(“age”));

User user = new User();

user.setName(name);

user.setUsername(username);

user.setPassword(password);

user.setAge(age);

user.setPhone(phone);

String msg = “”;

UserDao userDao = null;

User uu = null;

userDao = new UserDao();

uu = userDao.findUser(user.getName());

boolean flag = false;

if(uu == null){

flag = userDao.register(user);

}

if(flag){

msg = “成功”;

}else{

msg = “失败”;

}

if(uu != null)

{

msg = “已存在”;

}

PrintWriter out = response.getWriter();

out.println(msg);

out.flush();

out.close();

}

}

2、在Android当中的RegisterActivity访问Servlet

package com.example.application01;

import androidx.appcompat.app.AppCompatActivity;

import android.content.Intent;

import android.os.Bundle;

import android.os.Handler;

import android.os.Message;

import android.view.View;

import android.widget.EditText;

import android.widget.Toast;

import com.example.application01.dao.UserDao;

import com.example.application01.entity.User;

import com.example.application01.utils.PostUtil;

import java.io.UnsupportedEncodingException;

import java.net.URLEncoder;

public class RegisterActivity extends AppCompatActivity {

EditText name = null;

EditText username = null;

EditText password = null;

EditText phone = null;

EditText age = null;

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_register);

name = findViewById(R.id.name);

username = findViewById(R.id.username);

password = findViewById(R.id.password);

phone = findViewById(R.id.phone);

age = findViewById(R.id.age);

}

public void register(View view){

String cname = name.getText().toString();

String cusername = username.getText().toString();

String cpassword = password.getText().toString();

System.out.println(phone.getText().toString());

String cphone = phone.getText().toString();

int cgae = Integer.parseInt(age.getText().toString());

if(cname.length() < 2 || cusername.length() < 2 || cpassword.length() < 2 ){

Toast.makeText(getApplicationContext(),“输入信息不符合要求请重新输入”,Toast.LENGTH_LONG).show();

return;

}

User user = new User();

user.setName(cname);

user.setUsername(cusername);

user.setPassword(cpassword);

user.setAge(cgae);

user.setPhone(cphone);

new Thread(){

@Override

public void run() {

String data=“”;

最后

自我介绍一下，小编13年上海交大毕业，曾经在小公司待过，也去过华为、OPPO等大厂，18年进入阿里一直到现在。

深知大多数Java工程师，想要提升技能，往往是自己摸索成长，自己不成体系的自学效果低效漫长且无助。

因此收集整理了一份《2024年Java开发全套学习资料》，初衷也很简单，就是希望能够帮助到想自学提升又不知道该从何学起的朋友，同时减轻大家的负担。

既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，基本涵盖了95%以上Java开发知识点，不论你是刚入门Java开发的新手，还是希望在技术上不断提升的资深开发者，这些资料都将为你打开新的学习之门！

如果你觉得这些内容对你有帮助，需要这份全套学习资料的朋友可以戳我获取！！

由于文件比较大，这里只是将部分目录截图出来，每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频，并且会持续更新！
th() < 2 ){

Toast.makeText(getApplicationContext(),“输入信息不符合要求请重新输入”,Toast.LENGTH_LONG).show();

return;

}

User user = new User();

user.setName(cname);

user.setUsername(cusername);

user.setPassword(cpassword);

user.setAge(cgae);

user.setPhone(cphone);

new Thread(){

@Override

public void run() {

String data=“”;

最后

自我介绍一下，小编13年上海交大毕业，曾经在小公司待过，也去过华为、OPPO等大厂，18年进入阿里一直到现在。

深知大多数Java工程师，想要提升技能，往往是自己摸索成长，自己不成体系的自学效果低效漫长且无助。

因此收集整理了一份《2024年Java开发全套学习资料》，初衷也很简单，就是希望能够帮助到想自学提升又不知道该从何学起的朋友，同时减轻大家的负担。

[外链图片转存中…(img-ts0P5Vhk-1715665872314)]

[外链图片转存中…(img-clzjxht3-1715665872315)]

[外链图片转存中…(img-vFtH0ERb-1715665872315)]

既有适合小白学习的零基础资料，也有适合3年以上经验的小伙伴深入学习提升的进阶课程，基本涵盖了95%以上Java开发知识点，不论你是刚入门Java开发的新手，还是希望在技术上不断提升的资深开发者，这些资料都将为你打开新的学习之门！

如果你觉得这些内容对你有帮助，需要这份全套学习资料的朋友可以戳我获取！！

由于文件比较大，这里只是将部分目录截图出来，每个节点里面都包含大厂面经、学习笔记、源码讲义、实战项目、讲解视频，并且会持续更新！