程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 編程語言 >> JAVA編程 >> 關於JAVA >> 一個封裝了基本JDBC操作的類

一個封裝了基本JDBC操作的類

編輯:關於JAVA

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,"\n","
");

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;

}

}

}

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved