addbookdb.java

本系统完成简单的图书管理系统

/***********************************************************************
*                          湖南大学图书管理系统
* @author Administrator                                                         
* @since 2008.06                                                  
* @version 1.0                                                           															  
* @category 添加图书数据库操作
*************************************************************************/

package library.DBaccess;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import library.data.Book;
import library.DBBase.JDBC;

public class AddBookDB {

	public AddBookDB() {
		// TODO Auto-generated constructor stub
		super();
	}

	public void AddBook(Book book) {

		JDBC jdbc = new JDBC();
		Connection con = jdbc.getConnection();

		String sql = "insert into book(TITLE,AUTHOR,CATEGORY,PRESS,PRICE,PAGINATION,ISBN,CHECTDATE,COUNT,REMARK) values("
				+ "'"
				+ book.title
				+ "','"
				+ book.author
				+ "','"
				+ book.category
				+ "','"
				+ book.press
				+ "','"
				+ book.price
				+ "','"
				+ book.pagination
				+ "','"
				+ book.isbn
				+ "','"
				+ book.chectdate
				+ "',"
				+ book.count
				+ ",'"
				+ book.remark + "')";

		try {
			PreparedStatement ps = con.prepareStatement(sql);
			ps.executeUpdate();
			System.out.println("插入数据成功");
		} catch (SQLException e) {
			e.printStackTrace();
		}

	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

		AddBookDB addb = new AddBookDB();
		Book book = new Book();;
		book.title = "java";
		book.author ="caohao";
		book.isbn = "546973134";
		book.category = "computer";
		book.pagination = "458";
		book.press = "icbc";
		addb.AddBook(book);
			
	}

}