dbcon.java

为实现简单的单词在线字典功能.基本的数据单词录入,删除,自定义.

package db;

/**
 * @author Shijin
 * 
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
import java.sql.*;

public class DBcon {
	Connection con = null;

	Statement stmt = null;

	ResultSet rs = null;

	Boolean update = false;

	public DBcon() {
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			// 载入驱动程序类别

			con = DriverManager.getConnection("jdbc:odbc:mydb1");
			// 建立资料库链接

			stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
			// 建立Statement对象, 并设置记录指标类型为可前后移动
		} catch (Exception ex) {
			System.out.println(ex.toString());
		}
	}

	public ResultSet getRs(String sql) {
		try {
			rs = stmt.executeQuery(sql);
			return rs;
		} catch (SQLException ex) {
			System.out.println(ex.toString());
			return null;
		}
	}

	public Boolean getUpdate(String sql) {
		try {
			int i = stmt.executeUpdate(sql);
			if (i != 0)
				update = true;
			return update;
		} catch (Exception e) {
			//System.out.println(e.toString());
			return false;
		}
	}

	public boolean Emp()
	// Empty list of resources
	{
		return getUpdate("DELETE FROM dic");
	} // Emp()

	// ****************************************************************************
	public boolean Ins(String InWord, String InDef) {
		
		rs = this.getRs("SELECT * FROM dic WHERE Word = '" + InWord + "'");
		try {
			if (!rs.next())
				return this.getUpdate("INSERT INTO Dic " + "VALUES('" + InWord
						+ "', '" + InDef + "')");
			return false;
		} catch (Exception e) {
			return false;
		}
	} // Ins()

	// ****************************************************************************
	public boolean Rem(String InWord) {
		
		rs = this.getRs("SELECT * FROM dic WHERE Word = '" + InWord + "'");
		try {
			if (rs.next())
				return this.getUpdate("DELETE FROM dic " + "WHERE Word = '"
						+ InWord + "'");
			return false;
		} catch (Exception e) {
			return false;
		}
	} // Rem()
	public ResultSet getRsByWord(String InWord){
		
		rs = this.getRs("SELECT * FROM dic "+"WHERE Word = '"
	            + InWord + "'");
		return rs;
	}
	public ResultSet getRsAll(){
		rs = this.getRs("SELECT * FROM dic");
		return rs;
	}

	public void closeBean() // 执行关闭各种对象的操作
	{
		try {
			rs.close();
			stmt.close();
			con.close();
		} catch (Exception ex) {
			System.out.println(ex.toString());
		}
	}

}