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

}

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();

}

}

}

4、创建UserDao类

package dao;

import java.sql.Connection;

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)