Advertisement
Guest User

Untitled

a guest
Dec 18th, 2018
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.47 KB | None | 0 0
  1. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  2. String host = "jdbc:sqlserver://<hostname>";
  3. String username = "<username>";
  4. String password = "<password>";
  5. Connection conn = DriverManager.getConnection(host, username, password);
  6. Statement st = conn.createStatement();
  7. String SQL = 'INSERT INTO <table>(<column 1>, <column 2>, ... ) VALUES("'+tfHvT.getText()+'", "'+tfNS.getText()+'", "'+tfTdn.getText()+'", "'+tfMk.getText()+'") ';
  8. st.executeUpdate(SQL);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement