SQL server

本文介紹JAVA連線SQL server，操作資料庫基本指令方法。 import import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; DB configuration for connection private static String DbUrl "jdbc:sqlserver://xxx.xxx.xxx.xxx:1433;databaseNamexxx"; private static String DbUser "xxx"; private static String DbPassword "xxx"; 資料處理 以下展示實際程式碼範例 (SELECT) import java.sql.Connection; import java.sql.DatabaseMetaData; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; public class run { private static String DbUrl "jdbc:sqlserver://xxx.xxx.xxx.xxx:1433;databaseNamexxx"; private static String DbUser "xxx"; private static String DbPassword "xxx"; public static void main(String args) { Connection connection null; try { connection DriverManager.getConnection(DbUrl, DbUser, DbPassword); connection.setAutoCommit(false); // Print database metadata: not really necessary. // DatabaseMetaData metadata connection.getMetaData(); // System.out.println("Database Name: " + metadata.getDatabaseProductName()); Statement stmt connection.createStatement(); StringBuilder InsertSql new StringBuilder(); // Construct SQL statement InsertSql.append("SELECT * FROM dBo.Mytable"); // Execute SQL statement and get return result set ResultSet rows stmt.executeQuery(InsertSql.toString()); ResultSetMetaData rsmd rows.getMetaData(); // Get return column number int columnCount rsmd.getColumnCount(); int rowRec 1; // Count start from 1 while (rows.next()) { // Row // System.out.println("Row:" + rowRec); // print the row count now for(int i1; i

SQL server

[JAVA] SQL Server Connection

Headline