paper.java

报刊管理系统java做的

    p1.add(t4);     
     p1.add(l5);//部门地址
     p1.add(t5);    
     p1.add(l6);//部门电话
    p1.add(t6);     
    p1.add(que);//确定
    p1.add(cal);//取消  
    contentPane.add(p1);//将面板p1加入窗体中   
    f.setLocation(400,300); //设置窗体位置
    f.setSize(300,200);    //设置窗体大小      
    	f.show(); //显示窗口       
    	f.addWindowListener(new WindowAdapter() {            
    		public void windowClosing(WindowEvent e) {     	                  
    		   f.dispose();           
    		}        
    	});    

}
 
/////////////////////////////////////////////////////////////////////////////报刊信息录入
public void paperLuru()
{
	
	
	 final JFrame f=new JFrame("报刊信息录入"); 
       Container contentPane=f.getContentPane();
       contentPane.setLayout(new BorderLayout());
       ////////----	   
       JPanel p1=new JPanel();
    p1.setLayout(new GridLayout(6,2));
    p1.setBorder(BorderFactory.createTitledBorder("请输入报刊信息"));
     
      JLabel l1=new JLabel("报刊号");
     final JTextField t1=new JTextField(); 
     
     JLabel l2=new JLabel("报刊名");
     final JTextField t2=new JTextField(); 
     
     JLabel l3=new JLabel("报刊类别");
     final JTextField t3=new JTextField();     	
    
    
     JLabel l4=new JLabel("报刊数量");   
    final JTextField t4=new JTextField(); 
    
     JLabel l5=new JLabel("单价");
     final JTextField t5=new JTextField();   
       
    JButton que=new JButton("确定"); 
    	 
    que.addActionListener(new ActionListener(){
    	public void actionPerformed(ActionEvent ev){    	 
    	if((ev.getActionCommand()).equals("确定"))     	 
           {     
                      dataBase();//链接数据库
              String  Pnumber,pname,pclass,total,price,ss="",tt="";
               
              try {    //执行SQL语句
              	        String que = "select Pnumber from paper"; //接受输入的sql语句
						statement = connection.createStatement(); 
						resultSet = statement.executeQuery( que );
						
                              Pnumber=t1.getText();
                              pname=t2.getText();//
                             pclass =t3.getText(); 
			                total=t4.getText();//
			               price=t5.getText();// 
		              
                    while(resultSet.next())
					 {					       
					    tt= resultSet.getString("Pnumber");
					   	    
				  	     if(Pnumber.equals(tt))//当输入的报刊号与库中的相同
	              	     {               	     	
	              	     		 JFrame ppp=new JFrame("");
						         String title="友情提示";				   	 
						   	 int type=JOptionPane.PLAIN_MESSAGE;
						         type=JOptionPane.INFORMATION_MESSAGE;
						   	   String   message="数据已经存在";
						     JOptionPane.showMessageDialog(f,message,title,type);			
						         ppp.setLocation(400,400);				
						 }
              	     	else
              	     	{
              	     			String ru = "insert into paper values("+Pnumber+",'"+pname+"','"+ pclass+"',"+total+","+price+")";//输入的sql语句
					            statement.executeUpdate( ru );					            
					          JFrame pp=new JFrame("");
					         String title="友情提示";				   	 
					   	 int type=JOptionPane.PLAIN_MESSAGE;
					         type=JOptionPane.INFORMATION_MESSAGE;
					   	   String   message="数据录入成功";
					     JOptionPane.showMessageDialog(f,message,title,type);			
					         pp.setLocation(400,400);				
						     f.dispose();   			
              	     	}
              	  
              }//while end        			       
			      
            } catch ( SQLException sqlex ) {  sqlex.printStackTrace();  }             
           }//if 监听
          }
             
        }); //确定 end              
      JButton cal=new JButton("取消");
      cal.addActionListener(new ActionListener(){
    	public void actionPerformed(ActionEvent ev){
    	if((ev.getActionCommand()).equals("取消"))     	 
              {
              	 f.dispose();
              }
    	}
    });  
    
    p1.add(l1);//报刊号
    p1.add(t1);
    p1.add(l2);//报刊名
    p1.add(t2);
    p1.add(l3);//报刊类别
    p1.add(t3);
    p1.add(l4);//报刊数量
    p1.add(t4);     
    p1.add(l5);//单价
    p1.add(t5);    
     
    p1.add(que);//确定
    p1.add(cal);//取消  
    contentPane.add(p1);//将面板p1加入窗体中   
    f.setLocation(400,300); //设置窗体位置
    f.setSize(300,200);    //设置窗体大小      
    	f.show(); //显示窗口       
    	f.addWindowListener(new WindowAdapter() {            
    		public void windowClosing(WindowEvent e) {     	                  
    			f.dispose();           
    		}        
    	}); 
}

 
////////////////////////////////////////////////////////////////////////////////////////系统模块
  
  
/////////////////////////////////////  登录(0k!)////////////////////////
public void denglu()
{
	 final JFrame f=new JFrame("登录"); 
       Container contentPane=f.getContentPane();
       contentPane.setLayout(new BorderLayout());      
	   //------------------------
    JPanel p1=new JPanel();
    p1.setLayout(new GridLayout(3,2));
    p1.setBorder(BorderFactory.createTitledBorder("会员登陆"));	
     JLabel l1=new JLabel("用户名");
     final JTextField t1=new JTextField();     
     JLabel l2=new JLabel("密码");   
     final JPasswordField t2 = new JPasswordField();   
    JButton que=new JButton("确定");     	 
    que.addActionListener(new ActionListener(){
    	public void actionPerformed(ActionEvent ev){    	 
    	if((ev.getActionCommand()).equals("确定"))     	 
           {
              String user,password,s="",p="";             
              user=t1.getText();
              password=t2.getText();
              dataBase();            
            try { //执行SQL语句 
						String query = "SELECT name,password FROM user1"; //接受输入的sql语句
						statement = connection.createStatement(); 
						resultSet = statement.executeQuery( query );
						boolean ee=true;				
				while(resultSet.next()&&ee)
					 {	 s=resultSet.getString("name");
					     p=resultSet.getString("password");				    
			  	    if(user.equals(s))//当输入的姓名与文件中的相同
              	   {   
              	        ee=false;
	              		if(p.equals(password))//密码也相同              		
	              		{
	              			 JFrame pp=new JFrame("");
					         String title="友情提示";				   	 
					   	 int type=JOptionPane.PLAIN_MESSAGE;
					         type=JOptionPane.INFORMATION_MESSAGE;
					   	   String   message="登录成功！";
					   	 
					     JOptionPane.showMessageDialog(f,message,title,type);			
					         pp.setLocation(400,400);				     
	              		}
	              		else
	              		{
	              			 JFrame pp=new JFrame("");
					      String title="错误提示信息";				   	 
					   	 int type=JOptionPane.PLAIN_MESSAGE;
					      type=JOptionPane.INFORMATION_MESSAGE;
					   	  String   message="密码错误！请重试";
					     JOptionPane.showMessageDialog(f,message,title,type);			
					     pp.setLocation(400,400);				     
					     denglu();					    
	              		}              		
              	   }        
	             
		          }//while 
		              
		              //////////////
		          if(ee){  //没有用户名要求注册              
	                        JFrame pp=new JFrame("");
					      String title="错误提示信息";				   	 
					   	 int type=JOptionPane.PLAIN_MESSAGE;
					      type=JOptionPane.INFORMATION_MESSAGE;
					   	  String   message="用户名不存在，请注册！";
					      JOptionPane.showMessageDialog(f,message,title,type);			
					     pp.setLocation(400,400);                       
	                	regedit();
	              }
		              //////////////
		              
		           
			
               f.dispose();      
            } catch ( SQLException sqlex ) {  sqlex.printStackTrace();  }  
              	
          }
               
    	} 
    });
    
      JButton cal=new JButton("取消");
      cal.addActionListener(new ActionListener(){
    	public void actionPerformed(ActionEvent ev){    	 
    	if((ev.getActionCommand()).equals("取消"))     	 
              {
              	 f.dispose();
               }  	
    	}
    }); 	
    p1.add(l1);//"用户名");
    p1.add(t1);
    p1.add(l2);//密码
    p1.add(t2);   
    p1.add(que);
    p1.add(cal);  
    contentPane.add(p1);//将面板p1加入窗体中   
    f.setLocation(400,300);//设置窗体大小
    	f.pack();//让程序自动打包窗体大小        
    	f.show(); //显示窗口       
    	f.addWindowListener(new WindowAdapter() {            
    		public void windowClosing(WindowEvent e) {                    
    			System.exit(0);            
    		}        
    	});    
// return true;
}


