连接数据库的登录注册退出页面

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;
/**
 * @author ljk
 * @登录注册功能
 */
public class Jdbc_login2 {

	public static void main(String[] args) {
		System.out.println("==============================");
		System.out.println("======欢迎登录305班级管理系统======");
		System.out.println("==============================");
		Scanner scanner=new Scanner(System.in);
		while(true){
			System.out.println("请你选择：1-登录,2-注册,3-退出");
			int num=scanner.nextInt();
			switch (num) {
			case 1:
					login();
				continue;
			case 2:
					resul();
					continue;
			case 3:
				System.out.println("欢迎下次光临！");
				break;
			default:
				System.out.println("你的输入有误，请你重新输入");
				continue;
			}
			break;
		}
	}

	private static boolean resul() {	
		System.out.println("请你输入你的学号");
		Scanner sc=new Scanner(System.in);
		int sno=sc.nextInt();
		System.out.println("请你输入你的姓名");
		String ename=sc.next();
		
		ResultSet resul=null;
		Statement state=null;
		Connection conn=null;
		String dirver="jdbc:oracle:thin:@localhost:1521:orcl";
		String url="bjsxt";
		String pwd="bjsxt";
		//导入jar包
		try {
			//2加载驱动
			Class.forName("oracle.jdbc.driver.OracleDriver");
			//3创建连接
			conn= DriverManager.getConnection(dirver,url,pwd);
			//4创建命令发送器（执行sql语句）
			state=conn.createStatement();
			//5根据命令发送器执行sql语句并接受结果集
			String str="INSERT INTO T_STUDENT (SNO,SNAME) VALUES("+sno+",'"+ename+"')";
			System.out.println(str);
			int count=state.executeUpdate(str);
			if(count >0){
				conn.commit();
				return true;
			}else{
				conn.rollback();
				return false;
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		catch (SQLException e) {
			e.printStackTrace();
		} finally{
			//7关闭资源		
			if(state!=null){
				try {
					state.close();
				} catch (SQLException e) {					
					e.printStackTrace();
				}
			}
			
			if(conn!=null){
				try {
					conn.close();
				} catch (SQLException e) {					
					e.printStackTrace();
				}
			}
		}
		return false;		
	}

	private static boolean login() {
		System.out.println("请你输入你的学号");
		Scanner sc=new Scanner(System.in);
		int sno=sc.nextInt();
		System.out.println("请你输入你的姓名");
		String ename=sc.next();
		
		ResultSet resul=null;
		PreparedStatement pstate=null;
		Connection conn=null;
		String dirver="jdbc:oracle:thin:@localhost:1521:orcl";
		String url="bjsxt";
		String pwd="bjsxt";
		//导入jar包
		try {
			//2加载驱动
			Class.forName("oracle.jdbc.driver.OracleDriver");
			//3创建连接
			conn= DriverManager.getConnection(dirver,url,pwd);
			//4创建命令发送器（执行sql语句）
			String sql="SELECT COUNT(*) FROM T_STUDENT WHERE SNO=? AND SNAME=?";
			pstate=conn.prepareStatement(sql);
			//5根据命令发送器执行sql语句并接受结果集
			pstate.setInt(1, sno);
			pstate.setString(2, ename);
			System.out.println(sql);
			resul=pstate.executeQuery();
			int count=0;
			//6遍历结果
			while(resul.next()){
				count=resul.getInt(1);				
			}
			if(count >0){
				return true;
			}
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		catch (SQLException e) {
			e.printStackTrace();
		} finally{
			//7关闭资源
			if(resul!=null){
				try {
					resul.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			
			if(pstate!=null){
				try {
					pstate.close();
				} catch (SQLException e) {					
					e.printStackTrace();
				}
			}
			
			if(conn!=null){
				try {
					conn.close();
				} catch (SQLException e) {					
					e.printStackTrace();
				}
			}
		}
		return false;
	}

}