package thizlinux.bean.extraEquipment;
//包名
import java.sql.ResultSet;
import java.util.Collection;//
import java.util.Vector;import thizlinux.bean.share.*;
import thizlinux.bean.computerConf.ComputerMethod;
import thizlinux.bean.extraEquipment;
public class ExtraEquipmentMethod {
Conn con=null;
ResultSet rs=null;
//ExtraEquipment 类含有属性:id,eid,equipment,model,quantity,type,price,createdate,comid 以及各个属性的set和get方法。
public ExtraEquipment methodOne(int id)
{
con=new Conn();
String sql="select * from emm_extraEquipment where ID="+id;
try{
rs=con.executeQuery(sql);
ExtraEquipment extra=new ExtraEquipment();
if(rs.next())
{
extra.setId(rs.getInt("ID"));
extra.setEid(rs.getString("EID"));
extra.setEquipment(rs.getString("Equipment"));
extra.setModel(rs.getString("Model"));
extra.setQuantity(rs.getInt("Quantity"));
extra.setType(rs.getString("Type"));
extra.setPrice(rs.getInt("Price"));
extra.setCreatedate(rs.getString("CreateDate"));
extra.setComid(rs.getShort("ComID"));
return extra;
}else
return null; return rs.getInt(1);
}
return 0;
}catch(Exception e){
System.out.println(sql+":"+e.getMessage());
return 0;
}finally{
try{
if(rs!=null)rs.close();
con.close();
}catch(Exception e){
System.out.println("close error!!!!!!!");
}
}
}
public String methodThree(String ,String re)
{
String sql = "INSERT INTO emm_re VALUES('"++"','"+re+"')";
try
{
conn = new Conn();
conn.executeUpdate(sql);
}
catch (Exception e)
{
e.printStackTrace();
return "exception!";
}
finally
{
try
{
conn.close();
}
catch (Exception e)
{
e.printStackTrace();
return "exception";
}
}
return "success";
}
}
//包名
import java.sql.ResultSet;
import java.util.Collection;//
import java.util.Vector;import thizlinux.bean.share.*;
import thizlinux.bean.computerConf.ComputerMethod;
import thizlinux.bean.extraEquipment;
public class ExtraEquipmentMethod {
Conn con=null;
ResultSet rs=null;
//ExtraEquipment 类含有属性:id,eid,equipment,model,quantity,type,price,createdate,comid 以及各个属性的set和get方法。
public ExtraEquipment methodOne(int id)
{
con=new Conn();
String sql="select * from emm_extraEquipment where ID="+id;
try{
rs=con.executeQuery(sql);
ExtraEquipment extra=new ExtraEquipment();
if(rs.next())
{
extra.setId(rs.getInt("ID"));
extra.setEid(rs.getString("EID"));
extra.setEquipment(rs.getString("Equipment"));
extra.setModel(rs.getString("Model"));
extra.setQuantity(rs.getInt("Quantity"));
extra.setType(rs.getString("Type"));
extra.setPrice(rs.getInt("Price"));
extra.setCreatedate(rs.getString("CreateDate"));
extra.setComid(rs.getShort("ComID"));
return extra;
}else
return null; return rs.getInt(1);
}
return 0;
}catch(Exception e){
System.out.println(sql+":"+e.getMessage());
return 0;
}finally{
try{
if(rs!=null)rs.close();
con.close();
}catch(Exception e){
System.out.println("close error!!!!!!!");
}
}
}
public String methodThree(String ,String re)
{
String sql = "INSERT INTO emm_re VALUES('"++"','"+re+"')";
try
{
conn = new Conn();
conn.executeUpdate(sql);
}
catch (Exception e)
{
e.printStackTrace();
return "exception!";
}
finally
{
try
{
conn.close();
}
catch (Exception e)
{
e.printStackTrace();
return "exception";
}
}
return "success";
}
}
第一个方法传入一个id,返回该类型的一条记录public String methodThree(String ,String re)
第二个方法传入两个字段的值,并将该记录插入数据库
//包名
import java.sql.ResultSet;
import java.util.Collection;//
import java.util.Vector;import thizlinux.bean.share.*;
import thizlinux.bean.computerConf.ComputerMethod;
import thizlinux.bean.extraEquipment;
public class ExtraEquipmentMethod {
Conn con=null;
ResultSet rs=null;
//ExtraEquipment 类含有属性:id,eid,equipment,model,quantity,type,price,createdate,comid 以及各个属性的set和get方法。
public ExtraEquipment methodOne(int id) //输入一个ID作为查询条件返对象
{
con=new Conn();
//sql查询语句
String sql="select * from emm_extraEquipment where ID="+id;
try{
rs=con.executeQuery(sql);
//构建JAVABEAN对象来封装查询条件
ExtraEquipment extra=new ExtraEquipment();
if(rs.next())//是否还有记录
{
//将查询结果存入对象相应属性
extra.setId(rs.getInt("ID"));
extra.setEid(rs.getString("EID"));
extra.setEquipment(rs.getString("Equipment"));
extra.setModel(rs.getString("Model"));
extra.setQuantity(rs.getInt("Quantity"));
extra.setType(rs.getString("Type"));
extra.setPrice(rs.getInt("Price"));
extra.setCreatedate(rs.getString("CreateDate"));
extra.setComid(rs.getShort("ComID"));
return extra;//返回对象
}else
return null;//如果每查到返回空对象 /*这下面程序有问题,可以去掉
return rs.getInt(1);
}
return 0;*/
}catch(Exception e){
打印异常
System.out.println(sql+":"+e.getMessage());
return 0;
}finally{
释放数据库连接
try{
if(rs!=null)rs.close();
con.close();
}catch(Exception e){
System.out.println("close error!!!!!!!");
}
}
}
public String methodThree(String ,String re)//数据库插入函数
{
sql插入语句
String sql = "INSERT INTO emm_re VALUES('"++"','"+re+"')";
try
{
conn = new Conn();
conn.executeUpdate(sql);
}
catch (Exception e)
{
e.printStackTrace();
return "exception!";
}
finally
{
try
{
conn.close();
}
catch (Exception e)
{
e.printStackTrace();
return "exception";
}
}
return "success";
}
}