刚学习了JDBC于是趁热写了一个用户管理系统 代码如下(不是教程 仅仅是想记录一下自己写过的代码):
1. 用户注册
package com.piggyz.javatest;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.util.Scanner;
public class register {
public void reg() throws Exception{
//Scanner获取用户输入
Scanner sc = new Scanner(System.in);
System.out.println("please enter the username: ");
String username = sc.next();
System.out.println("please enter the password:");
String password1 = sc.next();
System.out.println("please re-enter your password: ");
String password2 = sc.next();
//判断两次输入是否相等
if(!password1.equals(password2)) {
System.out.println("the first and second passwords you entered are different please re-enter!");
reg();
}
//注册驱动
Class.forName("com.mysql.cj.jdbc.Driver");
//获取连接
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/login","root","1234567890");
//预编译和获取对象
String sql = "insert into userinfo(Username,Password) values(?,?)";
PreparedStatement ps = conn.prepareStatement(sql);
//赋值
ps.setString(1,username);
ps.setString(2,password1);
int count = ps.executeUpdate();
//判断是否成功
if(count == 1) {
System.out.println("register successfully!");
} else{
System.out.println("register unsuccessfully!");
}
//关闭以释放资源
ps.close();
conn.close();
userlogin.start();
sc.close();
}
}
输出结果:
sql: