databaselink.java

图书浏览软件

import java.sql.*;
import javax.swing.*;
import java.awt.event.*;

public class DataBaseLink
{
	
	private Connection Link;

	
	public DataBaseLink(String LinkPath)
	{
	    try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(Exception e)
		{
			System.out.println("数据库驱动程序装载错误");
			return;
		}
		
		try
		{
			Link = DriverManager.getConnection(LinkPath);
		}
		catch(Exception e1)
		{
			System.out.println("数据库打开错误");
		}	
	}
	
	
	public Statement newStatement()
	{
		Statement sm = null;
		try
		   {
			   sm = Link.createStatement();
		   }
		catch(Exception e)
		   {
		   	   System.out.println("数据集创建错误");
		   }
		return sm;
	}
	
	
	public ResultSet newResultSet(String sql)
	{
		ResultSet rs = null;
		try
		   {
			   rs = Link.createStatement().executeQuery(sql);
		   }
		catch(Exception e)
		   {
		   	   System.out.println("数据集创建错误");
		   }
		return rs;
	}
	
	public void addtushu(String[] tushu)
	{
		try
		{
			
            PreparedStatement sm = Link.prepareStatement("INSERT INTO 图书目录 VALUES(?,?,?,?,?,?)"); 
		    for(int i = 0;i<6;i++)
		    {
		    	sm.setString(i+1,tushu[i]);
		    }
		    sm.execute();
		    sm.close();
		}
		catch(Exception e)
		{
			new MessageFrame("系统中已存在该图书，请不要重复添加").setVisible(true);
		}
	}
	
	
	public void tableperform(ResultSet rs,showtable table)
	{
		try
		{
			table.removeAllRow();
			int i = 1;
			while(rs.next())
		    {
	            String[] row = new String[7];
	            row[0] = String.valueOf(i++);
	            row[1] = rs.getString(1);
	            row[2] = rs.getString(2);
	            row[3] = rs.getString(3);
	            row[4] = rs.getString(4);
	            row[5] = rs.getString(5);
	            row[6] = rs.getString(6);
	            table.addRow(row);
		    }
		    
		    rs.close();  
		}
		catch(Exception e)
		{
			
		}
	}
	
	
	public void alltushu(showtable table)
	{
		ResultSet rs = newResultSet("SELECT * FROM 图书目录 ORDER BY 书名");
	    tableperform(rs,table);
	}
	
	public void alltushubyauthor(showtable table)
	{
		ResultSet rs = newResultSet("SELECT * FROM 图书目录 ORDER BY 作者");
	    tableperform(rs,table);
	}
	
	public void alltushubyclass(showtable table)
	{
		ResultSet rs = newResultSet("SELECT * FROM 图书目录 ORDER BY 类别");
	    tableperform(rs,table);
	}
	
	
	public void deletetushu(String dir)
	{
		if(dir!=null)
		try
		{
            PreparedStatement sm = Link.prepareStatement("DELETE FROM 图书目录 WHERE 保存目录=?"); 
		    sm.setString(1,dir);
		    sm.execute();
		    sm.close();
		    
		}
		catch(Exception e)
		{
			new MessageFrame("已清除的图书").setVisible(true);
		}
	}
	
	
	public void lookupbyshuming(String shuming,showtable table)
	{
		ResultSet rs = null;
		try
		   {
		   	   PreparedStatement sm = Link.prepareStatement("SELECT * FROM 图书目录 WHERE 书名=?");
		   	   sm.setString(1,shuming);
			   rs = sm.executeQuery();	   
		   }
		catch(Exception e)
		   {
		   	   e.printStackTrace();
		   }
	       tableperform(rs,table);
	}
	
	
	public void lookupbyauthor(String shuming,showtable table)
	{
		ResultSet rs = null;
		table.removeAllRow();
		try
		   {
		   	   PreparedStatement sm = Link.prepareStatement("SELECT * FROM 图书目录 WHERE 作者=?");
		   	   sm.setString(1,shuming);
			   rs = sm.executeQuery();	   
		   }
		catch(Exception e)
		   {
		   	   e.printStackTrace();
		   }
	    tableperform(rs,table);
	}
	
	
	
	public void lookupbyclass(String shuming,showtable table)
	{
		ResultSet rs = null;
		table.removeAllRow();
		try
		   {
		   	   PreparedStatement sm = Link.prepareStatement("SELECT * FROM 图书目录 WHERE 类别=?");
		   	   sm.setString(1,shuming);
			   rs = sm.executeQuery();	   
		   }
		catch(Exception e)
		   {
		   	   e.printStackTrace();
		   }
        tableperform(rs,table);
	}
	
	
	public void edittushu(String author,String CLASS,String path)
	{
		try
		{
            PreparedStatement sm = Link.prepareStatement("UPDATE  图书目录 SET 作者=?,类别=? WHERE 保存目录=?"); 
		    sm.setString(1,author);
		    sm.setString(2,CLASS);
		    sm.setString(3,path);
		    sm.execute();
		    sm.close();
		}
		catch(Exception e)
		{
			new MessageFrame("请选中一本图书").setVisible(true);
		}	
     }
}