JDBC – MSSQL

n

n

How to connect to your mssql database?

n

nn

Connection connection = null;nResultSet resultSet = null;nStatement statement = null;nString dbConnector= "jdbc:odbc:"; //nString dbname = "myDSNEntry";    //example - remember the System-DSN entry on your machinenString name = "user=";        //ad username after equals signnString pw = "password=";      // add pw after equals signnntry {n   // Load Drivern	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); nn	// get connected to ms sql servern	connection = DriverManager.getConnection(dbConnector + dbname + ";" + name + ";" + pw);n	// checking the database namen	statement = connection.createStatement();n	resultSet = statement.executeQuery("SELECT DB_NAME()");n	resultSet.next();n	String dbname = resultSet.getString(1);n	System.out.println("Connected to database: "+dbname);n	// make queryn	resultSet = statementn		   .executeQuery("select * from tablename");n	while (resultSet.next()) {n	// getString(1) ^= first Rown	   System.out.println(resultSet.getString(1) + " | " + resultSet.getString(2));n	}n	} catch (Exception e) {n	   e.printStackTrace();n	} finally {n		try {n			//close operationsn			resultSet.close();n			statement.close();n			connection.close();n	   } catch (Exception e) {n		   e.printStackTrace();n	   }n	}