mysql存储food_从表单获取的数据已封装到FoodOrder对象中，现调saveOrder方法将数据添加到foodorderinfo数据表中，不成功...

packageres.lg.ch05;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importres.lg.ch03.ConnectionManager;pub...

package res.lg.ch05;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import res.lg.ch03.ConnectionManager;

public class OrderModel {

private Connection con=null;

private PreparedStatement pst=null;

private ResultSet rs=null;

/**

* @功能 插入订单

* @参数 foodOrder为FoodOrder类对象，用来存储订单信息

* @返回值 int型值

*/

public int saveOrder(FoodOrder foodOrder){

int result=0;

String sql=" insert into foodordernfo(customerName, address, " +

"zipCode, telephone, movePhone, notice, totalPrice) "+

"values(?,?,?,?,?,?,?,?)";

con=ConnectionManager.getConnection();

try {

pst=con.prepareStatement(sql);

pst.setString(2, foodOrder.getCustomerName());

pst.setString(3, foodOrder.getAddress());

pst.setString(4, foodOrder.getZipCode());

pst.setString(5, foodOrder.getTelephone());

pst.setString(6, foodOrder.getMovePhone());

pst.setString(7, foodOrder.getNotice());

pst.setDouble(8, foodOrder.getTotalPrice());

result=pst.executeUpdate();

} catch (SQLException e) {

// TODO 自动生成 catch 块

e.printStackTrace();

}

return result;

}

}

展开