package project1;
import java.sql.*;

public class labb1 {
    public static void main(String[]args) throws SQLException {
      labb1 skrivut = new labb1();
      labb1 addAnst = new labb1();
      String string;
      string = skrivut.namn();
      System.out.println(string);
      addAnst.addAnst("Fredag", "lund", 44312, "AP8", "A2", "777");
    }

  public String namn() throws SQLException{
          try{
            DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
            //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // också ok
            } catch(Exception e) {
            System.out.println("Kan inte hitta database driver class: " + e);
            }
          String namn ="";
            Connection con = DriverManager.getConnection
            ("JDBC:ODBC:mysrv;database=fafa;");

            Statement stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery("select pname from patient p, lider l where p.ppnr = l.ppnr and sname = 'insomnia'");
            while(rs.next()){
            namn += rs.getString(1)+"\n";
          }
          return namn;
  }
  public void addAnst(String namn, String adress, int lon, String pnr, String avd, String tel) throws SQLException{
          try{
            DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
            //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // också ok
            } catch(Exception e) {
            System.out.println("Kan inte hitta database driver class: " + e);
            }
            Connection con = DriverManager.getConnection
            ("JDBC:ODBC:mysrv;database=fafa;");

            Statement stmt = con.createStatement();
            stmt.executeUpdate("insert into anst values("+pnr+","+namn+", "+adress+", "+tel+", "+avd+", +lon+)");
  }

}




Exception in thread "main" java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]The name "AP8" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.