book.java

可以完成新书的入库录入

import java.sql.*;
import javax.swing.*;
public class Book
{
	static Connection con,add,xg,xg2,shanchu,zhengli;
	static Statement sql,addsql,xgsql,xgsql2,sc,zl;
	static ResultSet rs,qs,xs,xs2,ss,rzl;
	static Data data;
	boolean boo;
	public static  String text;
	Book() throws Exception
	{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		con=DriverManager.getConnection("jdbc:odbc:Book","","");
		sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
	}

	
	public static Data search(Data data) throws Exception
	{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		con=DriverManager.getConnection("jdbc:odbc:Book","","");   //打开数据库
		sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		//this.data=data;    //传递变量
		rs=sql.executeQuery("SELECT * FROM book1 WHERE 书名 LIKE '%"+data.search+"%'");  //查找图书，按书名
		rs.absolute(-1);
		data.chushihua(rs.getRow()); //将当前行的内容，传递给data
		if(false)
		{
			return data;
		}
		rs.beforeFirst();  //移动指针到第一行
		int i=0;
		while(rs.next()) //将指针下移一行，读出数据
		{
			data.number[i]=rs.getString("编号");
			data.Bookname[i]=rs.getString("书名");
			
			data.date[i]=rs.getString("出版日期");
			data.author[i]=rs.getString("作者");
			data.company[i]=rs.getString("出版商");
			data.ex[i]=rs.getString("状态");
			data.beizhu[i]=rs.getString("备注");
			i++;
		}
		con.close();  //关闭数据库
		rs=null;
		return data;   
		
	}
	
	public static Data xiugai(Data data) throws Exception
	{ //修改数据
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		xg=DriverManager.getConnection("jdbc:odbc:Book","","");   //打开数据库
		xgsql=xg.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		xs=xgsql.executeQuery("SELECT * FROM book1 WHERE 编号 LIKE '"+Long.valueOf(data.search)+"'");   //获得修改的编号
		
		xs.next();    //保存修改后的内容
		data.chushihua(1);
		data.number[0]=xs.getString("编号");
		data.Bookname[0]=xs.getString("书名");
		data.date[0]=xs.getString("出版日期");
		data.author[0]=xs.getString("作者");
		data.company[0]=xs.getString("出版商");
		data.ex[0]=xs.getString("状态");
		data.beizhu[0]=xs.getString("备注");
		xg.close();
		xs=null;
		return data;
	}
	
	public static void xiugai2(String num,String name,String author,String beizhu,String date,String company) throws Exception
	{//修改数据
	   // System.out.println(data.Bookname[0]);
	   String ex="在库";
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		xg2=DriverManager.getConnection("jdbc:odbc:Book","","");
		xgsql2=xg2.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		xs2=xgsql2.executeQuery("SELECT * FROM book1 WHERE 编号 LIKE '"+Long.valueOf(num)+"'");
		String bf="UPDATE book1 SET 书名 = '"+name+"', 出版日期 = '"+date+"',作者 = '"+author+"',状态 = '"+ex+"',出版商 = '"+company+"',备注 = '"+beizhu+"' WHERE 编号 LIKE '"+Long.valueOf(num)+"'";
		xgsql2.execute(bf);
		xg2.close();
		
	}
	
	public static void shanchu(Data data) throws Exception
	{//安编号删除数据
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		shanchu=DriverManager.getConnection("jdbc:odbc:Book","","");  //打开数据库
		sc=shanchu.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		//System.out.println(Long.valueOf(data.search));
		sc.executeUpdate("DELETE FROM book1 WHERE 编号="+Long.valueOf(data.search)+"" );
	}
	
	public static void jiechu(Data data) throws Exception
	{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		xg2=DriverManager.getConnection("jdbc:odbc:Book","","");//打开数据库
		xgsql2=xg2.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		String bf="UPDATE book1 SET 状态 = '借出' WHERE 编号 LIKE '"+Long.valueOf(data.search)+"'";  //更新状态 
		xgsql2.execute(bf);
		xg2.close();
		JOptionPane.showMessageDialog(Tuxing.tx,"操作完成。");
	}
	
	public static void guihuan(Data data) throws Exception
	{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		xg2=DriverManager.getConnection("jdbc:odbc:Book","","");
		xgsql2=xg2.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		String bf="UPDATE book1 SET 状态 = '在库' WHERE 编号 LIKE '"+Long.valueOf(data.search)+"'";
		xgsql2.execute(bf);
		xg2.close();
		JOptionPane.showMessageDialog(Tuxing.tx,"操作完成。");
	}
	
	public static void beizhu(String num) throws Exception
	{//显示数据库中的备注
	    //System.out.println(num+"备注");
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		zhengli=DriverManager.getConnection("jdbc:odbc:Book","","");//打开数据库
		zl=zhengli.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
		rzl=zl.executeQuery("SELECT * FROM book1 WHERE 编号 LIKE '"+Long.valueOf(num)+"'");   //整理图书	
	    rzl.next();
	    //System.out.println("备注"+rzl.getString("备注"));
	    text=rzl.getString("备注");
		rzl=null;
		zhengli.close();
		
	}
	
	public  static void adddata(String bname,String baouther,String bdate,String bcompany,String bbeizhu) throws Exception
	{//把数据添加到数据库中
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");      //打开数据库
		add=DriverManager.getConnection("jdbc:odbc:Book","","");
		addsql=add.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);//创建一个 Statement 对象，该对象将生成具有给定类型和并发性的 ResultSet 对象
		qs=addsql.executeQuery("SELECT * FROM book1");    //查询数据库中所有数据，
		long a=0;
		qs.absolute(-1);  //默认指针处于-1行  
		if(qs.getRow()!=0) //当前行编号不为0
		{
			a=Long.parseLong(qs.getString("编号")); //检索编号列得值，并转化为long型值 
			a++;
		}
		else 
		{
			a++;
		}
		String bf="INSERT INTO book1 VALUES ("+a+",'"+bname+"','"+bdate+"','"+baouther+"','在库','"+bcompany+"','"+bbeizhu+"')";
		addsql.executeUpdate(bf);    //将数据添加到数据库中去
		add.close();           //关闭数据库
	}
}