conndb.java

利用JAVA语言实现

package com;

import java.sql.*;

/**
 * 连接与操作Server2000数据库的类
 * @author lab
 *
 */
public class ConnDB {
	Connection conn = null;
	Statement stmt = null;
	ResultSet rs = null;
	String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=ChineseMedicine;user=sa;password=";

	public ConnDB() {
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		} catch (java.lang.ClassNotFoundException e) {
			System.err.println(e.getMessage());
		}
	}

	/***************************************************
	 *method name:	executeQuery()
	 *功能:执行查询操作
	 *return value: ResultSet
	 ****************************************************/
	public ResultSet executeQuery(String sql) {
		try {
			conn = DriverManager
					.getConnection(url);
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
			rs = stmt.executeQuery(sql);
		} catch (SQLException ex) {
			System.err.println(ex.getMessage());
		} finally {
		}
		return rs;
	}

	/***************************************************
	 *method name:	executeUpdate()
	 *功能:执行更新操作
	 *return value: int
	 ****************************************************/

	public int executeUpdate(String sql) {
		int result = 0;
		try {
			conn = DriverManager
					.getConnection(url);
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_READ_ONLY);
			result = stmt.executeUpdate(sql);
		} catch (SQLException ex) {
			System.err.println(ex.getMessage());
			result = 0;
		} finally {
		}
		return result;
	}

	/***************************************************
	 *method name:	close()
	 *功能:关闭数据库链接
	 *return value: 	void
	 ****************************************************/
	public void close() {
		try {
			if (rs != null)
				rs.close();
		} catch (Exception e) {
			e.printStackTrace(System.err);
		} finally {
		}
		try {
			if (stmt != null)
				stmt.close();
		} catch (Exception e) {
			e.printStackTrace(System.err);
		} finally {
		}
		try {
			if (conn != null) {
				conn.close();
			}
		} catch (Exception e) {
			e.printStackTrace(System.err);
		} finally {
		}
	}
}