bookbean.java

来自「代码是自己我的代码不是网上down的。是自己写的。里面有很多值得学习的知识点。还」· Java 代码 · 共 156 行

import java.sql.*;
import javax.swing.*;
public class BookBean extends JPanel
{
	private String bookname;
	private String press;
	private String auther;
	private String address;
	private String pressdate;
	private String price;
	private String comment;
	Connection con=null;
	Statement smt=null;
	ResultSet rs=null;
	public String getBookname()
	{
		return bookname;
	}
	public String getPress()
	{
		return press;
	}

	public String getAuther()
	{
		return auther;
	}
	private String getAddress()
	{
		return address;
	}
	private String getPressdate()
	{
		return pressdate;
	}
	private String getPrice()
	{
		return price;
	}
	private String getComment()
	{
		return comment;
			   
	}
	public void setBookname(String name)
	{
		this.bookname=name;
	}	
	public void setPress(String press)
	{
		this.press=press;
	}

    public void setAuther(String auther)
    {
    	this.auther=auther;
    }
    public void setAddress(String auther)
    {
    	this.address=address;
    }
    public void setPressdate(String pressdate)
    {
    	this.pressdate=pressdate;
    }
    public void setPrice(String price)
    {
    	this.price=price;
    }
    public void setComment(String comment)
    {
    	this.comment=comment;
    }
    public boolean insert()
    {
    	BookBean bean=new BookBean();
        
    	try{
    		con = new DBManager().getConnection();
    		PreparedStatement pstm=con.prepareStatement("insert into 书籍信息表(bookname,press,auther,address,pressdate,price,comment) values(?,?,?,?,?,?,?)");
    		pstm.setString(1,bookname);
    		pstm.setString(2,press);
    		pstm.setString(3,auther);
    		pstm.setString(4,address);
    		pstm.setString(5,pressdate);
    		pstm.setString(6,price);
    		pstm.setString(7,comment);
    		pstm.executeUpdate();
    		return true;
    	}
    	catch(Exception e1)
    	{
    	System.out.println(e1.toString());
    	return false;	
    	}
    	
    }
    public boolean delete()
    {
    	BookBean bean=new BookBean();
        
    	try{
    		con = new DBManager().getConnection();
    		PreparedStatement pstm=con.prepareStatement("delete from  书籍信息表 where bookname=?");
    		pstm.setString(1,bookname);
    		pstm.executeUpdate();
    		return true;
    	}
    	catch(Exception e1)
    	{
    	return false;	
    	}	
    }
    public boolean modify()
    {
    
        	BookBean bean=new BookBean();
    	try{
    		con = new DBManager().getConnection();
    		PreparedStatement pstm=con.prepareStatement("update 书籍信息表 set bookname=?,press=?,auther=?,address=?,pressdate=?,price=?,comment=? where bookname='"+bookname+"'");
    		pstm.setString(1,bookname);
    		pstm.setString(2,press);
    		pstm.setString(3,auther);
    		pstm.setString(4,address);
    		pstm.setString(5,pressdate);
    		pstm.setString(6,price);
    		pstm.setString(7,comment);
    		pstm.executeUpdate();
    		return true;
    	}
    	catch(Exception e1)
    	{
    	return false;	
    	}
    }
    public boolean isnull()
    {
    	BookBean bean=new BookBean();
        
    	try{
    		con = new DBManager().getConnection();
    		smt=con.createStatement();
    		rs=smt.executeQuery("select * from  书籍信息表 where bookname='"+bookname+"'");
    		if(rs.next())
    		{
    			return false;
    		}
    		
    	}
    	catch(Exception e1)
    	{
    
    	}
    	return true;
    }
}