数据库连接源码.doc

package com.javach08;import java.io.FileInputStream;import java.io.FileNotFoundException;import java.io.IOException;import java.io.InputStream;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.Properties;import javax.sql.DataSource;import mons.dbcp.BasicDataSourceFactory;public class JDBCTest2000 private static DataSource dataSource=null;/* * param args */public static void main(String args) Connection con =null;Statement st =null;ResultSet rst=null;try con=getConnection(); /使用数据源来连接数据库st = con.createStatement();rst = st.executeQuery(select * from user_info );while(rst.next()System.out.println(rst.getString(username); catch (SQLException e) e.printStackTrace();finallyif(rst!=null)try rst.close(); catch (SQLException e) e.printStackTrace();if(st!=null)try st.close(); catch (SQLException e) e.printStackTrace();if(con!=null)try con.close(); catch (SQLException e) e.printStackTrace();public static Connection getConnection()InputStream input =null;try input=new FileInputStream(perties);Properties properties=new Properties();properties.load(input);if(dataSource= null)dataSource = BasicDataSourceFactory.createDataSource(properties);return dataSource.getConnection(); catch (FileNotFoundException e) e.printStackTrace(); catch (IOException e) e.printStackTrace(); catch (Exception e) e.printStackTrace();finallyif(input!=null)try input.close(); catch (IOException e) e.printStackTrace();return null;/* 下面的代码放到 perties 文件里 这里用的是sqlserver2005数据库 * driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriverurl=jdbc:sqlserver:/localhost: