~whyclj/gx_tieta.git

New file
			@@ -0,0 +1,125 @@
			package com.fgkj.dao.impl;

			import java.sql.ResultSet;
			import java.sql.SQLException;
			import java.util.ArrayList;
			import java.util.List;

			import com.fgkj.dao.BaseDAO;
			import com.fgkj.dao.CallBack;
			import com.fgkj.dao.DAOHelper;
			import com.fgkj.db.DBUtil;

			public class Battmon_testcapImpl implements BaseDAO,CallBack{

			@Override
			public List getResults(ResultSet rs) {
			// TODO Auto-generated method stub
			return null;
			}

			@Override
			public boolean add(Object obj) {
			// TODO Auto-generated method stub
			return false;
			}

			@Override
			public boolean update(Object obj) {
			// TODO Auto-generated method stub
			return false;
			}

			@Override
			public boolean del(Object obj) {
			// TODO Auto-generated method stub
			return false;
			}

			@Override
			public List searchAll() {
			// TODO Auto-generated method stub
			return null;
			}
			//根据测试容量查询标准曲线的单体电压数据
			public float serchByStandardvol(float monvolstd,float testcap,float moncapstd) {
			float cap=0;
			if(monvolstd==12) {
			cap=150;
			}else {
			if(moncapstd<=300) {
			cap=300;
			}else {
			cap=500;
			}
			}
			String sql=" select distinct mon_vol from db_battinf.tb_battmon_testcap where test_cap<=? and moncapstd=? order by test_cap desc limit 1 ";
			List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[] {testcap,cap}, new CallBack() {

			@Override
			public List getResults(ResultSet rs) {
			List list=new ArrayList();
			try {
			while(rs.next()) {
			list.add(rs.getFloat("mon_vol"));
			}
			} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			}
			return list;
			}
			});
			float mon_vol=0;
			if(list!=null&&list.size()>0) {
			mon_vol=(float) list.get(list.size()-1);
			}
			return mon_vol;
			}
			//根据测试容量查询标准曲线的最大测试容量
			public float serchMaxStandardvol(float monvolstd,float moncapstd) {
			float cap=0;
			if(monvolstd==12) {
			cap=150;
			}else {
			if(moncapstd<=300) {
			cap=300;
			}else {
			cap=500;
			}
			}
			String sql=" select max(abs(test_cap)) as max_cap from db_battinf.tb_battmon_testcap where moncapstd=? limit 1 ";
			List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[] {cap}, new CallBack() {

			@Override
			public List getResults(ResultSet rs) {
			List list=new ArrayList();
			try {
			while(rs.next()) {
			list.add(rs.getFloat("max_cap"));
			}
			} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			}
			return list;
			}
			});
			float max_cap=0;
			if(list!=null&&list.size()>0) {
			max_cap=(float) list.get(list.size()-1);
			}
			return max_cap;
			}
			@Override
			public List serchByCondition(Object obj) {
			return null;
			}

			@Override
			public List serchByInfo(Object obj) {
			// TODO Auto-generated method stub
			return null;
			}

			}

New file
			@@ -0,0 +1,71 @@
			package com.fgkj.dto;

			import java.io.Serializable;

			public class Battmon_testcap implements Serializable{
			private int num;
			private float monvolstd;
			private float moncapstd;
			private String battproducer;
			private String battmodel;
			private float test_cap;
			private float mon_vol;
			private String note;
			public int getNum() {
			return num;
			}
			public void setNum(int num) {
			this.num = num;
			}
			public float getMonvolstd() {
			return monvolstd;
			}
			public void setMonvolstd(float monvolstd) {
			this.monvolstd = monvolstd;
			}
			public float getMoncapstd() {
			return moncapstd;
			}
			public void setMoncapstd(float moncapstd) {
			this.moncapstd = moncapstd;
			}
			public String getBattproducer() {
			return battproducer;
			}
			public void setBattproducer(String battproducer) {
			this.battproducer = battproducer;
			}
			public String getBattmodel() {
			return battmodel;
			}
			public void setBattmodel(String battmodel) {
			this.battmodel = battmodel;
			}
			public float getTest_cap() {
			return test_cap;
			}
			public void setTest_cap(float test_cap) {
			this.test_cap = test_cap;
			}
			public float getMon_vol() {
			return mon_vol;
			}
			public void setMon_vol(float mon_vol) {
			this.mon_vol = mon_vol;
			}
			public String getNote() {
			return note;
			}
			public void setNote(String note) {
			this.note = note;
			}
			@Override
			public String toString() {
			return "Battmon_testcap [num=" + num + ", monvolstd=" + monvolstd + ", moncapstd=" + moncapstd
			+ ", battproducer=" + battproducer + ", battmodel=" + battmodel + ", test_cap=" + test_cap
			+ ", mon_vol=" + mon_vol + ", note=" + note + "]";
			}


			}

	gx_tieta/src/com/fgkj/dao/impl/Battmon_testcapImpl.java	125 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	gx_tieta/src/com/fgkj/dto/Battmon_testcap.java	71 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史