condb.java

图书馆系统

//数据库操作类
//package lib;

import java.sql.*;

public class ConDB {
	Connection conn = null;

	CallableStatement statement = null;

	Statement stmt = null;

	ResultSet rs = null;

	// 导入驱动
	public ConDB() {
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		} catch (java.lang.ClassNotFoundException e) {
			System.err.println(e.getMessage());
		}
	}

	// 数据库查询
	public ResultSet executeQuery(String sql) {
		try {
			conn = DriverManager
					.getConnection(
							"jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=libmanager",
							"sa", "123456");
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
					ResultSet.CONCUR_UPDATABLE);
			rs = stmt.executeQuery(sql);
		} catch (SQLException ex) {
			System.err.println(ex.getMessage());
		}
		return rs;
	}

	// 数据库更新
	public int executeUpdate(String sql) {
		int result = 0;
		try {
			conn = DriverManager
					.getConnection(
							"jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=libmanager",
							"sa", "123456");
			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;
		}
		return result;
	}

	// 调用存储过程
	public ResultSet executeProcedure(String sql) {
		try {
			conn = DriverManager
					.getConnection(
							"jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=libmanager",
							"sa", "123456");
			statement = conn.prepareCall(sql);
			statement.execute();
			rs = statement.getResultSet();
		} catch (SQLException ex) {
			System.err.println(ex);
		}
		return rs;
	}
	public static void main(String[] args){
		ConDB ff=new ConDB();
		ResultSet rs = ff.executeQuery("SELECT top 5 * FROM Books order by Totaljie desc");
		try{
			while(rs.next()){
				System.out.println(rs.getString("Bookname".trim()));
				
			}
		}
		catch(Exception e){}
	}

}