jdbcsample.java

数据库连接包括连接池。很有用的资料

import java.sql.*;
public class JDBCSample 
{
    
    private Statement stmt=null;
    private Connection conn=null;
    private ResultSet rs=null;
    
    public JDBCSample()
    {
    	try{
    			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    		}
    	catch(java.lang.ClassNotFoundException e)
    	{
    		System.err.print("ClassNotFoundException:");
    		System.err.println(e.getMessage());
    	}
    
    	init();
    
    }
    
    private void init()
    {
    	try{
    			conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Library", "sa", "123");
    			stmt=conn.createStatement();
    			rs=stmt.executeQuery("INSERT INTO book VALUES   ('A32DT00001', 'JAVA', 28)");
    			rs=stmt.executeQuery("select * from book");
    			while(rs.next())
    				{
    					System.out.println(rs.getString(1));
    					System.out.println(rs.getString(2));
    					System.out.println(rs.getString(3)); 
					}

    
    		}
    	catch(SQLException ex){
    	System.err.println("SQLException :"+ex.getMessage());
    	}
    	finally
    	{
    		try
    		{
    			rs.close();
    			stmt.close();
    			conn.close();
    		}
    		catch(Exception ex)
    		{
    			ex.printStackTrace();
    		}
    	}
   	}
    
    public static void main(String[] args) throws SQLException ,ClassNotFoundException
    {
    
 		new JDBCSample();
        
    }
}