Problems in inserting data to MS Access Database

[Ashok Pradhan]

I have a table named Questions
Columns are:-
Columns DataType
ID -AutoNumber
QUESTION -Memo
OPTION_A -Memo
OPTION_B -Memo
OPTION_C -Memo
OPTION_D -Memo
EXPLANATION -Memo
POS_MARK - Number

This is my program to insert some value in question Table (Yes I have created DSN named QuizExam)
but this generate an error:-

Exception in thread "main" java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'What is your Name'.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(JdbcOdbcStatement.java:288)
at AccessConn.main(AccessConn.java:58)

Process completed.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;

public class AccessConn {
        
    /**
     * Creates a new instance of <code>AccessConn</code>.
     */
    public AccessConn() {
    	
    	
    	
    }
    public Connection getConnection()throws Exception{
    	
    	
    		
    		String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
    		String url = "jdbc:odbc:QuizExam";
    		String user = "";
    		String password = "";
    		Class.forName(driver);
    		
    		return DriverManager.getConnection(url,user,password);
    
    }
    
    /**
     * @param args the command line arguments
     */
    public static void main(String[] args)throws Exception {
        // TODO code application logic here
        
        AccessConn ac = new AccessConn();
        Connection conn = ac.getConnection();
        Statement st = conn.createStatement();
        String q = "What is your Name";
        int crt_ans = 3;
        String opA = "Ashok";
        String opB = "mimu";
        String opC = "sunil";
        String opD = "titu";
        String expl = "No Explanation";
        int posMark = 4;
        
        String sql = "INSERT INTO Questions "+"(QUESTION,CRT_ANS,OPTION_A,OPTION_B,OPTION_C,OPTION_D,EXPLANATION,POS_MARK)"+" VALUES "+"("+q+","+crt_ans+","+opA+","+opB+","+opC+","+opD+","+expl+","+posMark+")";
		
		st.executeUpdate(sql);
    }
}

[Scott Selikoff]

Use a PreparedStatement, they are far superior to Statements and would likely resolve what looks like a data encoding issue (you didn't put quotes around the values).