【Java开源代码栏目提醒】:网学会员Java开源代码为您提供ClientSql.java参考,解决您在ClientSql.java学习中工作中的难题,参考学习。
package com.zh.util;
import java.sql.*;
import com.zh.conpool.*;
import com.bwm.string.*;
public class ClientSql{
private String sql=null;
ResultSet rs=null;
Condata con=new Condata();
Str str=new Str();
Connection conn=null;
String id;
String sql1;
boolean fal=false;
public String getSql(String clientname){
if(clientname==null){
sql="select * from tb_client";
}else{
sql="select * from tb_client where ClientName='"+str.toChinese(clientname)+"'";
}
return sql;
}
public String getClient(){
sql="select * from tb_client";
return sql;
}
public String getId(String id){
this.id=id;
sql="select * from tb_client where Id='"+id+"'";
return sql;
}
public String getPerson(){
sql="select * from tb_person";
return sql;
}
public ResultSet Rs(String sql){
try{
con.getConnection();
}catch(Exception e){
e.getMessage();
}
rs=con.executeQuery(getId(id));
return rs;
}
public boolean Id_class(){
boolean fag=false;
try{
con.getConnection();
}catch(Exception e){
e.getMessage();
}
rs=con.executeQuery(getId(id));
if(rs!=null){
fag=true;
}else{
fag=false;
}
return fag;
}
public boolean del_class(){
try{
con.getConnection();
}catch(Exception e){
e.getMessage();
}
boolean bol=false;
int temp=con.executeUpdate(Del(id));
if(temp>0){
bol=true;
}else{
bol=false;
}
con.close();
con=null;
return bol;
}
public String Del(String id){
this.id=id;
sql1="delete from tb_client where Id='"+id+"'";
return sql1;
}
public boolean execute()throws Exception{
boolean flag=false;
try{
con.getConnection();
}catch(Exception e){
e.getMessage();
}
rs=con.executeQuery(getSql(null));
if(rs!=null){
flag=true;
}else{
flag=false;
}
conn.close();
rs.close();
con.close();
return flag;
}
public static void main(String[] para){
ResultSet rs=null;
ClientSql c1=new ClientSql();
try{
rs=c1.Rs();
}catch(Exception e){
}
System.out.println(rs);
}
}
上一篇:
ClientSingleton.java
下一篇:
法律专业开题报告范文