bookjiemian.java

用java 语言编写的用于小型图书管理的场所的图书管理代码

					 	con.close();
					 	area.append("按照书名方式删除成功\n\n");
						
					 }
					 catch (SQLException e)
					 {
					    JOptionPane.showConfirmDialog(this, "信息删除失败?","确认对话框",JOptionPane.PLAIN_MESSAGE);	
					 }
					 text3.setText(null);
				}
			}
			else if(e2.getSource()==button4)
			{
				if(text4.getText().equals(""))
				{
					JOptionPane.showMessageDialog(this, "不能 为空值", "警告",JOptionPane.WARNING_MESSAGE);
					text4.setText(null);
				}
				else
				{
					try 
					 {
						Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
					 }
					 catch(ClassNotFoundException e1){area.append("没有建立连接");}
					 try
					 {
					 	 con=DriverManager.getConnection("jdbc:odbc:bcfshuju","","");
					 	sql=con.createStatement();
					 	sql.executeUpdate("delete  from book where pName="+text4.getText()+";");
					 	con.close();
					 	area.append("按照出版社方式删除成功\n\n");
						text4.setText(null);
					 }
					 catch (SQLException e)
					 {
					    JOptionPane.showConfirmDialog(this, "信息删除失败?","确认对话框",JOptionPane.PLAIN_MESSAGE);
						text4.setText(null);
					 }
				}
			}
		}
	}
}

class bookSearch extends Frame implements ActionListener
{
	Label label1,label2,label3,label4;
	TextField text1,text2,text3,text4;
	Box box1,box2,box3,basebox;
	Button button1,button2;
	TextArea area;
	Panel panel1,panel2,panel3;
	bookSearch(String s)
	{
		super(s);
		setLayout(null);
		Font f=new Font("",Font.LAYOUT_LEFT_TO_RIGHT,20);
		box1=Box.createVerticalBox();
		label1=new Label("ISBN");	label1.setFont(f);
		label2=new Label("出版社");	label2.setFont(f);
		label3=new Label("作者");	label3.setFont(f);
		label4=new Label("书名");	label4.setFont(f);
		box1.add(label1);
		box1.add(Box.createVerticalStrut(10));
		box1.add(label2);
		box1.add(Box.createVerticalStrut(10));
		box1.add(label3);
		box1.add(Box.createVerticalStrut(10));
		box1.add(label4);
		box1.add(Box.createVerticalStrut(10));
		box1.setBounds(40,40,150,100);
		add(box1);
		
		box2=Box.createVerticalBox();
		text1=new TextField(15);	
		text1.setFont(f);	text1.setForeground(Color.green);	
		text2=new TextField(15);	text2.setFont(f);	text2.setForeground(Color.green);	
		text3=new TextField(15);	text3.setFont(f);	text3.setForeground(Color.green);	
		text4=new TextField(15);	text4.setFont(f);	text4.setForeground(Color.green);	
		box2.add(text1);	box2.add(Box.createVerticalStrut(8));
		box2.add(text2);	box2.add(Box.createVerticalStrut(8));
		box2.add(text3);	box2.add(Box.createVerticalStrut(8));
		box2.add(text4);	box2.add(Box.createVerticalStrut(8));
		box2.setBounds(200,40,350,100);
		add(box2);
		area=new TextArea(10,10);
		area.setBounds(40,250,400,150);
		add(area);
		area.setFont(f);
		area.setBackground(Color.lightGray);
		
		button1=new Button("查找");
		button1.addActionListener(this);
		button1.setBounds(500, 300, 80, 30);
		button1.setFont(f);
		button1.setForeground(Color.blue);
		button1.setBackground(Color.lightGray);
		button2=new Button("刷新");
		button2.addActionListener(this);
		button2.setBounds(500,350,80,30);
		button2.setFont(f);
		button2.setForeground(Color.blue);
		button2.setBackground(Color.lightGray);
		add(button1);
		add(button2);
		setBackground(Color.cyan);
		
		setVisible(true);
		setResizable(false);
		setBounds(300,200,650,450);
		addWindowListener(new WindowAdapter()
		{
			public void windowClosing(WindowEvent e)
			{
				dispose();
			}
		});
	}
	public void actionPerformed(ActionEvent e)
	{
		 Connection con;
		 Statement sql;
		 ResultSet rs;
		 //String searchStr;
		if(e.getSource()==button1)
		{
			if(text1.getText()!=null)
			{
			try 
			 {
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			 }
			 catch(ClassNotFoundException e1){area.append("没有建立连接");}
			 try
			 {
			 	 con=DriverManager.getConnection("jdbc:odbc:bcfshuju","","");
			 	sql=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			 	//结果集的游标可以上下移动,数据库变化时,当前结果集不变,不能更新数据库 
			 	rs=sql.executeQuery("selet * from book where ISBN="+text1.getText()+";");
			 	while(rs.next())
			 	{
			 		area.append("ISBN\t"+rs.getString("ISBN")+"\n"
			 				+"书名\t"+rs.getString("bName")+"\n"
			 				+"作者\t"+rs.getString("writer")+"\n"
			 				+"出版社"+rs.getString("pname")+"\n"
			 				+"出版社地址\t"+rs.getString("paddr")+"\n"
			 				+"图书版次\t"+rs.getString("pno")+"\n"
			 				+"出版时间\t"+rs.getString("ptime")+"\n"
			 				+"价格\t"+rs.getString("price")+"\n"
			 				+"数量\t"+rs.getString("num")+"\n"
			 				+"图书类别\t"+rs.getString("lei")+"\n\n");
						

			 	}
			 	con.close();
			 }
			 catch (SQLException e2)
			 {
			  JOptionPane.showConfirmDialog(this, "信息查询失败?","确认对话框",JOptionPane.PLAIN_MESSAGE);
			 }
			}
		}
		else if(e.getSource()==button1)
		{
			if(text2.getText()!=null)
			{
			try 
			 {
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			 }
			 catch(ClassNotFoundException e1){area.append("没有建立连接");}
			 try
			 {
			 	 con=DriverManager.getConnection("jdbc:odbc:bcfshuju","","");
			 	sql=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			 	//结果集的游标可以上下移动,数据库变化时,当前结果集不变,不能更新数据库 
			 	rs=sql.executeQuery("selet * from book where pname="+text2.getText()+"group by ISBN");
			 	while(rs.next())
			 	{
			 		area.setText("ISBN\t"+rs.getString("ISBN")+"\n"
			 				+"书名\t"+rs.getString("bName")+"\n"
			 				+"作者\t"+rs.getString("pname")+"\n"
			 				+"出版社地址\t"+rs.getString("paddr")+"\n"
			 				+"图书版次\t"+rs.getString("pno")+"\n"
			 				+"出版时间\t"+rs.getString("price")+"\n"
			 				+"数量\t"+rs.getString("num")+"\n"
			 				+"图书类别\t"+rs.getString("lei")+"\n\n");
			 	}
			 	con.close();
			 }
			 catch (SQLException e2)
			 {
				 text2.setText(null);
				 JOptionPane.showConfirmDialog(this, "信息查询失败?","确认对话框",JOptionPane.PLAIN_MESSAGE);
			 }
			}
		}
		else if(e.getSource()==button1)
		{
			if(text3.getText()!=null)
			{
			try 
			 {
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			 }
			 catch(ClassNotFoundException e1){area.append("没有建立连接");}
			 try
			 {
			 	 con=DriverManager.getConnection("jdbc:odbc:bcfshuju","","");
			 	sql=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			 	//结果集的游标可以上下移动,数据库变化时,当前结果集不变,不能更新数据库 
			 	rs=sql.executeQuery("selet * from book where writer="+text1.getText()+"group by ISBN");
			 	while(rs.next())
			 	{
			 		area.append("ISBN\t"+rs.getString("ISBN")+"\n"
			 				+"书名\t"+rs.getString("bName")+"\n"
			 				+"作者\t"+rs.getString("pname")+"\n"
			 				+"出版社地址\t"+rs.getString("paddr")+"\n"
			 				+"图书版次\t"+rs.getString("pno")+"\n"
			 				+"出版时间\t"+rs.getString("price")+"\n"
			 				+"数量\t"+rs.getString("num")+"\n"
			 				+"图书类别\t"+rs.getString("lei")+"\n\n");
			 	}
			 	con.close();
			 }
			 catch (SQLException e2)
			 {
				 text3.setText(null);
				 JOptionPane.showConfirmDialog(this, "信息查询失败?","确认对话框",JOptionPane.PLAIN_MESSAGE);
			 }
			}
		}
		else if(e.getSource()==button1)
		{
			if(text4.getText()!=null)
			{
			try 
			 {
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			 }
			 catch(ClassNotFoundException e1){area.append("没有建立连接");}
			 try
			 {
			 	 con=DriverManager.getConnection("jdbc:odbc:bcfshuju","","");
			 	sql=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			 	//结果集的游标可以上下移动,数据库变化时,当前结果集不变,不能更新数据库 
			 	rs=sql.executeQuery("selet * from book where bName="+text1.getText()+"group by ISBN");
			 	while(rs.next())
			 	{
			 		area.append("ISBN\t"+rs.getString("ISBN")+"\n"
			 				+"书名\t"+rs.getString("bName")+"\n"
			 				+"作者\t"+rs.getString("pname")+"\n"
			 				+"出版社地址\t"+rs.getString("paddr")+"\n"
			 				+"图书版次\t"+rs.getString("pno")+"\n"
			 				+"出版时间\t"+rs.getString("price")+"\n"
			 				+"数量\t"+rs.getString("num")+"\n"
			 				+"图书类别\t"+rs.getString("lei")+"\n");
			 	}
			 	con.close();
			 }
			 catch (SQLException e2)
			 {
				 text4.setText(null);
				 JOptionPane.showConfirmDialog(this, "信息查询失败?","确认对话框",JOptionPane.PLAIN_MESSAGE);
			 }
			}
		}
	}
}
class bookJieMian extends Frame implements MouseListener
{
	Label label1,label2,label3;
	bookJieMian()
	{
		setTitle("图书信息管理 ");
		setLayout(null);
		setBackground(Color.blue);
		setBounds(300,200,500,400);
		Font f=new Font("",Font.LAYOUT_LEFT_TO_RIGHT,20);
		label1=new Label("图书信息采集");
		label1.addMouseListener(this);
		label1.setFont(f);
		label1.setBounds(50, 100, 150, 70);
		add(label1);
		label2=new Label("图书信息删除");
		label2.addMouseListener(this);
		label2.setFont(f);
		label2.setBounds(150,200,150, 70);
		add(label2);
		label3=new Label("图书信息查询");
		label3.addMouseListener(this);
		label3.setFont(f);
		label3.setBounds(250,300,150,70);
		add(label3);
		addMouseListener(this);
		setVisible(true);
		setResizable(false);
		addWindowListener(new WindowAdapter()
		{
			public void windowClosing(WindowEvent e)
			{
				dispose();
			}
		});
	}
	public void mousePressed(MouseEvent e)
	{
		if(e.getSource()==label1)
		{
			new bookAdd("图书信息采集");
		}
		else if(e.getSource()==label2)
		{
			 new bookDel("图书信息删除");
		}
		else if(e.getSource()==label3)
		{
			 new bookSearch("图书信息查询");
		}
	}
	public void mouseReleased(MouseEvent e){}
	public void mouseEntered(MouseEvent e)
	{
			if(e.getSource()==label1)
			{
				label1.setCursor(Cursor.getPredefinedCursor(Cursor.HAND_CURSOR));
			}
			else if(e.getSource()==label2)
			{
				label2.setCursor(Cursor.getPredefinedCursor(Cursor.HAND_CURSOR));
			}
			else if(e.getSource()==label3)
			{
				label3.setCursor(Cursor.getPredefinedCursor(Cursor.HAND_CURSOR));
			}
			else 
			{
				setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
			}
	}
	public void mouseClicked(MouseEvent e){}
	public void mouseExited(MouseEvent e) {}
}
/*public class book 
{
	public static void main(String args[])
	{
		new bookJieMian();
	}
}*/