ITPub博客

首页 > Linux操作系统 > Linux操作系统 > [转载]一个封装了基本JDBC操作的类

[转载]一个封装了基本JDBC操作的类

原创 Linux操作系统 作者:dinner1007 时间:2019-01-08 22:30:06 0 删除 编辑
一个封装了基本JDBC操作的类
odbc.java
---------------------------------------------

package bbs;

/*
database operation class, test by odbc

This javabean is written by zergling
It is my first javabean :o
version 1.01
*/

import java.sql.*;
import java.lang.*;
import java.io.*;
import java.util.*;
import sun.io.*;

public class odbc
{
Connection sqlCon;
ResultSet rstSql;
Statement stmS;
String strCon;
String strSql;
boolean status;
long rowcount;
int page;
int pagesize;
long pagecount;
long firstrecord;

//connect to the default database
public boolean connect()
{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
this.strCon = "jdbc:odbc:jspbbs"; //replace with your default database
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
this.sqlCon = java.sql.DriverManager.getConnection(this.strCon,"sa",""); //replace with your default database connection configure option
this.status = true;
return true;
}
catch(Exception e)
{
this.status = false;
return false;
}
}

//connect to the custom database
public boolean connect(String conName,String username,String password)
{
//Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
this.strCon = conName;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
this.sqlCon = java.sql.DriverManager.getConnection(this.strCon,username,password);
this.status = true;
return true;
}
catch(Exception e)
{
this.status = false;
return false;
}
}

//execute sql(insert,update,delete,...)
public boolean execute(String s)
{
try
{
this.stmS = this.sqlCon.createStatement();
this.stmS.executeUpdate(s);
this.status = true;
return true;
}
catch(Exception e)
{
this.status = false;
return false;
}
}

//query the data from database
public boolean query(String s)
{
try
{
this.rowcount = 0;
this.stmS = this.sqlCon.createStatement();
this.rstSql = this.stmS.executeQuery(s);
while (this.nextrecord())
{
this.rowcount++;
}
this.rstSql = this.stmS.executeQuery(s);
this.status = true;
return true;
}
catch(Exception e)
{
this.status = false;
return false;
}
}

//return the row count
public long getrowcount()
{
return this.rowcount;
}

//return the pagecount
public long getpagecount()
{
return this.pagecount;
}

//return the resultset of data
public String getstring(String s)
{
try
{
return this.rstSql.getString(s);
}
catch(Exception e)
{
return "not exists";
}
}

public int getint(String s)
{
try
{
return Integer.parseInt(this.rstSql.getString(s));
}
catch(Exception e)
{
return 0;
}
}

//resultset move forward
public boolean nextrecord()
{
try
{
return this.rstSql.next();
}
catch(Exception e)
{
return false;
}
}

//set current page (recall first)
public boolean setpage(int size,int no)
{
this.pagesize = size;
this.page = no;
this.pagecount = Math.round((this.rowcount - 1) / this.pagesize)+1;
this.firstrecord = this.pagesize * ( this.page - 1 );
try
{
for(int i=0;i if (!this.nextrecord()) break;
return true;
}
catch(Exception e)
{
return false;
}
}

//get string from database and change it into chinese
public String readChinese(String s)
{
try
{
String temp = new String(s.getBytes("GB2312"),"8859_1");
return temp;
}
catch(Exception e)
{
return s;
}
}

//write string to the database"s chinese transform
public static String writeChinese(String s)
{
char[] orig =s.toCharArray();
byte[] dest =new byte[orig.length];
for(int i=0;i dest[i] =(byte)(orig[i]&0xFF);
try
{

ByteToCharConverter toChar =ByteToCharConverter.getConverter("gb2312");

return new String(toChar.convertAll(dest));
}
catch(Exception e)
{
return s;
}
}


//string"s search and replace
public String replace(String con ,String tag,String rep){

int j=0;

int i=0;

int k=0;

String RETU="";

String temp =con;

int tagc =tag.length();

while(i
if(con.substring(i).startsWith(tag)){

temp =con.substring(j,i)+rep;

RETU+= temp;

i+=tagc;

j=i;

}

else{

i+=1;

}



}

RETU +=con.substring(j);

return RETU;

}

public Vector listValue(String con ,String tag){

int j=0;

int i=0;

int k=0;

Vector vv=new Vector();

String temp =con;

int tagc =tag.length();

while(i
if(con.substring(i).startsWith(tag)){

temp =con.substring(j,i);

vv.addElement(temp);

i+=tagc;

j=i;

}

else{

i+=1;

}



}

vv.addElement(con.substring(j));

return vv;

}


//filt the html code & sql symbol
public String htmlencode(String s)
{
try
{
String temp = this.replace(s,"<","<");
temp = this.replace(temp,">",">");
temp = this.replace(temp,""",""");
temp = this.replace(temp,""",""");
temp = this.replace(temp," "," ");
temp = this.replace(temp,"
","
");
return temp;
}
catch(Exception e)
{
return s;
}
}

//return the status of last operation
public boolean getstatus()
{

return this.status;
}

//close all object
public boolean close()
{
try
{
if (this.sqlCon != null) this.sqlCon.close();
if (this.rstSql != null) this.rstSql.close();
if (this.stmS != null) this.stmS.close();
this.status = true;
return false;
}
catch(Exception e)
{
this.status = false;
return true;
}
}

}

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/374079/viewspace-132125/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2018-08-23

  • 博文量
    403
  • 访问量
    254175