Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.io.BufferedReader;
- import java.io.InputStreamReader;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- public class App {
- static Connection minConnection;
- static Statement stmt;
- static BufferedReader inLine;
- public static void insertprepared() {
- try {
- // indl�sning
- System.out.println("Indtast cpr på den elev du gerne vil finde");
- String cpr = inLine.readLine();
- System.out.println("Indtast fag på eksamen");
- String eksamenNavn = inLine.readLine();
- System.out.println("Indtast den karakter du ønsker at give eleven");
- String karakter = inLine.readLine();
- // Anvendelse af prepared statement
- String sql = "insert into eksamen values (?,?,?)";
- PreparedStatement prestmt = minConnection.prepareStatement(sql);
- prestmt.clearParameters();
- prestmt.setString(1, eksamenNavn);
- prestmt.setLong(2, Long.parseLong(cpr));
- prestmt.setInt(3, Integer.parseInt(karakter));
- // Udf�rer s�tningen
- prestmt.execute();
- // p�nt svar til brugeren
- System.out.println("Karakteren er oprettet");
- if (!minConnection.isClosed())
- minConnection.close();
- } catch (SQLException e) {
- System.out.println("fejlSQL: " + e.getMessage());
- } catch (Exception e) {
- System.out.println("fejl: " + e.getMessage());
- }
- }
- public static void main(String[] args) {
- try {
- inLine = new BufferedReader(new InputStreamReader(System.in));
- // generel opsætning
- // via native driver
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- minConnection = DriverManager.getConnection(
- "jdbc:sqlserver://localhost\\SQLEXPRESS;databaseName=eaadb;user=sa;password=91379137;");
- stmt = minConnection.createStatement();
- // Indlæsning og kald af den rigtige metode
- System.out.println("Indtast s");
- String in = inLine.readLine();
- switch (in) {
- case "s": {
- insertprepared();
- break;
- }
- default:
- System.out.println("ukendt indtastning");
- }
- } catch (Exception e) {
- System.out.println("fejl: " + e.getMessage());
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement