orderdao.java~10~

来自「这是一个用Struts做出来的网上商城的源代码」· JAVA~10~ 代码 · 共 44 行

package com.dao;
import com.tool.JDBConnection;
import com.tool.FinalConstants;
import java.sql.*;
import java.util.*;
import com.domain.OrderForm;
//订货表的操作
public class OrderDao {
  private Connection connection = null; //定义连接的对象
private PreparedStatement ps = null; //定义预准备的对象
private JDBConnection jdbc = null; //定义数据库连接对象
public OrderDao() {
  jdbc = new JDBConnection();
  connection = jdbc.connection; //利用构造方法取得数据库连接
}
public void insertOrderDetail(OrderForm form) {
   try {

     ps = connection.prepareStatement(FinalConstants.order_insert);
     ps.setString(1, form.getNumber());
     ps.setString(2, form.getName());
     ps.setString(3,form.getReallyName());
     ps.setString(4, form.getAddress());
     System.out.println("地址="+form.getAddress());
     ps.setString(5,form.getTel());
     System.out.println("电话="+form.getTel());
     ps.setString(6,form.getSetMoney());
     System.out.println(form.getSetMoney());
     ps.setString(7,form.getPost());
     System.out.println(form.getPost());
     ps.setString(8,form.getBz());
     System.out.println(form.getBz());
     ps.setString(9,form.getSign());
      System.out.println(form.getSign());
     ps.executeUpdate();

     ps.close();
   }
   catch (SQLException ex) {
      System.out.print("99999999");
   }
  }
}