0061f91e6b0f001d1622ead12426ea11

实训时做的物流系统

package com.lib.biz;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import com.lib.cls.JDBC;
import com.lib.cls.Server;

public class DisQuery {
	
	private static DisQuery DisQuery;
	public static DisQuery getInstance(){
		if (DisQuery==null){
			DisQuery = new DisQuery();
		}
		return DisQuery;
	}
	
	public JDBC SetJDBC(Server server){
		JDBC jdbc = new JDBC();
		jdbc.setDriver("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		jdbc.setUrl("jdbc:microsoft:sqlserver://"+server.getAdd()+":"+server.getPort()+";DatabaseName="
				+server.getDatabase());
		jdbc.setUsername(server.getU());
		jdbc.setPsw(server.getP());
		return jdbc;
	}
    
	public ResultSet Query(JDBC jdbc,String isbn){
		Connection conn=null;
		ResultSet rs=null;
		try{
			Class.forName(jdbc.getDriver());
		}catch(java.lang.ClassNotFoundException e)
		{
			System.out.println("加载驱动时异常");
		}
		try{
			conn= DriverManager.getConnection(jdbc.getUrl(),jdbc.getUsername(),jdbc.getPsw());
			System.out.println("链接成功");
			Statement s=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			rs=s.executeQuery("select * from book where isbn='"+isbn+"'");
		}catch(SQLException e){
			System.out.println("数据库查询操作异常");
		}
		return rs;
		}
	
	
	public static void main(String[] args) {
		String name = "本地数据库";
		String isbn = "7-115-12926-6";
        Server server = ServerData.getInstance().FindServer(name);
        JDBC jdbc = DisQuery.getInstance().SetJDBC(server);
        System.out.println(jdbc.getUrl());
        System.out.println(jdbc.getUsername());
        System.out.println(jdbc.getPsw());
        ResultSet rs = DisQuery.getInstance().Query(jdbc, isbn);
        try {
			while (rs.next()) {
				System.out.println("sign here");
               System.out.println(rs.getString(3));
			}
		} catch (Exception e) {
			// TODO: handle exception
		}       
	}
	}