连接数据的登录注册退出页面（简化版）

工具类结合JDBC的简化版
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;

import com.bjsxt.utils.BjsxtUtils;
/**
 * @author ljk
 * @登录注册功能
 */
public class Jdbc_login3 {

	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 driver = "oracle.jdbc.driver.OracleDriver";
		String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";
		String uname="bjsxt";
		String pwd="bjsxt";
		//导入jar包
		try {
			//2加载驱动
			Class.forName(driver);
			//3创建连接
			conn= DriverManager.getConnection(uname,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 sname=sc.next();
		
		ResultSet resul=null;
		PreparedStatement pstate=null;
		Connection conn=null;
		
		//导入jar包
		try {
			conn=BjsxtUtils.getcoConnection();
			//4创建命令发送器（执行sql语句）
			String sql="SELECT COUNT(*) FROM T_STUDENT WHERE SNO=? AND SNAME=?";
			pstate=BjsxtUtils.getpPreparedStatement(conn, sql);
			//5根据命令发送器执行sql语句并接受结果集
			pstate.setInt(1, sno);
			pstate.setString(2, sname);
			System.out.println(sql);
			resul=pstate.executeQuery();
			int count=0;
			//6遍历结果
			while(resul.next()){
				count=resul.getInt(1);				
			}
			if(count >0){
				System.out.println("登录成功");
				return true;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally{//关闭资源
			BjsxtUtils.closeAll(resul, pstate, conn);
		}
		return false;	
	}

}
下面为jdbc的工具类
import java.io.IOException;
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.Properties;

/**
 * @author ljk
 * @JDBC工具类
 */
public class BjsxtUtils {

	private static String url;
	private static String dirver;
	private static String uname;
	private static String pwd;
	static{
		//创建properties对象
		Properties pro= new Properties();
		try {
			//将jdbc.properties文件数据加载到当前类中
			pro.load(BjsxtUtils.class.getClassLoader().getResourceAsStream("jdbc.properties"));
			dirver=pro.getProperty("dirver");
			url=pro.getProperty("url");
			uname=pro.getProperty("uname");
			pwd=pro.getProperty("pwd");
			Class.forName(dirver);
			System.out.println(dirver+"======"+url+"=========="+uname+"========="+pwd);
		} catch (IOException e) {
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	/**
	 * @建立连接
	 * @return
	 */
	public static Connection getcoConnection(){
		Connection conn=null;
		//2加载驱动
		try {
			conn= DriverManager.getConnection(url,uname,pwd);
			conn.setAutoCommit(false);
		}catch (SQLException e) {
			e.printStackTrace();
		}
		//3创建连接
		return conn;	
	}
	/**
	 * @param conn
	 * @param sql
	 * @return
	 * @获取命令发送器
	 */
	public static Statement getStatement(Connection conn){
		Statement state=null;
		try {
			state=conn.createStatement();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return state;		
	}
	public static PreparedStatement getpPreparedStatement(Connection conn,String sql){
		PreparedStatement pstate=null;
		try {
			pstate=conn.prepareStatement(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return pstate;
	}
	public static ResultSet getrResultSet(){
		return null;		
	}
	public static void closeAll(ResultSet resul,Statement state,Connection conn){
		if(resul!=null){
			try {
				resul.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}	
		if(state!=null){
			try {
				state.close();
			} catch (SQLException e) {		 			
				e.printStackTrace();
			}
		}
		
		if(conn!=null){
			try {
				conn.close();
			} catch (SQLException e) {					
				e.printStackTrace();
			}
		}
	}
}