本文介绍了如何在Android Studio项目中使用Servlet和MySQL数据库实现登录和注册功能。通过创建实体类User、JDBCUtils工具类、UserDao接口及其实现，以及LoginServlet和RegisterServlet，实现了用户信息的验证和存储。在Android端，利用PostUtil工具类发送POST请求与Servlet交互，完成登录和注册操作。
一、Android 项目当中设置明文传输
1、设置明文传输的xml
2、引入上述创建的xml
android:networkSecurityConfig="@xml/network_security_config"
二、在MyEclipse当中创建Web项目
1、创建项目
引入MySQL的驱动包
2、创建实体类User
package entity;
public class User {
private int id;
private String name;
private String username;
private String password;
private int age;
private String phone;
public User() {
}
public User(int id, String name, String username, String password, int age, String phone) {
this.id = id;
this.name = name;
this.username = username;
this.password = password;
this.age = age;
this.phone = phone;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
}
3、创建JDBCUtils工具类
package dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class JDBCUtils {
static {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConn() {
Connection conn = null;
try {
conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test","root","root");
}catch (Exception exception){
exception.printStackTrace();
}
return conn;
}
public static void close(Connection conn){
try {
conn.close();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
最低0.47元/天 解锁文章
1230
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
