JAVA simple link Oracle database registration and login function implementation code
- 2020-04-01 02:46:04
- OfStack
//The basic information of the User is also three columns in the USERINFO table
package Log in to judge ;
public class User {
private String name;
private String loginname;
private String loginpsw;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getLoginname() {
return loginname;
}
public void setLoginname(String loginname) {
this.loginname = loginname;
}
public String getLoginpsw() {
return loginpsw;
}
public void setLoginpsw(String loginpsw) {
this.loginpsw = loginpsw;
}
}
//A small block of code for registering and logging in
package Log in to judge ;
import java.util.Scanner;
public class In {
public static User getUser(){
User u = new User();
Scanner sc = new Scanner(System.in);
System.out.println(" Please enter a login name ");
u.setLoginname(sc.nextLine());
System.out.println(" Please enter your password ");
u.setLoginpsw(sc.nextLine());
return u;
}
public static User registerUser(){
User u = new User();
Scanner sc = new Scanner(System.in);
System.out.println(" Please register your username ");
u.setName(sc.nextLine());
System.out.println(" Please register your login name ");
u.setLoginname(sc.nextLine());
System.out.println(" Please register your password ");
u.setLoginpsw(sc.nextLine());
return u;
}
}
//Login check, determine whether the login name and password is correct, correct will return the user name
package Log in to judge ;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class Check {
public static void checkUser(User u)
{
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String user = "scott";
String password = "tiger";
Connection conn = null;
ResultSet rs = null;
PreparedStatement pst = null;
String sql = "Select name from USERINFO where loginname = ? and loginpsw = ? ";
try {
conn = DriverManager.getConnection(url, user, password);
pst = conn.prepareStatement(sql);
pst.setString(1, u.getLoginname());
pst.setString(2,u.getLoginpsw());
rs = pst.executeQuery();
while(rs.next()){
u.setName(rs.getString(1));
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
rs.close();
pst.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if(u.getName() == null || u.getName().isEmpty()){
System.out.println(" Logon failure ");
}else{
System.out.println(" welcome "+u.getName()+" landing ");
}
}
}
//Registration interface, to determine whether the login name is repeated, there is a repeat registration failure. A little doubt, marked with comments
package Log in to judge ;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Register {
public static void registUser(User u){
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String user = "scott";
String password = "tiger";
Connection conn = null;
String sql = "Insert Into USERINFO values(?,?,?)";
PreparedStatement pst = null;
//Determines if the login name already exists
Statement s = null;
ResultSet rs = null;
String sql_ck = "Select LOGINNAME FROM USERINFO";
try {
conn = DriverManager.getConnection(url, user, password);
pst = conn.prepareStatement(sql);
pst.setString(1, u.getName());
pst.setString(2, u.getLoginname());
pst.setString(3, u.getLoginpsw());
//Determines if the login name already exists
s = conn.createStatement();
rs = s.executeQuery(sql_ck);
while(rs.next()){//Why would using rs.getstring (2) prompt an invalid index
if( rs.getString("LOGINNAME").equals(u.getLoginname()) ){
System.out.println(" The login name already exists. Registration failed ");
break;
}else{
pst.executeUpdate();
System.out.println(" Registered successfully ");
break;
}
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
try {
rs.close();
pst.close();
s.close();
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
//The main interface//
//The structure of the table in the database looks like this
//Name (user name for display),
//Loginname (loginname, the ID entered when logging in)
//Loginpsw (login password)
package Log in to judge ;
import java.util.Scanner;
public class Test {
public static void main(String[] args) {
int chos = 0;
Scanner sc = new Scanner(System.in);
System.out.println("tt Log in, please click 1tt To register please click 2");
chos = sc.nextInt();
switch(chos){
case 1: Check.checkUser(In.getUser());break;
case 2: Register.registUser(In.registerUser());break;
default: System.out.println(" Please enter the correct selection ");break;
}
}
}