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

来源：互联网发布：淘宝卖家如何申诉编辑：程序博客网时间：2024/05/16 15:17
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;}}
0 0