dbmanager.java

来自「新闻发布系统」· Java 代码 · 共 71 行

/*
 * DBManager.java
 *
 * Created on 2007年3月16日, 上午9:37
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */

package News.Common;

/**
 *
 * @author Owner
 */
import java.io.*;
import java.sql.*;
import java.util.*;

public class DBManager {
	public static String username="";
	public static String password="";
	public static String DBURL="jdbc:odbc:news";
	public static String DBClass="sun.jdbc.odbc.JdbcOdbcDriver";
	
	public static void load()
	{
		try{
		FileInputStream f=new FileInputStream("dbpool.inf");
		Properties proper=new Properties();
		proper.load(f);
		DBURL=proper.getProperty("DBURL");
		DBClass=proper.getProperty("DBClass");
		username=proper.getProperty("username");
		password=proper.getProperty("password");
		
		f.close();
		f=null;
		proper=null;
		}catch(Exception e){System.out.println(e.toString());}
	}
	
	public static Connection getConnection()
	{
                Connection conn=null;
		try{
		Class.forName(DBClass);
		conn=DriverManager.getConnection(DBURL,username,password);
               	return conn;
		}catch(Exception e){System.out.println(e.toString());}
		return conn;
	}
        
	public static void main(String[] args) {
                Statement st;
                ResultSet rs;
		Connection con=getConnection();
                try{
                st=con.createStatement();
                rs=st.executeQuery("select * from Catalogs");
                
                while(rs.next())
                {
                    System.out.println(rs.getString("Title"));
                }
                }catch(Exception e){System.out.println(e.getMessage());}
	  }
	
		
}