用java写一个简单的用户登录注册代码
时间: 2024-05-02 08:23:11 浏览: 17
下面是一个简单的Java用户登录注册代码,其中使用了MySQL数据库存储用户信息:
```
import java.sql.*;
public class UserLoginRegister {
private static final String DB_URL = "jdbc:mysql://localhost:3306/mydb";
private static final String DB_USER = "root";
private static final String DB_PASSWORD = "password";
public static void main(String[] args) {
try {
Connection conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);
Statement stmt = conn.createStatement();
// 建立用户表
String userTable = "CREATE TABLE IF NOT EXISTS users ("
+ "id INT(11) NOT NULL AUTO_INCREMENT,"
+ "username VARCHAR(50) NOT NULL,"
+ "password VARCHAR(50) NOT NULL,"
+ "PRIMARY KEY (id))";
stmt.executeUpdate(userTable);
// 用户注册
String username = "test";
String password = "test";
String registerSql = "INSERT INTO users (username, password) VALUES ('" + username + "', '" + password + "')";
stmt.executeUpdate(registerSql);
// 用户登录
String loginSql = "SELECT * FROM users WHERE username='" + username + "' AND password='" + password + "'";
ResultSet rs = stmt.executeQuery(loginSql);
if (rs.next()) {
System.out.println("登录成功");
} else {
System.out.println("用户名或密码错误");
}
// 关闭连接
rs.close();
stmt.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
```
需要注意的是,上述代码中的用户名和密码是明文存储的,实际应用中需要对密码进行加密存储以提高安全性。
相关推荐
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![](https://csdnimg.cn/download_wenku/file_type_ask_c1.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)