///////////////////////////////////////////////注册

public void regedit()
{
		 final JFrame f=new JFrame("注册"); 
       Container contentPane=f.getContentPane();
       contentPane.setLayout(new BorderLayout());      
	   //------------------------
    JPanel p1=new JPanel();
    p1.setLayout(new GridLayout(3,2));
    p1.setBorder(BorderFactory.createTitledBorder("会员注册"));	
     JLabel l1=new JLabel("用户名");
     final JTextField t1=new JTextField();     
     JLabel l2=new JLabel("密码");   
     final JPasswordField t2 = new JPasswordField();   
    JButton que=new JButton("确定");     	 
    que.addActionListener(new ActionListener(){
    	public void actionPerformed(ActionEvent ev){    	 
    	if((ev.getActionCommand()).equals("确定"))     	 
           {
              String userN,password,s="",p="";             
            
              dataBase();            
            try { //执行SQL语句 
						String query = "SELECT name,password FROM user1"; //接受输入的sql语句
						statement = connection.createStatement(); 
						resultSet = statement.executeQuery( query );
						boolean ee=true;
						userN=t1.getText();
                        password=t2.getText();
                        				
				while(resultSet.next()&&ee)
					 {	 s=resultSet.getString("name");
					     p=resultSet.getString("password");				    
			  	    if(userN.equals(s))//当输入的姓名与文件中的相同
              	   {   
              	        ee=false;
	              	
	              			 JFrame pp=new JFrame("");
					         String title="错误信息提示";				   	 
					   	 int type=JOptionPane.PLAIN_MESSAGE;
					         type=JOptionPane.INFORMATION_MESSAGE;
					   	   String   message="用户名已经存在！";
					     JOptionPane.showMessageDialog(f,message,title,type);			
					         pp.setLocation(400,400);
					         regedit();				     
	              	}	              	
              	           
	             
		          }//while  end             
		          if(ee)
	              		{
	              			//userN="'过喜欢'";	              		
	              	    	String ins = "INSERT INTO user1 VALUES('"+userN+"','"+password+"')"; 
	              	    //	String ins = "INSERT INTO user1 VALUES("+userN","+password+")"; 						   
					     	 statement.executeUpdate( ins );					     	 
					     	 JFrame pp=new JFrame("");
					      String title="提示信息";				   	 
					   	 int type=JOptionPane.PLAIN_MESSAGE;
					      type=JOptionPane.INFORMATION_MESSAGE;
					   	  String   message="注册成功！";
					      JOptionPane.showMessageDialog(f,message,title,type);			
					      pp.setLocation(400,400); 				     	 
										 
	              		}            
			
               f.dispose();      
            } catch ( SQLException sqlex ) {  sqlex.printStackTrace();  } 
            
       
          }
               
    	} 
    });
   
      JButton cal=new JButton("取消");
      cal.addActionListener(new ActionListener(){
    	public void actionPerformed(ActionEvent ev){    	 
    	if((ev.getActionCommand()).equals("取消"))     	 
              {
              	 f.dispose();
               }  	
    	}
    }); 	
    p1.add(l1);//"用户名");
    p1.add(t1);
    p1.add(l2);//密码
    p1.add(t2);   
    p1.add(que);
    p1.add(cal);  
    contentPane.add(p1);//将面板p1加入窗体中   
    f.setLocation(400,300);//设置窗体大小
    	f.pack();//让程序自动打包窗体大小        
    	f.show(); //显示窗口       
    	f.addWindowListener(new WindowAdapter() {            
    		public void windowClosing(WindowEvent e) {                    
    			System.exit(0);            
    		}        
    	});    
}
//////////////////////////////////////////////////////////////////////////////////////////查询模块
//////////////////////////////按个人查询
public void personFind()
{
		final JFrame f=new JFrame("按个人查询");     
       Container contentPane=f.getContentPane();
       contentPane.setLayout(new BorderLayout());	
    JPanel p1=new JPanel();
    p1.setLayout(new GridLayout(3,3));