jodb.java

数据库连接包括连接池。很有用的资料

package zbean; 
import java.sql.*; 
//import zbean.*; 

public class Jodb 
{ 
    public String sdbdriver="sun.jdbc.odbc.JdbcOdbcDriver"; 
public String sConnStr; 
public long count; 
String uid; 
String pwd; 
Connection conn=null; 
ResultSet rs=null; 

public Jodb() 
{ 
try 
{ 
Class.forName(sdbdriver); 
} 
catch(java.lang.ClassNotFoundException e) 
{ 
System.err.println("Jodb():"+e.getMessage()); 
} 
} 


public void setDbDriver(String y) 
{ 
sdbdriver=y; 
} 

public void setConnStr(String x,String z,String a) 
{ 
sConnStr=x; 
uid=z; 
pwd=a; 
} 

public ResultSet execute(String sql) 
{ 
rs=null; 


try 
{ 
conn=DriverManager.getConnection(sConnStr,uid,pwd); 
Statement stmt=conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY); 
rs=stmt.executeQuery(sql); 
} 
catch(SQLException ex) 
{ 
System.err.println("Jodb.execute():"+ex.getMessage()); 
} 
return rs; 
} 

public long update(String sql) 
{ 
long x=0; 
try 
{ 
conn=DriverManager.getConnection(sConnStr); 
Statement stmt=conn.createStatement(); 
x=stmt.executeUpdate(sql); 
} 
catch(SQLException ey) 
{ 
System.err.println("Jodb.update():"+ey.getMessage()); 
} 
return x; 
} 

public String pageStr(int page,int pageCount,String url,String showStr) 
{ 
//String str="Page:("+page+"/"+pageCount+")  "; 
String str=""; 
String fstr; 
String pstr; 
String nstr; 
String lstr; 
//int page=currPage; 
//int pageCount=pageCt; 

if(showStr=="cn") 
{ 
fstr="第一页"; 
pstr="上一页"; 
nstr="下一页"; 
lstr="最末页"; 
} 
else if(showStr=="en") 
{ 
fstr="First"; 
pstr="Previous"; 
nstr="Next"; 
lstr="Last"; 
} 
else 
{ 
String[] temp_array=split(showStr,","); 
if(temp_array==null) 
{ 
str="Please input String like: "First,Previous,Next,Last""; 
return str; 
} 
fstr=temp_array[0]; 
pstr=temp_array[1]; 
nstr=temp_array[2]; 
lstr=temp_array[3]; 
} 
/* 
int npage; 
npgae=page+1; 
int ppage; 
ppage=page-1; 
if(npage>pageCount) 
{npae=pageCount;} 
if(ppgae<1) 
{ppage=1;} 
*/ 
if(page==1){ 
str=str+"<a href="+url+"page="+(page+1)+">"+nstr+"</a> "; 
str=str+"<a href="+url+"page="+pageCount+">"+lstr+"</a> "; 
} 
if(page==pageCount){ 
str=str+"<a href="+url+"page=1>"+fstr+"</a> "; 
str=str+"<a href="+url+"page="+(page-1)+">"+pstr+"</a> "; 
} 
if(page>1&&page<pageCount){ 
str=str+"<a href="+url+"page=1>"+fstr+"</a> "; 
str=str+"<a href="+url+"page="+(page-1)+">"+pstr+"</a> "; 
str=str+"<a href="+url+"page="+(page+1)+">"+nstr+"</a> "; 
str=str+"<a href="+url+"page="+pageCount+">"+lstr+"</a> "; 
} 

return str; 
} 

public String[] split(String str,String strIn) 
{ 
char[] temp_array; 
temp_array=str.toCharArray(); 
int strLength=str.length(); 
int strInLength=strIn.length(); 
int strInTimes=0; 
int strIndex[]=new int[strLength]; 

int i=0; 
int ii=0; 
while(i<=strLength-strInLength) 
{ 
String temp_str=""; 
for(int j=i;j<i+strInLength;j++) 
{ 
temp_str=temp_str+temp_array[j]; 
} 
if(temp_str.equals(strIn)) 
{ 
strInTimes++; 
strIndex[ii]=i; 
i=i+strInLength; 
ii++; 
} 
else 
{ 
i++; 
} 

} 

if(strInTimes<1) 
{ 
String[] back_str=null; 
return back_str; 
} 
else 
{ 
String back_str[]=new String[strInTimes+1]; 
back_str[0]=str.substring(0,strIndex[0]); 
for(int k=1;k<strInTimes;k++) 
{ 
back_str[k]=str.substring(strIndex[k-1]+strInLength,strIndex[k]); 
} 
back_str[strInTimes]=str.substring(strIndex[strInTimes-1]+strInLength,str.length()); 
return back_str; 
} 

} 

}