用户管理系统cmd版

最新推荐文章于 2024-02-21 16:08:59 发布
最新推荐文章于 2024-02-21 16:08:59 发布
阅读量795 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zzuzys8/article/details/8707174
版权

 

 

1.用户登录

    1.1提示输入用户名和密码。

    1.2如果登录成功，显示主窗体+显示权限。

       1.2.1查询信息(权限：1.普通用户：查询自己信息；2.管理员：按用户名模糊查询；)

       1.2.2修改信息(权限：1.普通用户：修改自己信息；2.管理员：按用户名模糊查询后修改查询出的结果信息；)

    1.3如果失败，显示用户名或密码错误，并显示1。

    1.4退出程序

2.用户注册(*用户注册只能注册普通权限，管理员权限由管理员来赋予)

    2.1用户注册界面显示，提示输入用户名，密码，邮箱。

       2.1.1用户名，密码，邮箱的check。

           2.1.1.1检查成功，登录数据库，提示成功信息，并显示1.1

           2.1.1.2检查失败，给出错误信息，并显示2.1

    2.2退出程序

3.退出程序

 

 

 

 

 

-- Create table

create table USERINFO

(

  name     VARCHAR2(20),

  password VARCHAR2(20),

  email    VARCHAR2(20),

  power    NUMBER default 0

)

tablespace USERS

  pctfree 10

  initrans 1

  maxtrans 255

  storage

  (

    initial 64

    minextents 1

    maxextents unlimited

  )

 

--系统超级管理员

insert into userinfo values(

    zhang,

    123456,

    zys@163.com,

    1

 

 

)

 

 

 

;

 

 

 

 

Index.java                                                      

 

 

package com.zys.web;

//本类为系统入口

publicclass Index {

publicstaticvoid main(String[] args) {

    Home.show();         //本系统主页

}

}

 

 

 

 

 

 

 

 

 

Home.java

 

package com.zys.web;

 

import java.util.Scanner;

 

import com.zys.service.Service;

 

public class Home {

              //获取控制台输入权

        

               static Service service=new Service();

             

              public static void show(){

                     //用户管理系统主页面

                     System.out.println("=================欢迎进入用户管理系统=================");

                     System.out.println("请选择要操作的类型，输入对应的数字：");

                     System.out.println("1.用户登录");

                     System.out.println("2.用户注册");

                     System.out.println("3.退出程序");

                     System.out.println("=====================================================");

                     Scanner in=new Scanner(System.in);

                     try{

                     int i=in.nextInt();    //获取操作数1,2,3；并处理。

                     switch (i) {

                     case 1:

                            service.login();          //调用service的login方法进行登录界面

                            break;

                     case 2:

                            service.addUser();       //调用service的addUser方法添加用户界面

                            break;

                     case 3:

                            System.exit(0);

                            break;

                     default:

                            System.err.println("输入错误！请按提示输入！");

                            try {

                                   Thread.sleep(500);

                            } catch (InterruptedException e1) {

                                   e1.printStackTrace();

                            }

                            show();

                            break;

                     }

                     }catch(Exception e){

                            System.err.println("输入错误！请按提示输入！");

                            try {

                                   Thread.sleep(500);

                            } catch (InterruptedException e1) {

                                   e1.printStackTrace();

                            }

                            show();

                           

                     }

              }

}

 

 

 

 

 

 

 

 

 

AlterService.java

 

 

package com.zys.service;

 

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Scanner;

 

import com.zys.Dao.JdbcOracle;

 

public class AlterService {

//修改用户名

