insertorderlistdao.java

网上购物源代码

/**
 * 
 */
package com.chinaaccpDao;

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

import com.chinaaccpbean.InsertOrderListBean;

/**
 * @author Administrator
 *
 */
public class InsertOrderListDao {

	public boolean GetInsertOrderList(InsertOrderListBean order)
	{
		Connection con = null;
		int id = 0;
		try {
			con = ConnectionLee.GetCon();
			Statement st = con.createStatement();
			String sql = "select id from UserInfo where name='"+order.getName()+"'";
			ResultSet rs = st.executeQuery(sql);
			if(rs.next())
			{
				id = rs.getInt(1);
			}
			st.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			String sql = "Insert into OrderList(orderlistnum,userinfoid,name,idnum,postcode,address,email,tel,totalfee) values(?,?,?,?,?,?,?,?,?)";
			PreparedStatement ps = con.prepareStatement(sql);
			ps.setString(1, order.getOrdernum());
			ps.setInt(2, id);
			ps.setString(3,order.getName());
			ps.setString(4, order.getIdnum());
			ps.setString(5, order.getPostcode());
			ps.setString(6, order.getAddress());
			ps.setString(7, order.getEmail());
			ps.setString(8, order.getTel());
			ps.setDouble(9, order.getTotalfee());
			int row = ps.executeUpdate();
			if(row>0)
			{
				return true;
			}
			else
				return false;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return false;
	}
}