updata.java

用java编写的对数据库

package project;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;
import java.util.LinkedList;
import java.util.List;

public class Updata 
{   BufferedReader b=new BufferedReader(new InputStreamReader(System.in)); //生成字符输入流
    Oracle Ora=new Oracle();                                               //创建Oracle对象

    public void insert()                                                   //数据的添加方法

     {
		try {
				System.out.println("请输入你要输入人员的个数");
				int a = Integer.parseInt( b.readLine());
				
				for(int i=0;i<a;i++)
				{   
//					List p=new LinkedList();                              //定义一个容器
					System.out.println("请输入姓名:");
					String name=b.readLine();
					System.out.println("请输入性别:");
					String  sex=b.readLine();
					while(true)
					{
						String sex1="男";
					    String sex2= "女";
					    if(sex.equals(sex1)||sex.equals(sex2))
					    {
					    	break;
					    }
					    else
					    {
					    System.out.println("性别只能是男或女");
					    sex1 = b.readLine();
					    sex=sex1;						
				     }
					}
					System.out.println("请输入Id:");
					String Id=b.readLine();
					System.out.println("请输入年龄:");
					int    age,salary;
					while(true)
					{   
						try
						{
					         Integer age1=new Integer (b.readLine());
					         age=age1;
					         if(age<0||age>100)
								{
									System.out.println("年龄只能在0-100之间，请重新输入年龄");						
								}
					         else break;
						}
						catch (NumberFormatException e)
						{
							System.out.print("只能输入数字！！！");							
						}
					}					
					System.out.println("请输入薪水:");
					while(true)
					{  
						try
						{
						   Integer salary1=new Integer (b.readLine());
						   salary=salary1;
						   break;
						}
						catch (NumberFormatException e)
						{
							System.out.print("只能输入数字！！！");							
						}
					}
					Emploeer r=new Emploeer(name,sex,Id,age,salary);     //定义职工类       mmmm                              
//				    p.add(r);                                            //职工对象类放入集合里
				    System.out.println(r.toString());                    //输出字符串
//					Ora.inser(name, sex, Id, age, salary);                //调用Oracle中的对数据的添加方法
				}
			} 
			catch (NumberFormatException e) 
			{
				// TODO Auto-generated catch block
				e.printStackTrace();
			} 
			catch (IOException e) 
			{
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
      }
	 
    public void  updata()                                             //数据更改方法
		{
		  	
				try 
				{
					    System.out.println("请输入您行更改的Id");
				  	    String id=b.readLine();
					    System.out.println("请输入您要更改的姓名:");	
						String name=b.readLine();
						System.out.println("请输入您要更改的性别:");
						String sex=b.readLine();
						while(true)
						{
							String sex1="男";
						    String sex2= "女";
						    if(sex.equals(sex1)||sex.equals(sex2))
						    {
						    	break;
						    }
						    else
						    {
						    System.out.println("性别只能是男或女");
						    sex1 = b.readLine();
						    sex=sex1;						
					     }
						}
						System.out.println("请输入您要更改的Id:");
						String Id;
						while(true)
						{
//							Id=b.readLine();
							try
							{  
							    Id=b.readLine();
								Integer id1=new Integer(Id);
//								Id=(String)id1;
								break;
								
							}
							catch (NumberFormatException e)
							{
								System.out.println("只能输入数字！！！");	
								System.out.println("请输入您要更改的Id:");
//							    String	id1=b.readLine();
//							    Id=id1;
							}
						}
						System.out.println("请输入您要更改的年龄:");
						int    age,salary;
						while(true)
						{   
							try
							{
						         Integer age1=new Integer (b.readLine());
						         age=age1;
						         if(age<0||age>100)
									{
										System.out.println("年龄只能在0-100之间，请重新输入年龄");						
									}
						         else break;
							}
							catch (NumberFormatException e)
							{
								System.out.print("只能输入数字！！！");							
							}
						}					
						System.out.println("请输入您要更改的薪水:");
						while(true)
						{  
							try
							{
							   Integer salary1=new Integer (b.readLine());
							   salary=salary1;
							   break;
							}
							catch (NumberFormatException e)
							{
								System.out.print("只能输入数字！！！");							
							}
						}
//						Ora.updata(id,name, sex, , age, salary);            //调用Oracle中的数据更改方法
				} catch (IOException e) 
				{
					
					e.printStackTrace();
				}
		} 
public void deletedata()                                                   //数据删除方法        
{
	System.out.println("请输入您想删除行的Id:");
	String id;
	try 
	{
		id = b.readLine();
		Ora.delete(id);                                                 //调用Oracle类中的数据删除方法
	} catch (IOException e) 
	{
		
		e.printStackTrace();
	}
	
	
}
public void selectdata()                                              //数据查询方法
{
	System.out.println("请输入您想查找行的Id:");
	try 
	{
		String id=b.readLine();
		Ora.select(id);                                              //调用Oracle中的数据查询方法
	} catch (IOException e) 
	{
		e.printStackTrace();
	}
}
}