                            public static void alterName(String name ){

                                   //连接数据库

                                   Connection con=JdbcOracle.connect();

                                   Statement st=null;

                                   ResultSet rs=null;

                                  

                                   System.out.println("你要修改 "+name+" 的用户名！");

                                   System.out.println("输入新的姓名，回车结束：");

                                   Scanner in=new Scanner(System.in); //获取输入的新姓名

                                   String newname=in.next();

                                   boolean flag=false;

                                   try {

                                          st=con.createStatement();

                                                 //检查用户名合法性

                                          String sql="select * from userinfo where name='"+newname+"'";

                                          rs=st.executeQuery(sql);

                                          if(rs.next()){      //验证用户名是否存在

                                                         System.err.println("用户名已存在！");

                                                               alterName(name);

                                           }

                                          if(newname.length()<20){      //用户名检查

                                                 for(int j=0 ; j<newname.length(); j++){

                                                        if(newname.charAt(j)>='a'&&newname.charAt(j)<='z'||newname.charAt(j)>='A'&&newname.charAt(j)<='Z'){

                                                               flag=true;

                                                        }else{

                                                               System.err.println("用户名包含了非字母元素！");

                                                               alterName(name);

                                                               break;

                                                        }

                                                 }

                                          }else{

                                                 System.err.println("用户名过长，大于20个字母！");

                                                 alterName(name);

                                          }

                                  

                                                 //合法后操作

                                          if(flag){

                                                 String sql1="update userinfo  set name='"+newname+"'"+"where name='"+name+"'";

                                                 st.executeUpdate(sql1);

                                          }

                                  

                                         

                                          st.close();

                                          con.close();

                                          DbService.select(newname);

                                         

                                   } catch (SQLException e) {

                                         

                                          e.printStackTrace();

                                   }

                                  

                            }

//修改密码

                            public static void alterPassword(String name,String password ){

                                   Connection con=JdbcOracle.connect();

                                   Statement st=null;

                                  

                                   System.out.println("你要修改 "+name+" 的密码！");

                                   System.out.println("输入新的密码，回车结束：");

                                   Scanner in=new Scanner(System.in); //获取输入的新密码

                                   String newpassword=in.next();

                                   boolean flag=false;

                                   try {

                                          st=con.createStatement();

                                          if(newpassword.length()<20){       //密码检查

                                                 for(int k=0 ; k<newpassword.length();k++){

                                                        if(newpassword.charAt(k)>=48&&newpassword.charAt(k)<=57){

                                                               flag=true;

                                                        }else{

                                                               System.err.println("密码包含非数字元素！");

                                                               alterPassword(name, password);

                                                               break;

                                                        }

                                                 }

                                          }else{

                                                 System.err.println("密码长度大于20！");

                                                 alterName(name);

                                          }

                                         

                                                 //合法后操作

                                          if(flag){

                                                 String sql1="update userinfo  set password='"+newpassword+"'"+" where name='"+name+"'";

                                                

                                                 st.executeUpdate(sql1);

                                                

                                          }

                                          st.close();

                                          con.close();

                                          DbService.select(name);

                                         

                                   } catch (SQLException e) {

                                         

                                          e.printStackTrace();

                                   }

                                                              

                     }

//修改邮箱

                            public static void alterEmail(String name ,String email ){

                                   Connection con=JdbcOracle.connect();

                                   Statement st=null;

                                   ResultSet rs=null;

                                  

                                   System.out.println("你要修改 "+name+" 的邮箱！");

                                   System.out.println("输入你的邮箱，回车结束：");

                                   Scanner in=new Scanner(System.in); //获取输入的新密码

                                   String newemail=in.next();

                                   boolean flag=false;

                                   try {

                                          st=con.createStatement();

                                           if(newemail.matches("\\w+([-+.]\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*"))

                                           {

                                           flag=true;

                                           }

                                           else

                                           {

                                                  System.err.println("邮箱不合法！");

                                                  relax();

                                                 alterEmail(name, email);

                                           }

                                  

                                                 //合法后操作

                                          if(flag){

                                                 String sql1="update userinfo  set email='"+newemail+"'"+"where name='"+name+"'";

                                                 st.executeUpdate(sql1);

                                          }

                                          st.close();

                                          con.close();

                                          DbService.select(name);

                                         

                                   } catch (SQLException e) {

                                         

                                          e.printStackTrace();

                                   }

                                                

                            }

                           

                           

                           

//休眠

                            public static void relax(){

                                          try {

                                                 Thread.sleep(500);

                                          } catch (InterruptedException e) {

                                                 // TODO Auto-generated catch block

                                                 e.printStackTrace();

                                          }

                            }

}

 

 

 

 

 

