@Override
public int addSale(LiveDetailSale sale) {
// 添加购买信息
dbConn = JdbcUtil.connSqlServer();
try {
sta = dbConn.createStatement();
return sta.executeUpdate(
"INSERT INTO JCP_LiveDetailSale (FK_UserId,FK_TearchId,OrderCode,FK_LiveDetailId,InsertDate) VALUES ("
+ sale.getUserId()
+ ","
+ sale.getTeacherId()
+ ",'"
+ sale.getOrderCode()
+ "',"
+ sale.getLiveDetailId()
+ ",'"
+ sale.getInsertDate()
+ "')");
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
JdbcUtil.closeConn(sta, dbConn, res);
} catch (SQLException e) {
e.printStackTrace();
}
}
return 0;
}
