zxc.java

学籍管理系统..没有窗口,初步完成的java代码

		String u= reader.nextLine();
      System.out.println("确认修改?输入1继续,输入2取消");
		String yu= reader.nextLine();
           if (yu.equals("1"))
			    {
		 //sqlStr="Insert lx values('"+u+"')";
         sqlStr="update js set "+y+"='"+u+"' where "+y+"='"+t+"'";
         //sqlStr="update cpsm set "+y+"='"+u+"' where "+y+"='"+t+"'";
		
				try             
			{   //这里的异常处理语句是必需的.否则不能通过编译!                      
		Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");                   
//		System.out.println("类实例化成功!");                                      
		Connection con = DriverManager.getConnection(url,user,password);                   
//		System.out.println("创建连接对像成功!");                                      
		Statement st = con.createStatement();                  
//		System.out.println("创建Statement成功!");                                     
//		ResultSet rs = st.executeQuery(sqlStr); //向SQL发送数据命令update                 
//		System.out.println("操作数据表成功!");            
		System.out.println("----------------!"); 
          int rs = st.executeUpdate(sqlStr);

		System.out.println(" "); 
            System.out.println("数据修改成功!");
            System.out.println(" "); 
            st.close();                   
            con.close();
		}                     
        catch(Exception err)
		{                   
        err.printStackTrace(System.out);
        }
	} 
          else 
               continue;
}
	
	else if (a==5)
	{
                System.out.println(" ");
		System.out.println("\t"+"-----退出-----");
		System.out.println(" ");
		break;
	}
	else
    {
	    System.out.println("有错误");
         }
	}break;


       case 4: 
		while(true)
		{
		System.out.println("\t"+"----请选项：----");
                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(" ");
		System.out.print("所选的项是：");
		reader=new Scanner(System.in);
		a=reader.nextInt();
	if (a==1)
	{ 
		 String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=chenjm";           
			String user="ming";//这里替换成你自已的数据库用户名          
		String password="123456";//这里替换成你自已的数据库用户密码           
		String sqlStr="select zhuanye,sname,sex,jibie,xi,kcname from course where name like ? and kk like ?";  

		System.out.println(" ");
		System.out.println("\t"+"-----查询功能:-----");
		System.out.println(" ");
		System.out.print("输入课程编号:"); 
        
		InputStreamReader stdin=new InputStreamReader(System.in);
		BufferedReader br=new BufferedReader(stdin);
		
		String s="";String no="";String name="";String Ccredit="";String kk="";String skjszc="";String kcxz="";
		   try{
		    s=br.readLine();
                   
	
	System.out.print("请输入要查询的课程名:");
	name=br.readLine();
	//System.out.print("请输入要查询的高达图片:");
	//tupian=br.readLine();
	System.out.print("请输入要查询的课程考核方式:");
	kk=br.readLine();
	
		   }catch(IOException e){}

		

		//sqlStr="select bianhao,mingzi,jiage,tupian,xinghao from cpsm where jiage like '%"+jiage+"%' and xinghao like '%"+xinghao+"%'";  
		try             
			{   //这里的异常处理语句是必需的.否则不能通过编译!                      
		Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");                   
//		System.out.println("类实例化成功!");                                      
		Connection con = DriverManager.getConnection(url,user,password);                   
//		System.out.println("创建连接对像成功!");                                      
		PreparedStatement st = con.prepareStatement(sqlStr);             
//		System.out.println("创建Statement成功!");
                st.setString(1,"%"+name+"%"); 
                st.setString(2,"%"+kk+"%");                                    
		ResultSet rs = st.executeQuery(); //向SQL发送数据命令update                 
//		System.out.println("操作数据表成功!");            
		System.out.println("----------------!"); 




		System.out.println("编号\t\t课程名\t\t学分\t\t考核方式\t\t授课老师职称\t\t课程性质"); 
		int numb=0;                         
		while(rs.next()) 
                          {   
                        numb++;                    
			System.out.print(rs.getString("no")+"\t");                       
		        System.out.print(rs.getString("name")+"\t"+"\t");
                        System.out.print(rs.getString("Ccredit")+"\t"+"\t");
                        System.out.print(rs.getString("kk")+"\t");
                        System.out.print(rs.getString("skjszc")+"\t");
                        System.out.print(rs.getString("kcxz")+"\t");       
                        System.out.println("");
                        }   
                         System.out.println("找到"+numb+"个结果");
                         System.out.println("");              
			rs.close();                   
			st.close();                   
			con.close();                     }                     
			catch(Exception err){                   
				err.printStackTrace(System.out);              
				        }              
}
	else if (a==2)
	{
	String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=chenjm";           
        String user="ming";//这里替换成你自已的数据库用户名          
        String password="123456";//这里替换成你自已的数据库用户密码           
        String sqlStr="";  
        System.out.println(" ");
        System.out.println("\t"+"-----添加功能:-----");
        System.out.println(" ");
                 try             
	            {  
					


                    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");                   
                    Connection con = DriverManager.getConnection(url,user,password);                   
                    Statement st = con.createStatement(); 
					

               
                ResultSet rs=null;
				String b="";
				String s="";
				boolean tips=true;


               do{
				 System.out.println("课程编号"); 
                reader=new Scanner(System.in);
                s= reader.nextLine();
                sqlStr="select * from course where no = '"+s+"'";  

                rs = st.executeQuery(sqlStr);                  
                 
			    tips=rs.next();
                        
			    if(tips)
                    System.out.println("没有有这个课程的资料,请再输入");  
				}while(tips);

                                do{
				System.out.println("请输入考核方式");
				b= reader.nextLine();

				sqlStr="select * from course where kk = '"+b+"'";  

                rs = st.executeQuery(sqlStr);                  
                 
			    tips=rs.next();
                        
			    if(!tips)
                    System.out.println("没有这个课程的资料,请再输入");  
				}while(!tips);
					         
	                rs.close();           
                                                
		System.out.print("请输入课程名:");
		String i= reader.nextLine();
		System.out.print("请输入学分:");
		String h= reader.nextLine();
		System.out.print("请输入授课老师职称:");
		String x= reader.nextLine();
                System.out.print("请输入课程性质:");
		String y= reader.nextLine();
		
			 


        sqlStr="Insert cpsm values('"+s+"','"+i+"','"+h+"','"+b+"','"+x+",'"+y+"')";  
          int rsint = st.executeUpdate(sqlStr);
                    
					if (rsint==0)	
						System.out.println("--------添加失败--------!");					   
					else
            System.out.println("--------添加成功--------!"); 
        
            st.close();                   
            con.close();
		}                     
        catch(Exception err)
		{                   
        err.printStackTrace(System.out);              
	}
	}
	else if (a==3)
	{      
               		 		System.out.println(" ");
		System.out.println("\t"+"-----删除功能:-----");
		System.out.println(" ");
                 System.out.print("输入你要删除数据的课程编号:");
                   reader=new Scanner(System.in);
                 String s=reader.nextLine(); 
                System.out.println(" "); 
                System.out.println("您输入的数据是:"+"“"+s+"”");
                
                System.out.println(" ");
                 System.out.println("是否删除该资料:1是;2不是");
                 System.out.println("你的选择:");
                  int d=0;
                 Scanner h=new Scanner(System.in);
                 d=h.nextInt();
                 while(true){
                     if(d==1){
                   
            String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=chenjm";           
			String user="ming";//这里替换成你自已的数据库用户名          
		String password="123456";//这里替换成你自已的数据库用户密码           
		String sqlStr="delete  from course where no like '%"+s+"%'";   
                
                
		try             
		{   //这里的异常处理语句是必需的.否则不能通过编译!                      
		Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");                   
//		System.out.println("类实例化成功!");                                      
		Connection con = DriverManager.getConnection(url,user,password);                   
//		System.out.println("创建连接对像成功!");                                      
		Statement st = con.createStatement();                  
//		System.out.println("创建Statement成功!");                                     
//		ResultSet rs = st.executeQuery(sqlStr); //向SQL发送数据命令update                 

                  int rs = st.executeUpdate(sqlStr);
                 //	System.out.println("操作数据表成功!";break;);            
		System.out.println("----------------!"); 
		System.out.println(" "); 
            System.out.println("数据删除成功!");
            System.out.println(" "); 
            st.close();         
            con.close();
		}                 
        catch(Exception err)
		{                   
        err.printStackTrace(System.out);
        }
	  { System.out.print("你的操作已成功"); break;}    } 
          else if(d==2)
                     { System.out.print("你的操作已取消"); break;}
}
}
	else if (a==4)
	{  String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=chenjm";           
			String user="ming";//这里替换成你自已的数据库用户名          
		String password="123456";//这里替换成你自已的数据库用户密码           
		String sqlStr="select * from student";  

		System.out.println(" ");
		System.out.println("\t"+"-----修改功能:-----");
		System.out.println(" ");
		 System.out.println(" ");
                 System.out.println("是否修改该资料:1是;2不是");
                 System.out.println("你的选择:");
                  int d=0;
                 Scanner h=new Scanner(System.in);
                 d=h.nextInt();
                 while(true){
                     if(d==1){
		InputStreamReader stdin=new InputStreamReader(System.in);
		BufferedReader br=new BufferedReader(stdin);
		
		System.out.print("\n请要修改的课程编号是：");
                 reader=new Scanner(System.in);
                String s= reader.nextLine(); 
		System.out.print("请输入要修改的项目:");

                String y= reader.nextLine();
                 System.out.print("请输入原来的资料:");
		String t= reader.nextLine();
                 System.out.print("请输入要更新的资料:");
		String u= reader.nextLine();
		
		sqlStr="update course set "+y+"='"+u+"' where "+y+"='"+t+"'"; 
		try             
			{   //这里的异常处理语句是必需的.否则不能通过编译!                      
		Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");                   
//		System.out.println("类实例化成功!");                                      
		Connection con = DriverManager.getConnection(url,user,password);                   
//		System.out.println("创建连接对像成功!");                                      
		Statement st = con.createStatement();                  
//		System.out.println("创建Statement成功!");                                     
//		ResultSet rs = st.executeQuery(sqlStr); //向SQL发送数据命令update                 
//		System.out.println("操作数据表成功!");            
		System.out.println("----------------!"); 
                  int rs = st.executeUpdate(sqlStr);



		System.out.println(" "); 
            System.out.println("数据修改成功!");
            System.out.println(" "); 
            st.close();                   
            con.close();
		}                     
        catch(Exception err)
		{                   
        err.printStackTrace(System.out);
        }
	{ System.out.print("你的操作已成功"); break;}    } 
          else if(d==2)
                     { System.out.print("你的操作已取消"); break;}
}
}	
	else if (a==5)
	{
                System.out.println(" ");
		System.out.println("\t"+"-----退出-----");
		System.out.println(" ");
		break;
	}
	else
    {
	    System.out.println("有错误");
	}continue;
}
              

                case 5:
						System.exit(0);
					default:
						System.out.println("出错啦!");
}
}
}
}