Java 课下练习题 T5

1. 实现QQ的登录界面，登录成功后跳转到一个JFrame

package test5;
import java.sql.Connection;  
import java.sql.DriverManager;  
import java.sql.PreparedStatement;  
import java.sql.ResultSet;  
import java.sql.SQLException; 
public class test5b {
    public static void checkUser(test5d 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 = "123456"; 
        Connection conn = null;  
        ResultSet rs = null;  
        PreparedStatement pst = null;  
     
        String sql = "Select name from 'USER' 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 test5;

import java.util.Scanner;

public class test5c {
	  public static test5d getUser(){  
		  test5d u = new test5d();  
          @SuppressWarnings("resource")
		Scanner sc = new Scanner(System.in);  
          System.out.println("请输入登陆名");  
          u.setLoginname(sc.nextLine());  
          System.out.println("请输入密码");  
          u.setLoginpsw(sc.nextLine());  
          return  u;  
      }  
      public static test5d registerUser(){  
    	  test5d u = new test5d();  
          @SuppressWarnings("resource")
		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 test5;

public class test5d {
    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 test5;
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 test5e {
	 public static void registUser(test5d 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 = "123456";  
         Connection conn = null;  
         String sql = "Insert Into USERINFO values(?,?,?)";  
         PreparedStatement pst = null;  
         Statement s = null;  
         ResultSet rs = null;  
         String sql_ck = "Select LOGINNAME FROM 'USER'";  
         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()){
                 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();  
             }  
         }  
           
           
     }  
}

package test5;

import java.util.Scanner;

public class test5f {
	 public static void main(String[] args) {  
		  
	        int chos = 0;  
	        @SuppressWarnings("resource")
			Scanner sc = new Scanner(System.in);  
	        System.out.println("\t\t登陆请按1\t\t注册请按2");  
	        chos = sc.nextInt();  
	        switch(chos){  
	        case 1: test5b.checkUser(test5c.getUser());break;  
	        case 2: test5e.registUser(test5c.registerUser());break;  
	        default: System.out.println("请输入正确的选择");break;  
	        }  
}
}