bookinsert.java

手工完成

package Bean;

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

public class BookInsert {
	public void Insert(BookBean bookbean)
	{
		Bean.BookBean book = bookbean;
		Connection conn = null;
			conn = new DBConn().getConn();
			String sql = null;
			sql = "INSERT INTO book (bookID,bookName,author,press,price,sum,discount,picroot) VALUES (?,?,?,?,?,?,?,?)";
			
			try {
				PreparedStatement ps=conn.prepareStatement(sql);
				
				ps.setString(1, book.getBookID());
				ps.setString(2, book.getBookName());
				ps.setString(3, book.getAuthor());
				ps.setString(4, book.getPress());
				ps.setDouble(5, book.getPrice());
				ps.setInt(6, book.getSum());
				ps.setDouble(7, book.getDiscount());
				ps.setString(8, book.getPicroot());
				
				ps.executeUpdate();//
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
			System.out.println("数据成功插入到数据库中！");
	}
}