你在调用方式的时候传一个参数,用于标示你要进行那一种操作,然后再进行判断
public void demo(sql){
if(sql == "update"){
String sSQL="update GLB set name="+name+"where id="+id;
}
if(sql == "delete"){
String sSQL="delete GLB where id="+id;
}
if(sql == "insert"){
String sSQL="insert into GLB value();
}
try{
com.zjxcsoft.util.DBControl dbc = new com.zjxcsoft.util.DBControl();
com.zjhcsoft.util.DbAction dba = new com.zjhcsoft.util.DbAction();
Connection conn = null;
conn = dbc.getDBConnetion();
execute(conn,sSQL);
conn.close();
}catch(SQLException se){
System.out.println(se);
}catch(Exception e){
System.out.println(e);
}
}
public void demo(sql){
if(sql == "update"){
String sSQL="update GLB set name="+name+"where id="+id;
}
if(sql == "delete"){
String sSQL="delete GLB where id="+id;
}
if(sql == "insert"){
String sSQL="insert into GLB value();
}
try{
com.zjxcsoft.util.DBControl dbc = new com.zjxcsoft.util.DBControl();
com.zjhcsoft.util.DbAction dba = new com.zjhcsoft.util.DbAction();
Connection conn = null;
conn = dbc.getDBConnetion();
execute(conn,sSQL);
conn.close();
}catch(SQLException se){
System.out.println(se);
}catch(Exception e){
System.out.println(e);
}
}
照你这样写的 public void demo(sql)中的sql 会报错 如果加上String的话 下面的sSQL会报错 是否可以再帮忙改下 谢谢。
回复三楼 能具体点么 谢谢
public void demo(String sql)或 public void demo(int a)
然后判断 sql 或 a 调用
if(flag== "update"){
String sSQL="update GLB set name="+name+"where id="+id;
}
if(flag== "delete"){
String sSQL="delete GLB where id="+id;
}
if(flag== "insert"){
String sSQL="insert into GLB value();
}
try{
com.zjxcsoft.util.DBControl dbc = new com.zjxcsoft.util.DBControl();
com.zjhcsoft.util.DbAction dba = new com.zjhcsoft.util.DbAction();
Connection conn = null;
conn = dbc.getDBConnetion();
execute(conn,sSQL);
conn.close();
}catch(SQLException se){
System.out.println(se);
}catch(Exception e){
System.out.println(e);
}
}