62,612
社区成员
发帖
与我相关
我的任务
分享
Consumables cyp = clservice.findByName("mining", "柴油", "2009","10");
Consumables qyp = clservice.findByName("mining", "汽油", "2009","10");
System.out.println("cyp.price"+cyp.getPrice());
System.out.println("qyp.price"+qyp.getPrice());
Consumables cyp = clservice.findByName("mining", "柴油", "2009","10");
System.out.println("cyp.price"+cyp.getPrice());
Consumables qyp = clservice.findByName("mining", "汽油", "2009","10");
System.out.println("qyp.price"+qyp.getPrice());
public Consumables findByName(String dep, String cname,String year,String month) {
// TODO Auto-generated method stub
Consumables u = new Consumables();//这样会有空指针?不可能吧
Session session = HbnUtil.getSession();
Connection connection = session.connection();
Statement stmt = null;
ResultSet rs = null;
// System.out.println("dep="+dep+" cname="+cname+" year="+year+" month="+month);
String sql = "select * from Consumables_t where z_dep='"+dep+"' and z_cname='"+cname+"' and z_year='"+year+"' and z_month='"+month+"' order by z_id desc";
try {
stmt = connection.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next()){
u.setId(rs.getLong(1));
u.setConsumablesModel(rs.getString(2));
u.setConsumablesName(rs.getString(3));
u.setYear(rs.getString(4));
u.setMonth(rs.getString(5));
u.setDepartment(rs.getString(6));
u.setPrice(rs.getDouble(7));
u.setUnit(rs.getString(8));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
HbnUtil.release(rs, stmt, connection, session);
}
return u;}
public Consumables findByName(String dep, String cname,String year,String month) {
// TODO Auto-generated method stub
Consumables u = new Consumables();
Session session = HbnUtil.getSession();
Connection connection = session.connection();
Statement stmt = null;
ResultSet rs = null;
// System.out.println("dep="+dep+" cname="+cname+" year="+year+" month="+month);
String sql = "select * from Consumables_t where z_dep='"+dep+"' and z_cname='"+cname+"' and z_year='"+year+"' and z_month='"+month+"' order by z_id desc";
try {
stmt = connection.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next()){
u.setId(rs.getLong(1));
u.setConsumablesModel(rs.getString(2));
u.setConsumablesName(rs.getString(3));
u.setYear(rs.getString(4));
u.setMonth(rs.getString(5));
u.setDepartment(rs.getString(6));
u.setPrice(rs.getDouble(7));
u.setUnit(rs.getString(8));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
HbnUtil.release(rs, stmt, connection, session);
}
return u;}
package com.hxsmelt.model.entity;
import java.io.Serializable;
public class Consumables implements Serializable {
/**
*
*/
private static final long serialVersionUID = 1L;
private long id;
private String consumablesModel;
private String consumablesName;
private String unit;
private double price;
private String year;
private String month;
private String department;
public String getYear() {
return year;
}
public void setYear(String year) {
this.year = year;
}
public Consumables() {
super();
// TODO Auto-generated constructor stub
}
@Override
public int hashCode() {
final int prime = 31;
int result = 1;
result = prime * result + (int) (id ^ (id >>> 32));
return result;
}
@Override
public boolean equals(Object obj) {
if (this == obj)
return true;
if (obj == null)
return false;
if (getClass() != obj.getClass())
return false;
Consumables other = (Consumables) obj;
if (id != other.id)
return false;
return true;
}
public long getId() {
return id;
}
public void setId(long id) {
this.id = id;
}
public String getConsumablesModel() {
return consumablesModel;
}
public void setConsumablesModel(String consumablesModel) {
this.consumablesModel = consumablesModel;
}
public String getConsumablesName() {
return consumablesName;
}
public void setConsumablesName(String consumablesName) {
this.consumablesName = consumablesName;
}
public String getUnit() {
return unit;
}
public void setUnit(String unit) {
this.unit = unit;
}
public double getPrice() {
return price;
}
public void setPrice(double price) {
this.price = price;
}
public String getMonth() {
return month;
}
public void setMonth(String month) {
this.month = month;
}
public String getDepartment() {
return department;
}
public void setDepartment(String department) {
this.department = department;
}
}
private Consumables u = new Consumables();
public Consumables findByName(String dep, String cname,String year,String month) {
// TODO Auto-generated method stub
Session session = HbnUtil.getSession();
Connection connection = session.connection();
Statement stmt = null;
ResultSet rs = null;
// System.out.println("dep="+dep+" cname="+cname+" year="+year+" month="+month);
String sql = "select * from Consumables_t where z_dep='"+dep+"' and z_cname='"+cname+"' and z_year='"+year+"' and z_month='"+month+"' order by z_id desc";
try {
stmt = connection.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next()){
u.setId(rs.getLong(1));
u.setConsumablesModel(rs.getString(2));
u.setConsumablesName(rs.getString(3));
u.setYear(rs.getString(4));
u.setMonth(rs.getString(5));
u.setDepartment(rs.getString(6));
u.setPrice(rs.getDouble(7));
u.setUnit(rs.getString(8));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
HbnUtil.release(rs, stmt, connection, session);
}
return u;}