DbService.java

 

 

package com.zys.service;

 

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Scanner;

 

import com.zys.Dao.JdbcOracle;

 

public class DbService {

       /*此类包含有登录检查，注册检查即插入，查询全部，模糊查询，修改权限，

        * 删除操作

        * */

      

       //登录检查

       public static void loginCheck(String name , String password){

             

                                   //进行数据库连接

                                   Connection con=JdbcOracle.connect();

                                   Statement st=null;

                                   ResultSet rs=null;

                                   String sql="select * from userinfo where name='"+name+"'";

                                   try {

                                          st=con.createStatement();

                                          rs=st.executeQuery(sql);

                                          if(!rs.next()){      //验证用户名是否存在

                                                         System.err.println("查无此人！");//登录失败，返回登陆页面

                                                               Service.login();

                                           }else{   

                                                       String nam=rs.getString("name");

                                                       String pwd=rs.getString("password");   //获取密码与权限，备用（登陆成功后使用）。

                                                        int pow=rs.getInt("power"); 

                                                    //验证用户名与密码是否一致

                                                

                                                                if(pwd.equals(password)){

                                                                       System.out.println("登录成功！");

                                                                             loginSuccess(nam, pwd, pow);

                                                                       }else{

                                                                       System.err.println("登录失败！密码错误！");//登录失败，返回登陆页面

                                                                       Service.login();

                                                                       }

                                                       

                                     }

                                         

                                                        rs.close();

                                                        st.close();

                                                        con.close();

                                   } catch (SQLException e) {

                                          // TODO Auto-generated catch block

                                          e.printStackTrace();

                                   }

                                  

                                  

       }

      

       //注册检查

       public static void addCheck(String name, String password, String email ,int power) {

                                   // 合法性检测   是否重复？

                                   Connection con=JdbcOracle.connect();

                                  

                                   Statement st=null;

                                  

                                   String sql="select * from userinfo where name='"+name+"'";  //检查用户名是否重复

                                   boolean mark=true;

                                   try {

                                          st=con.createStatement();

                                          int i=st.executeUpdate(sql);

                                          if(i>0){

                                                 System.err.println("用户已存在，请重新注册！");

                                                 mark=false;

                                                 Service.addUser();

                                          }

                                          //关闭数据库

                                          st.close();

                                          con.close();

                                         

                                          //检查合法性

                                          if(name.length()<20){      //用户名检查

                                                 for(int j=0 ; j<name.length(); j++){

                                                        if(name.charAt(j)>='a'&&name.charAt(j)<='z'||name.charAt(j)>='A'&&name.charAt(j)<='Z'){

                                                               //System.out.println("用户名合法！");

                                                        }else{

                                                               System.err.println("用户名包含了非字母元素！");

                                                               mark=false;

                                                               Service.addUser();

                                                               break;

                                                        }

                                                 }

                                          }else{

                                                 System.err.println("用户名过长，大于20个字母！");

                                                 mark=false;

                                                 Service.addUser();

                                          }

                                          if(password.length()<20){       //密码检查

                                                 for(int k=0 ; k<password.length();k++){

                                                        if(password.charAt(k)>=48&&password.charAt(k)<=57){

                                                               //System.out.println("密码合法");

                                                        }else{

                                                               System.err.println("密码包含非数字元素！");

                                                               mark=false;

                                                               Service.addUser();

                                                               break;

                                                        }

                                                 }

                                          }else{

                                                 System.err.println("密码长度大于20！");

                                                 mark=false;

                                                 Service.addUser();

                                          }

                                                 //邮箱检查

                    

                                           if(email.matches("\\w+([-+.]\\w+)*@\\w+([-.]\\w+)*\\.\\w+([-.]\\w+)*"))

                                           {

                                           ///System.out.println("邮箱合法！");

                                           }

                                           else

                                           {

                                                  System.err.println("邮箱不合法！");

                                                  mark=false;

                                                  Service.addUser();

                                           }

                                          //权限检查

                                          if(power==0){         

                                                 //System.out.println("权限合法！");

                                          }else{

                                                 System.err.println("权限非法，请输入0！");

                                                 mark=false;

                                                 Service.addUser();

                                          }

                                         

                                          if(mark){

                                                 System.out.println("恭喜注册成功！跳入登录页面中...");

                                                 //调用数据插入方法

                                                 add(name,password , email , power);

                                                 //跳转到用户登录页面

                                                 Service.login();

                                          }else{

                                                 System.err.println("信息有误不可入库！");

                                          }

                                         

                                   } catch (SQLException e) {

                                          e.printStackTrace();

                                   }

                                  

       }

