Java เชื่อมต่อกับ Microsoft SQL Server смотреть онлайн

*********ขออภัยในเสียงรบกวนด้วยนะครับ*********

****ลิงค์โหลด jdbc Driver for SQL Server ****
https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver15

**********โค้ด**********
/*Insert Into producttype*/

package test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class insertProtype {

public static void main(String[] args) {
String url = ("jdbc:sqlserver://localhost;databaseName=CoffeeShop;user=sa;password=1234");
Connection connect = null;
Statement s = null;

try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
connect = DriverManager.getConnection(url);
System.out.println("Connected Complete");

s = connect.createStatement();

String sql = " Insert Into Product_type Values ('PT01','Coffee'),('PT02','Bekery') ";

s.execute(sql);

System.out.println("Successfully");
} catch (Exception e) {
System.out.println("Error");
e.printStackTrace();
}
try {
s.close();
connect.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}

==========================================================================================================================

/*Insert Into product*/

package test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class insertProduct {

public static void main(String[] args) {
String url = ("jdbc:sqlserver://localhost;databaseName=CoffeeShop;user=sa;password=1234");
Connection connect = null;
Statement s = null;

try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
connect = DriverManager.getConnection(url);
System.out.println("Connected Complete");

s = connect.createStatement();

String sql = " Insert Into Product " +
" Values ('P001','Mocha','50','PT01'), " +
" ('P002','Americano','60','PT01'), " +
" ('P003','Donut','30','PT02'), " +
" ('P004','Pancake','30','PT02') ";
s.execute(sql);

System.out.println("Successfully");
} catch (Exception e) {
System.out.println("Error");
e.printStackTrace();
}
try {
s.close();
connect.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}

==========================================================================================================================

/*Select*/

package test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;

public class Select {

public static void main(String[] args) {
String url = ("jdbc:sqlserver://localhost;databaseName=CoffeeShop;user=sa;password=1234");
Connection connect = null;
Statement s = null;

try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
connect = DriverManager.getConnection(url);
System.out.println("Connected Complete");

s = connect.createStatement();

String sql = " Select Pro_Name, Protype_Name From Product P inner join Product_type PT on P.Protype_id = PT.Protype_id ";
ResultSet rec = s.executeQuery(sql);

while((rec!=null) && (rec.next()))
{
System.out.print("ชื่อสินค้า ");
System.out.print(rec.getString("Pro_Name"));
System.out.print(" ประเภทสินค้า ");
System.out.println(rec.getString("Protype_Name"));
}
} catch (Exception e) {
System.out.println("Error");
e.printStackTrace();
}
try {
s.close();
connect.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}