order_detail_dao.java

这是一个Struts网上商城(图书)的管理系统源代码.

package com.bookshop.dao;
import com.bookshop.dto.*;
import com.bookshop.dao.*;
import com.bookshop.db.*;
import java.sql.*;

import java.util.*;

public class order_detail_dao {
	//将生成的定单信息存到数据库中
	public int add(bookshop_dto dao,int orderid)
	{
		Connection conn=DBConnection.getConnection();
		StringBuffer sb=new StringBuffer();
		sb.append("insert into tb_order_detail(orderid,isbn,price,number)values(?,?,?,?)");
		PreparedStatement ps=null;
		int n=0;
		try{
			ps=conn.prepareStatement(sb.toString());
			ps.setInt(1, orderid);
			ps.setString(2, dao.getIsbn());
			ps.setFloat(3, dao.getPrice());
			ps.setInt(4,dao.getNumber());
			
			
			conn.setAutoCommit(false);
			n=ps.executeUpdate();
			conn.commit();
		}catch(SQLException e){e.printStackTrace();}
		finally{
			
			try{
				ps.close();
				conn.close();
			
			}catch(SQLException ex){ex.printStackTrace();}
		}
		return n;
		
		
	}

}