       //    添加用户信息到数据库

       public static void add(String name, String password, String email ,int power){

                                   //连接数据库

                                   Connection con=JdbcOracle.connect();

                                   Statement st=null;

                                  

                                   String sql="insert into userinfo values('"+name+"','"+password+"','"+email+"',"+power+")";

                                   try {

                                          st=con.createStatement();

                                          st.executeUpdate(sql);

                                         

                                          st.close();

                                          con.close();

                                   } catch (SQLException e) {

                                          System.out.println("插入数据失败！");

                                   }

       }

      

       public static void loginSuccess(String name ,String password ,int power){

                                   //普通用户

                                   if(power<1){

                                          Service.normalSuccess(name,power);

                                   }

                                   //管理员登录

                                   if(power>0){

                                          Service.managerSuccess(name,power);

                                   }

       }

       //查询个人信息

       public static void select(String name){

                                   //连接数据库

                                   Connection con=JdbcOracle.connect();

                                   Statement st=null;

                                   ResultSet rs=null;

                                   String sql="select * from userinfo where name='"+name+"'";

                                   try {

                                          st=con.createStatement();

                                          rs=st.executeQuery(sql);

                                          while(rs.next()){

                                                 int i=rs.getInt("power");

                                                 System.out.println("name: "+rs.getString("name")+"\tpassword: "+rs.getString("password")+"\temail: "

                                                               +rs.getString("email")+"\tpower: "+i);

                                                 if(i==1){

                                                 Service.managerSuccess(name, i);

                                                 }if(i==0){

                                                        Service.normalSuccess(name, i);

                                                 }

                                          }

                                         

                                          st.close();

                                          rs.close();

                                          con.close();

                                         

                                   } catch (SQLException e) {

                                          System.err.println("查询个人数据失败！");

                                   }

       }

       //查询全部数据

       public static void selectAll(String name ,int power){

                                   //连接数据库

                                   Connection con=JdbcOracle.connect();

                                   Statement st=null;

                                   ResultSet rs=null;

                                   String sql="select * from userinfo ";

                                   try {

                                          st=con.createStatement();

                                          rs=st.executeQuery(sql);

                                          while(rs.next()){

                                                 System.out.println("name: "+rs.getString("name")+"\tpassword: "+rs.getString("password")+"\temail: "

                                                               +rs.getString("email")+"\tpower: "+rs.getInt("power"));

                                          }

                                         

                                          st.close();

                                          rs.close();

                                          con.close();

                                          Service.managerSuccess(name ,power);

                                   } catch (SQLException e) {

                                          System.err.println("查询全部数据失败！");

                                   }

       }

      

       //按姓名模糊查询

       public static void selectByName(String name ,int power){

                                   //连接数据库

                                   Connection con=JdbcOracle.connect();

                                   Statement st=null;

                                   ResultSet rs=null;

                                   Scanner in=new Scanner(System.in); //获取输入的模糊姓名

                                   System.out.println("请输入用户名的全部或部分，回车确认：");

                                   String nam=in.next();

                                   String sql="select * from userinfo where name like '%"+nam+"%'";

                                   System.out.println("如果无匹配项则不显示！");

                                   try {

                                          st=con.createStatement();

                                          rs=st.executeQuery(sql);

//                                        if(!rs.next()){      //判断是否存在

//                                               System.out.println("查无此人！");

//                                        }else{

                                  

                                            while(rs.next()){  //存在即输出

                                         

                                                 System.out.println("name: "+rs.getString("name")+"\tpassword: "+rs.getString("password")+"\temail: "

                                                               +rs.getString("email")+"\tpower: "+rs.getInt("power"));

                                                  

                                            }

//                                        }

                                          st.close();

                                          rs.close();

                                          con.close();

                                          Service.managerSuccess(name, power);

                                   } catch (SQLException e) {

                                          System.err.println("模糊查询失败！");

                                   }

}

       //修改用户数据

       public static void update(String name ){

                                   //连接数据库

                                   Connection con=JdbcOracle.connect();

                                   Statement st=null;

                                   ResultSet rs=null;

                                   Scanner in=new Scanner(System.in); //获取输入的姓名

                                   System.out.println("当前用户为："+name);

                                  

                                   System.out.println("请输入要修改的用户名，回车确认：");

                                   String nam=in.next();

                                   String man="zhang";

                                   if(nam.equals(man)){

                                         

                                          System.err.println("身份为系统总管理员，信息不可修改！");

                                          try {

                                                 Thread.sleep(500);

                                   } catch (InterruptedException e1) {

                                                 e1.printStackTrace();

                                          }

                                          update(name);

                                   }else{

                                          alterUser(nam);

                                   }

                                  

       }

      

      

       //修改个人信息

       public static void alterUser(String name){

                                   System.out.println("=================欢迎进入信息修改页面=================");

                                   System.out.println("当前用户为："+name);

                                   System.out.println("请按页面提示进行操作：");

                                   System.out.println("1.修改用户名");

                                   System.out.println("2.修改密码");

                                   System.out.println("3.修改邮箱");

                                   System.out.println("4.退出系统");

                                   Connection con=JdbcOracle.connect();

                                   Statement st=null;

                                   ResultSet rs=null;

                                   String sql="select * from userinfo where name='"+name+"'";

                                   Scanner in=new Scanner(System.in); //获取输入权

                                  

                                   try {

                                          st=con.createStatement();

                                          rs=st.executeQuery(sql);

                                          rs.next();

                                          String nam=rs.getString("name");

                                          String paw=rs.getString("password");

                                          String ema=rs.getString("email");

                                          try{

                                          int i =in.nextInt();

                                          switch (i) {

                                          case 1:

                                                 AlterService.alterName(nam);

                                                 break;

                                          case 2:

                                                 AlterService.alterPassword(nam, paw);

                                                 break;

                                          case 3:

                                                 AlterService.alterEmail(nam, ema);      

                                                 break;

                                          case 4:

                                                        System.exit(0);     

                                                 break;

                                          default:

                                                 System.out.println("输入非法，请按提示操作！");

                                                 AlterService.relax();

                                                 alterUser(nam);

                                                 break;

                                          }

                                          }catch(Exception e){

                                                 System.out.println("输入非法，请按提示操作！");

                                                 AlterService.relax();

                                                 alterUser(nam);

                                          }

                                          rs.close();

                                          st.close();

                                          con.close();

                                   } catch (SQLException e) {

                                          // TODO Auto-generated catch block

                                          e.printStackTrace();

                                   }

       }

      

      

      

      

      

      

      

      

      

      

      

      

      

      

       //修改权限

       public static void changePower(String name , int power){

                                   Connection con=JdbcOracle.connect();

                                   Statement st=null;

                                  

                                   Scanner in=new Scanner(System.in); //获取输入的权限值

                                   System.out.println("当前用户为："+name+"\t权限为"+power+"\t（0为无权限1为有权限）");

                                  

                                   try {

                                          System.out.println("输入被赋权的用户名，回车确认：");

                                          String na=in.next();

                                          System.out.println("输入新的权限值，回车确认：");

                                          int i=in.nextInt();

                                          String sql1="select * from userinfo where name='"+na+"'";

                                          st=con.createStatement();

                                          int ch=st.executeUpdate(sql1);

                                          if(ch==0){

                                                 System.err.println("用户不存在，请重新赋权！");

                                                 Service.managerSuccess(name, power);

                                          }else{

                                          String sql="update userinfo set power="+i+" where name='"+na+"'";

                                          System.out.println(sql);

                                         

                                          st.executeUpdate(sql);

                                          selectAll(name ,power);

                                          Service.managerSuccess(name, power);

                                          st.close();

                                          con.close();

                                          }

                                   } catch (Exception e) {

                                          System.out.println("该用户不存在！");

                                          Service.managerSuccess(name, power);

                                   }

       }

      

}

 

 

 

 

 

Service.java

 

 

package com.zys.service;

 

import java.util.Scanner;

 

publicclass Service {

 

       //用户登录

       publicstaticvoid login(){

           Scanner in=new Scanner(System.in); //获取输入权

           //用户登录主页面

              System.out.println("=================欢迎进入用户登录信息输入页面=================");

              System.out.println("请按页面提示进行操作：");

              System.out.println("输入2退出程序！");

              System.out.println("请输入用户名，回车确认：");

              String name=in.next();

              System.out.println("请输入密码，回车确认：");

              String password=in.next();

             

              DbService.loginCheck(name, password); 

             

              System.out.println("=====================================================");

              //获取用户名和密码，进行数据库匹配检查；

           System.out.println("请输入2退出...");  

           try{int i=in.nextInt(); //获取操作数2 ；并处理

           switch (i) {

              case 2:

              System.exit(0);         //退出程序

                  break;

              default:

                  break;

              }

           }catch(Exception e){

              System.out.println("输入非法！");

              Service.login();

           }

             

       }

      

       //用户注册

       publicstaticvoid addUser(){

           //用户注册主页面

           System.out.println("=================欢迎进入用户注册页面=================");

           System.out.println("请按页面提示进行操作：");

           System.out.println("输入2退出程序！");

           System.out.println("请输入用户名，回车确认：");

           Scanner in=new Scanner(System.in); //获取输入权

           String name=in.next();

           System.out.println("请输入密码，回车确认：");

           String password=in.next();

           System.out.println("请输入邮箱，回车确认：");

           String email=in.next();

           System.out.println("请输入0，回车确认：");

           int power=in.nextInt();

           //获取用户名，密码，邮箱进行合法性检查；

           DbService.addCheck(name, password ,email,power);

           System.out.println("=====================================================");

           try{int i=in.nextInt(); //获取操作数2 ；并处理

           switch (i) {

           case 2:

              System.exit(0);         //退出程序

              break;

           default:

              break;

           }

           }catch(Exception  e){

              System.out.println("输入非法！");

              Service.addUser();

           }

       }

       publicstaticvoid normalSuccess(String name,int power){

           //普通用户登陆成功页面

           System.out.println("=================欢迎进入登录成功页面=================");

           System.out.println("当前用户为："+name+"\t权限为"+power+"\t（0为无权限1为有权限）");

           System.out.println("请按页面提示进行操作：");

           System.out.println("1.查询个人信息");

           System.out.println("2.修改个人信息");

           System.out.println("3.退出系统");

           Scanner in=new Scanner(System.in); //获取输入权

           try {

              int i=in.nextInt();

              switch (i) {

              case 1:

                  DbService.select(name);

                  break;

              case 2:

             

                  DbService.alterUser(name);

                  break;

              case 3:

                  System.exit(0);

                  break;

              default:

                  break;

              }

           } catch (Exception e) {

              System.err.println("请按提示操作！！！");

              normalSuccess(name,power);

           }

          

          

       }

       publicstaticvoid managerSuccess(String name ,int power){

           //管理员登陆成功页面

           System.out.println("=================欢迎进入登录成功页面=================");

           System.out.println("当前用户为："+name+"\t权限为"+power+"\t（0为无权限1为有权限）");

           System.out.println("请按页面提示进行操作：");

           System.out.println("1.查询个人信息");

           System.out.println("2.修改个人信息");

           System.out.println("3.查询全部信息");

           System.out.println("4.按姓名模糊查询");

           System.out.println("5.人工赋权");

           System.out.println("6.修改用户信息");

           System.out.println("7.输入值大于6退出系统");

           Scanner in=new Scanner(System.in); //获取输入权

           try {

              int i=in.nextInt();

              switch (i) {

              case 1:

                  DbService.select(name);

                  break;

              case 2:

                 

                  DbService.alterUser(name);

                  break;

              case 3:

                  DbService.selectAll(name,power);

                  break;

              case 4:

                  DbService.selectByName(name ,power);

                  break;

              case 5:

                  DbService.changePower(name, power);

                  break;

              case 6:                                   

                  DbService.update(name);

                  break;

              case 7:

                  System.exit(0);

                  break;

              default:

                  System.exit(0);

                  break;

              }

           } catch (Exception e) {

              System.err.println("操作非法，强制退出，请按提示操作！！！");

              try {

                  Thread.sleep(500);

              } catch (InterruptedException e1) {

                  e1.printStackTrace();

              }

              Service.login();

           }

          

       }

      

      

      

}

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

