Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package opg7;
- import java.io.BufferedReader;
- import java.io.InputStreamReader;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.Statement;
- public class Miniprojekt {
- static Connection minConnection;
- static Statement stmt;
- static BufferedReader inLine;
- public static void main(String[] args) {
- try {
- inLine = new BufferedReader(new InputStreamReader(System.in));
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- minConnection = DriverManager.getConnection(
- "jdbc:sqlserver://localhost\\SQLEXPRESS;databaseName=Miniprojekt;user=sa;password=1234;");
- stmt = minConnection.createStatement();
- karakter();
- } catch (Exception e) {
- System.out.println("Fejl: " + e.getMessage());
- }
- }
- public static void karakter() {
- try {
- // Indlæser søgestreng
- System.out.println("Indtast cpr på studerende");
- String cpr = inLine.readLine();
- System.out.println("Indtast eksamens id");
- String eksamen = inLine.readLine();
- System.out.println("Indtast karater");
- String karakter = inLine.readLine();
- System.out.println("Indtast dato(yyyy-mm-dd)");
- String dato = inLine.readLine();
- // Laver sql-sætning og før den udført
- String sql = String.format("insert into eksamensforsøg values(%s, %s, %s, '%s')", cpr, eksamen, karakter,
- dato);
- System.out.println("SQL-streng er " + sql);
- // pæn lukning
- if (!minConnection.isClosed()) {
- minConnection.close();
- }
- } catch (Exception e) {
- System.out.println("fejl: " + e.getMessage());
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement