//User ç¨æ·çåºæ¬ä¿¡æ¯ï¼ä¹æ¯USERINFO表ä¸ç3个å
package
ç»éå¤æ;
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;
}
}
//ç¨äºæ³¨ååç»éçå°å°ä»£ç å
package
ç»éå¤æ;
import java.util.Scanner;
public class In {
public static User getUser(){
User u = new User();
Scanner sc =
new
Scanner(System.in);
System.out.println("请è¾å
¥ç»éå");
u.setLoginname(sc.nextLine());
System.out.println("请è¾å
¥å¯ç ");
u.setLoginpsw(sc.nextLine());
return
u;
}
public static User registerUser(){
User u = new
User();
Scanner sc = new
Scanner(System.in);
System.out.println("请注åç¨æ·åå");
u.setName(sc.nextLine());
System.out.println("请注åç»éå");
u.setLoginname(sc.nextLine());
System.out.println("请注åå¯ç ");
u.setLoginpsw(sc.nextLine());
return
u;
}
}
//ç»éæ¶çæ£æ¥ï¼å¤æç»éååå¯ç æ¯å¦æ£ç¡®ï¼æ£ç¡®åè¿å ç¨æ·å
package ç»éå¤æ;
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("ç»é失败");
}else{
System.out.println("欢è¿"+u.getName()+"ç»é");
}
}
}
//注åçé¢ï¼è¦å¤æ ç»éåæ¯å¦æéå¤ï¼æéå¤å注å失败ãæç¹å°çé®ï¼å·²ç¨æ³¨éæ åºæ¥
package ç»éå¤æ;
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;
//å¤æç»éåæ¯å¦å·²ç»åå¨
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());
//å¤æç»éåæ¯å¦å·²ç»åå¨
s =
conn.createStatement();
rs =
s.executeQuery(sql_ck);
while(rs.next()){//为ä»ä¹ç¨ rs.getString(2)ä¼æ示
æ æçç´¢å¼å¢
if( rs.getString("LOGINNAME").equals(u.getLoginname())
){
System.out.println("ç»éåå·²ç»åå¨ï¼æ³¨å失败");
break;
}else{
pst.executeUpdate();
System.out.println("注åæå");
break;
}
}
}
catch (SQLException e) {
e.printStackTrace();
}finally{
try
{
rs.close();
pst.close();
s.close();
conn.close();
}
catch (SQLException e)
{
e.printStackTrace();
}
}
}
}
//mainçé¢//
//æ°æ®åºä¸è¡¨çç»æå¼è¿æ ·
//name(ç¨æ·åï¼ç¨äºæ¾ç¤º),
//loginname(ç»å½å,å³ç»éæ¶è¾å
¥çID)
//loginpsw(ç»éæ¶è¾å
¥çå¯ç )
package
ç»éå¤æ;
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("\t\tç»é请æ1\t\t注å请æ2");
chos =
sc.nextInt();
switch(chos){
case 1:
Check.checkUser(In.getUser());break;
case 2:
Register.registUser(In.registerUser());break;
default:
System.out.println("请è¾å
¥æ£ç¡®çéæ©");break;
}
}
}
温馨提示:内容为网友见解,仅供参考