JdbcOracle.java

 

 

 

 

package com.zys.Dao;

 

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

 

public class JdbcOracle {

 

    /**

     * 进行数据库的连接操作

     */

    public static Connection connect() {

       String dirver="oracle.jdbc.driver.OracleDriver";

       String url="jdbc:oracle:thin:@10.1.232.21:1521:ORACLE";

       String user="scott";

       String password="scott";

      

       Connection con=null;

      

 

       //1.添加外部JAR文件，在构建路径-->配置构建路径选项添加Oracle提供的class12.jar文件

       //2.加载驱动程序

       try {

           Class.forName(dirver);

           //System.out.println("驱动加载成功！");

       } catch (ClassNotFoundException e) {

           //System.err.println("加载驱动异常！");

           e.printStackTrace();

       }

       //3.建立数据库连接

       try {

           con=DriverManager.getConnection(url, user, password);

          

       } catch (SQLException e) {

          

           e.printStackTrace();

       }

 

      

       return con;

    }

 

}

 

 

 

 

 

 

 

zzuzys8
关注
设备管理系统（cmd版）
05-12
一个完整java的项目。cmd版的。希望大家支持！
基于Extjs6.2的用户管理系统.md
06-24
用extjs框架与go的iris框架进行搭建的一个基础性用户管理系统。 本次的侧重点主要放在Extjs框架的搭建 实现功能： 1.用户登录退出 2.用户信息管理模块 运用extjs框架很好的呈现用户信息，实现分页排序等功能 3....
Windows 命令提示符（CMD）操作（三）：用户管理
Flag少侠的博客
02-20 1347
管理用户帐户，如创建、删除用户[username][options]/domain/add/delete这将创建一个名为 "user1" 的用户，并将密码设置为 "password123"。
Windows 用户管理 CMD 命令
一直被模仿，从未被超越
10-23 1万+
Windows 用户管理 CMD 命令
Windows：通过指令进行用户管理
mini小新的博客
01-20 2534
在很多场景下，通过Windows图形界面管理用户相对较为繁琐，因此可以通过使用cmd指令来简化管理步骤。
Windows系统cmd创建用户，并将用户加入管理员组
weixin_73134956的博客
02-21 7373
注意：要运行这些命令，您需要以管理员身份运行命令提示符。请确保以管理员身份登录或右键单击命令提示符图标并选择“以管理员身份运行”。请谨慎操作管理员权限，以确保系统安全。请将`<用户名>`替换为您想要创建的新用户的用户名，将`<密码>`替换为您想要设置的密码。1. 打开命令提示符（按下Win+R键，输入cmd，然后按下Enter键）。4. 执行完上述命令后，会显示成功创建用户并添加到管理员组。请将`<用户名>`替换为刚刚创建的新用户的用户名。net user <用户名> <密码> /add。
CC++语言-图书馆信息管理系统基于CMD自研GUI版.zip
最新发布
03-11
本文将深入探讨一个基于CMD（命令行界面）的GUI（图形用户界面）版图书馆信息管理系统，该系统由C++语言开发，旨在提供高效、便捷的图书借阅与管理服务。通过该项目实践，我们可以学习到系统分析与设计的方法，以及...
学生信息管理系统(CMD版)
01-16
《学生信息管理系统(CMD版)》是一款初学者利用C语言编写的软件，旨在提供一个简单易用的学生信息管理平台，特别适用于对编程有兴趣并希望通过实践加深理解的学习者。这款系统虽然简洁，但在CMD命令行环境下提供了...
cmd多开管理工具
06-12
在Windows操作系统中，CMD是系统自带的命令行界面，用户可以通过输入命令来执行各种系统操作，如文件管理、系统配置等。然而，当需要同时进行多项命令行操作时，手动打开多个CMD窗口会变得繁琐。这就是"cmd多开管理...
windows11系统，以管理员身份运行cmd
05-31
在Windows操作系统中，命令提示符（Command Prompt，简称cmd）是一个重要的工具，它允许用户通过文本界面执行系统级命令，进行文件管理、系统配置等多种任务。在某些情况下，如安装软件、修改系统设置或者进行故障...
怎么进入命令提示符（cmd）管理员
m0_51078907的博客
04-18 1万+
3、ctrl+shift+Enter键，弹出用户账户控制框（有的不会弹），点击“是” ，就进入了管理员模式的命令提示符（cmd）2、输入的命令是：runas /noprofile /user:Administrator。账号密码的，很多人没往这方面设置。2、输入cmd（输入后就别动了）注意：一般来说，很多电脑都是没有。
win10 用户设置cmd 管理员权限
u014212540的博客
11-17 4102
win10 用户设置cmd 管理员权限
Windows本地用户和组的管理
十七拾的博客
11-27 4536
文章讲述Windows本地用户和组的管理，如何建立本地用户和组，如何授予它们相关权限，如何重命名本地用户和组等
windows系统，计算机cmd管理员,命令行中普通用户获取管理员权限的命令
质量不太好的博客
01-09 1万+
windows系统，计算机cmd管理员,命令行中普通用户获取管理员权限的命令
cmd简单的信息管理系统，简单的增删改查信息，适合课程设计
CodeV的博客
03-14 339
主要的结构如下： 主要的界面效果： 代码如下： package cn.xiaov.homework; import java.util.ArrayList; import java.util.List; import java.util.Scanner; public class Demo3_Big { public static void main(String[] ar...
CMD命令（添加删除管理员账户）
scimence的专栏
08-20 1万+
CMD命令（添加删除管理员账户）
cmd命令添加用户为管理员
热门推荐
黑锤的博客
08-09 4万+
cmd创建管理员用户： 新建管理员账号： netuser 这是查看用户 添加用户 netuser name password /add 例如：netuser tian 123456 /add 这就添加了一个用户为：tian密码为:123456的用户了 第二步将此用户提升为管理员： net localgroup administrators tian...
如何在CMD下运用管理员权限
秉持Love and share的态度去学习和生活
01-20 2万+
方法一：鼠标右键 这个方法比较比较普通，点开开始找到cmd，右击鼠标“以管理员身份运行（A）”这样调用就是管理员的权限； 方法二：快捷模式 在点开win+R后，选择“以管理员身份运行”，然后确定；可以这还是会调出UAC的提示界面，选择“是”即可； 方法三：纯键盘模式 点开开始，在开始的输入框中输入cmd，这个时候出现cmd的快捷方式，可以采用方法一的方法启用管理员调用，但这里我们不用鼠标，直接按住CTRL+SHIFT+ENTER三个键就可以直接调用管理员权限的cmd了； 方法四：命令模式 我们
CMD中提升帐户到管理员权限
weixin_33972649的博客
09-21 2万+
2019独角兽企业重金招聘Python工程师标准>>> ...
系统管理员必备：八大CMD命令详解及应用
系统管理员在日常管理和维护工作中，掌握基本的命令行工具至关重要。在这个概述中，我们将重点讨论两个重要的cmd命令：ping和nbtstat。 1. **ping命令** - **功能与原理**：ping是用于测试网络连通性和延迟的命令...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值