buybookdao.java

网上书店 源代码和数据库网上书店 源代码和数据库

package com.shop.model.dao.addbook;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;

import com.shop.model.utils.DataBaseConn;
import com.shop.vo.addbook.BookInfoVo;


public class BuybookDAO {
	public void insertsellbook(String userid, BookInfoVo book) {
		Connection conn = null;
		Statement st = null;
		DataBaseConn dbconn=new DataBaseConn();
		conn=dbconn.getConnection();
		StringBuffer stbf = new StringBuffer("insert into SellBook values('");
		stbf.append(book.getIsbn()).append("','").append(userid).append("',")
				.append(book.getBuyCount()).append(",").append(
						book.getCountPrice()).append(",'").append(
						new java.sql.Date(new Date().getTime()).toLocaleString())
				.append("','").append(book.getBookDescrption()).append("','N")
				.append("')");
		String insert = stbf.toString();
		try {
			st=conn.createStatement();
			st.execute(insert);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			if(st!=null){
				try {
					st.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
			}
			if(conn!=null){
				try {
					conn.close();
				} catch (SQLException e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
				}
				
				
			}
			
			
			
		}
	}

}