myconn.java

来自「java版QQ聊天,实现用户登录验证」· Java 代码 · 共 66 行

package com.net;

import java.sql.*;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
import java.util.Properties;
import java.io.*;

public class myConn {
	
	public Connection conn ;
	public PreparedStatement ps ;
	
	public static void main(String args[]) {
		myConn PD = new myConn("db.ini");
	}
	
	public myConn(String LoadName)			//输入ini文件的名称LoadName
	{
		conn = null;
		ps = null;
		
		try{
			Properties prop = new Properties();
			//加载属性配置文件
			prop.load(new FileInputStream(LoadName));
		
		    //加载驱动
		    String driverClassName = prop.getProperty("driverClassName");
		   	Class.forName(driverClassName);
       
		    //注册驱动
		    String url = prop.getProperty("url");
		    String username = prop.getProperty("username");
		    String password = prop.getProperty("password");
		    
		    //获取连接
		    conn = DriverManager.getConnection(url,username,password);
		    

		}catch(FileNotFoundException e)
		{
			System.out.println(e);
			
		}catch(IOException e)
		{
			System.out.println(e);
		}catch(ClassNotFoundException e)
		{
			System.out.println(e);
			System.out.println("ClassNotFoundException");
		}catch(SQLException e)
		{
			System.out.println(e);
			System.out.println("SQLException");
		}
	}
			
	public Connection getConn()
	{
		return conn;
	}
	public PreparedStatement getPs()
	{
		return ps;
	}
}