database.java

一个毕业设计网络招标系统实现了招标的业务逻辑内含了数据库sql server备份文件

package com.CDB;

import java.sql.*;

public class dataBase {
	private Connection con = null;

	private Statement stmt = null;

	private ResultSet rs = null;

	private String userName;

	private String userPass;

	private String sqlURL;

	private String sqlDriver;

	public dataBase() {
		userName = "sa";
		userPass = "sa";
		sqlURL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=C03";
//		sqlURL="jdbc:odbc:love";
	sqlDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
	//	sqlDriver="sun.jdbc.odbc.JdbcOdbcDriver";
		try {
			Class.forName(sqlDriver);
			con = DriverManager.getConnection(sqlURL, userName, userPass);
			stmt = con.createStatement();
		} catch (Exception e) {
			System.out.println("Database Error!!!" + e.toString());
		}

	}

	public ResultSet sqlFind(String sql) {
		try {
			rs = stmt.executeQuery(sql);
		} catch (Exception e) {
			System.out.println("sqlFind Error!!" + e.toString());
			return null;
		}
		return rs;
	}

	public boolean sqlUpdata(String sql) {
		try {
			stmt.executeUpdate(sql);
		} catch (Exception e) {
			System.out.println("sqlUpdata Error!!" + e.toString());
			return false;
		}
		return true;
	}

	public void sqlclose() {

		if (rs != null) {
			try {
				rs.close();
			} catch (SQLException e) {
				System.out.println("rs Error!!" + e.toString());
			}
			rs = null;
		}
		if (stmt != null) {
			try {
				rs.close();
			} catch (SQLException e) {
				System.out.println("stmt Error!!" + e.toString());
			}
			stmt = null;
		}

		if (con != null) {
			try {
				rs.close();
			} catch (SQLException e) {
				System.out.println("con Error!!" + e.toString());
			}
			con = null;
		}
	}

}