import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class ConnectionTest {
public static void main(String[] args) {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://localhost:1433;databaseName=myDB";
String username = "myUsername";
String password = "myPassword";
Connection con = DriverManager.getConnection(url, username, password);
System.out.println("Successfully connected to SQL Server.");
con.close();
e.printStackTrace();
}
}
}
public class ConnectionTest {
public static void main(String[] args) {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://localhost:1433;databaseName=myDB;user=myUsername;password=myPassword";
url += ";loginTimeout=10";
url += ";encrypt=true";
url += ";trustServerCertificate=false";
Connection con = DriverManager.getConnection(url);
System.out.println("Successfully connected to SQL Server.");
con.close();
e.printStackTrace();
}
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class QueryTest {
public static void main(String[] args) {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://localhost:1433;databaseName=myDB";
String username = "myUsername";
String password = "myPassword";
Connection con = DriverManager.getConnection(url, username, password);
String sql = "SELECT * FROM myTable";
PreparedStatement pstmt = con.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
int id = rs.getInt("id");
String name = rs.getString("name");
System.out.println("ID: " + id + ", Name: " + name);
}
con.close();
e.printStackTrace();
}
}
}
