FilesExpand file tree

 master

/

sample_java.java

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

69 lines (60 loc) · 2.42 KB

 master

/

sample_java.java

Copy path

Top

File metadata and controls

• Code
• Blame

69 lines (60 loc) · 2.42 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

// Use the JDBC driver

import java.sql.*;

import com.microsoft.sqlserver.jdbc.*;

public class connect {

// Connect to your database.

// Replace server name, username, and password with your credentials

public static void main(String[] args) {

String connectionString =

"jdbc:sqlserver://your_servername.database.windows.net:1433;"

+ "database=AdventureWorks;"

+ "user=your_username@your_servername;"

+ "password=your_password;"

+ "encrypt=true;"

+ "trustServerCertificate=false;"

+ "hostNameInCertificate=*.database.windows.net;"

+ "loginTimeout=30;";

// Declare the JDBC objects.

Connection connection = null;

Statement statement = null;

ResultSet resultSet = null;

ResultSet resultSet2 = null;

PreparedStatement prepsInsertProduct = null;

try {

connection = DriverManager.getConnection(connectionString);

// Create and execute a SELECT SQL statement.

String selectSql = "SELECT TOP 10 Title, FirstName, LastName from SalesLT.Customer";

statement = connection.createStatement();

resultSet = statement.executeQuery(selectSql);

// Print results from select statement

while (resultSet.next()) {

System.out.println(resultSet.getString(2) + " "

+ resultSet.getString(3));

}

// Create and execute an INSERT SQL prepared statement.

String insertSql = "INSERT INTO SalesLT.Product (Name, ProductNumber, Color, StandardCost, ListPrice, SellStartDate) VALUES "

+ "('Bike', 'B1', 'Blue', 50, 120, '2016-01-01');";

prepsInsertProduct = connection.prepareStatement(

insertSql,

Statement.RETURN_GENERATED_KEYS);

prepsInsertProduct.execute();

// Retrieve the generated key from the insert.

resultSet2 = prepsInsertProduct.getGeneratedKeys();

// Print the ID of the inserted row.

while (resultSet2.next()) {

System.out.println("Generated: " + resultSet2.getString(1));

}

}

catch (Exception e) {

e.printStackTrace();

}

finally {

// Close the connections after the data has been handled.

if (prepsInsertProduct != null) try { prepsInsertProduct.close(); } catch(Exception e) {}

if (resultSet != null) try { resultSet.close(); } catch(Exception e) {}

if (resultSet2 != null) try { resultSet2.close(); } catch(Exception e) {}

if (statement != null) try { statement.close(); } catch(Exception e) {}

if (connection != null) try { connection.close(); } catch(Exception e) {}

}

}

}