jdbcdemo1.java

java程序设计语言源代码

//Example 1 of Chapter 10

import java.sql.*;

public class JDBCDemo1
{
	public JDBCDemo1()
	{
		super();
	}
	
	public static void main( String args[] )
	{
		try{
			Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver" );
			String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
			Connection conn = DriverManager.getConnection( url );
			Statement stmt = conn.createStatement();
			String sql = "select * from sales";
			ResultSet rs = stmt.executeQuery( sql );
			while( rs.next() )
			{
				System.out.println("TestName:"+rs.getString( "qty" ));
			}
			rs.close();
			stmt.close();
			conn.close();
		}
		catch(Exception ex)
		{
			System.err.println(ex);
		}
	}
}