4、图书类别添加功能

1、新建图书类别表t_bookType

2、新建图书类别实体，BookType.java

/**
 * 图书类别实体
 * @author Administrator
 *
 */
public class BookType {

	private int id;//编号
	private String bookTypeName;//图书类别名称
	private String bookTypeDesc;//备注
	
	public BookType() {
		super();
		// TODO Auto-generated constructor stub
	}
	public BookType(String bookTypeName, String bookTypeDesc) {
		super();
		this.bookTypeName = bookTypeName;
		this.bookTypeDesc = bookTypeDesc;
	}
	public BookType(int id, String bookTypeName, String bookTypeDesc) {
		super();
		this.id = id;
		this.bookTypeName = bookTypeName;
		this.bookTypeDesc = bookTypeDesc;
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getBookTypeName() {
		return bookTypeName;
	}
	public void setBookTypeName(String bookTypeName) {
		this.bookTypeName = bookTypeName;
	}
	public String getBookTypeDesc() {
		return bookTypeDesc;
	}
	public void setBookTypeDesc(String bookTypeDesc) {
		this.bookTypeDesc = bookTypeDesc;
	}
	
	
}

3、新建图书类别DAO类，BookTypeDao.java

（DAO类都是进行数据操作的类, 是对于数据库中的数据做增删改查等操作的代码）

/**
 * 图书类别Dao类
 * @author Administrator
 *
 */
public class BookTypeDao {

	/**
	 * 图书类别添加
	 * @param con
	 * @param bookType
	 * @return
	 * @throws Exception
	 */
	public int add(Connection con,BookType bookType)throws Exception{
		String sql="insert into t_bookType values(null,?,?)";
		PreparedStatement pstmt=con.prepareStatement(sql);
		pstmt.setString(1, bookType.getBookTypeName());
		pstmt.setString(2, bookType.getBookTypeDesc());
		return pstmt.executeUpdate();//执行
		
	}
}

4、新建“图书类别-添加”的内部窗体，BookTypeAddInterFrm.java

修改布局方式

窗体全部组件：


修改textField为bookTypeNameTxt

修改textArea为bookTypeDescTxt

5、实现重置功能

添加事件

public void actionPerformed(ActionEvent arg0) {
			}

因为添加完也要重置，所以单独写一个重置的方法

/**
	 * 重置表单
	 */
	private void resetValue(){
		this.bookTypeNameTxt.setText("");
		this.bookTypeDescTxt.setText("");
	}

public void actionPerformed(ActionEvent evt) {
				resetValueActionPerformed(evt);
			}

/**
	 * 重置事件处理
	 * @param evt
	 */
	private void resetValueActionPerformed(ActionEvent evt) {
		this.resetValue();
		
	}

6、给“图书类别-添加”添加事件，点击“添加”显示“图书类别添加”窗体

public void actionPerformed(ActionEvent e) {
				BookTypeAddInterFrm bookTypeAddInterFrm=new BookTypeAddInterFrm();
				bookTypeAddInterFrm.setVisible(true);
				table.add(bookTypeAddInterFrm);
			}

添加代码，设置文本域边框

//设置文本域边框
bookTypeDescTxt.setBorder(new LineBorder(new java.awt.Color(127,157,185),1,false));

实现图书类别添加功能
添加事件

public void actionPerformed(ActionEvent e) {
				bookTypeAddActioPerformed(e);
			}

/**
 * 图书类别添加事件处理
 * @param e
 */
private void bookTypeAddActioPerformed(ActionEvent evt) {
	String bookTypeName=this.bookTypeNameTxt.getText();//获取用户输入的信息
	String bookTypeDesc=this.bookTypeDescTxt.getText();
	if(StringUtil.isEmpty(bookTypeName)){
		JOptionPane.showMessageDialog(null, "图书类别名称不能为空！");
		return;
	}
	BookType bookType=new BookType(bookTypeName,bookTypeDesc);
	Connection con=null;
	try{
		con=dbUtil.getCon();
		int n=BookTypeDao.add(con,bookType);
		if(n==1){
			JOptionPane.showMessageDialog(null, "添加成功！");
			resetValue();
		}else{
			JOptionPane.showMessageDialog(null, "添加失败！");
		}
	}catch(Exception e){
		e.printStackTrace();
		JOptionPane.showMessageDialog(null, "添加失败！");
	}finally{
		try {
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
}