import [Link].
Connection;
import [Link];
import [Link];
import [Link];
import [Link];
public class RetrieveResultSet {
public static void main(String[] args) {
// Create a variable for the connection string.
String connectionUrl =
"jdbc:sqlserver://<server>:<port>;databaseName=AdventureWorks;user=<user>;password=
<password>";
try (Connection con = [Link](connectionUrl); Statement
stmt = [Link]();) {
createTable(stmt);
String SQL = "SELECT * FROM [Link];";
ResultSet rs = [Link](SQL);
displayRow("PRODUCTS", rs);
}
// Handle any errors that may have occurred.
catch (SQLException e) {
[Link]();
}
}
private static void displayRow(String title,
ResultSet rs) throws SQLException {
[Link](title);
while ([Link]()) {
[Link]([Link]("ProductNumber") + " : " +
[Link]("Name"));
}
}
private static void createTable(Statement stmt) throws SQLException {
[Link]("if exists (select * from [Link] where name =
'Product_JDBC_Sample')"
+ "drop table Product_JDBC_Sample");
String sql = "CREATE TABLE [Product_JDBC_Sample](" + "[ProductID] [int]
IDENTITY(1,1) NOT NULL,"
+ "[Name] [varchar](30) NOT NULL," + "[ProductNumber] [nvarchar]
(25) NOT NULL,"
+ "[MakeFlag] [bit] NOT NULL," + "[FinishedGoodsFlag] [bit] NOT
NULL," + "[Color] [nvarchar](15) NULL,"
+ "[SafetyStockLevel] [smallint] NOT NULL," + "[ReorderPoint]
[smallint] NOT NULL,"
+ "[StandardCost] [money] NOT NULL," + "[ListPrice] [money] NOT
NULL," + "[Size] [nvarchar](5) NULL,"
+ "[SizeUnitMeasureCode] [nchar](3) NULL," +
"[WeightUnitMeasureCode] [nchar](3) NULL,"
+ "[Weight] [decimal](8, 2) NULL," + "[DaysToManufacture] [int] NOT
NULL,"
+ "[ProductLine] [nchar](2) NULL," + "[Class] [nchar](2) NULL," +
"[Style] [nchar](2) NULL,"
+ "[ProductSubcategoryID] [int] NULL," + "[ProductModelID] [int]
NULL,"
+ "[SellStartDate] [datetime] NOT NULL," + "[SellEndDate]
[datetime] NULL,"
+ "[DiscontinuedDate] [datetime] NULL," + "[rowguid]
[uniqueidentifier] ROWGUIDCOL NOT NULL,"
+ "[ModifiedDate] [datetime] NOT NULL,)";
[Link](sql);
sql = "INSERT Product_JDBC_Sample VALUES ('Adjustable Time','AR-
5381','0','0',NULL,'1000','750','0.00','0.00',NULL,NULL,NULL,NULL,'0',NULL,NULL,NUL
L,NULL,NULL,'2008-04-30 00:00:00.000',NULL,NULL,'694215B7-08F7-4C0D-ACB1-
D734BA44C0C8','2014-02-08 10:01:36.827') ";
[Link](sql);
sql = "INSERT Product_JDBC_Sample VALUES ('ML Bottom Bracket','BB-
8107','0','0',NULL,'1000','750','0.00','0.00',NULL,NULL,NULL,NULL,'0',NULL,NULL,NUL
L,NULL,NULL,'2008-04-30 00:00:00.000',NULL,NULL,'694215B7-08F7-4C0D-ACB1-
D734BA44C0C8','2014-02-08 10:01:36.827') ";
[Link](sql);
sql = "INSERT Product_JDBC_Sample VALUES ('Mountain-500 Black, 44','BK-
M18B-
44','0','0',NULL,'1000','750','0.00','0.00',NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,
NULL,NULL,'2008-04-30 00:00:00.000',NULL,NULL,'694215B7-08F7-4C0D-ACB1-
D734BA44C0C8','2014-02-08 10:01:36.827') ";
[Link](sql);
}
}