mysql 插入数据出现Unknown column 'aaaaa' in 'field list'

Question

public class DBConnection {

public static final String url = "jdbc:mysql://localhost:3306/news";

public static final String name = "com.mysql.jdbc.Driver";

public static final String user = "root";

public static final String password = "987321";

public Connection conn = null;

public Statement pst = null;

public DBConnection(String sql) {  
    try {  
        Class.forName(name);
    conn = DriverManager.getConnection(url, user, password);
        pst = conn.createStatement();
        pst.execute(sql);


    } catch (Exception e) {  
        e.printStackTrace();  
    }  
}  

public void close() {  
    try {  
        this.conn.close();  
        this.pst.close();  
    } catch (SQLException e) {  
        e.printStackTrace();  
    }  
} 

public static void main(String[] args) {
    String s1 = "aaaaa"; String s2 = "bbbbb"; String s3= "cccccccccccccccccccccccccccccc";
    DBConnection conn = new DBConnection("insert into newscontent(newsType,newsTitle,newsContent) value("+s1+","+s2+","+s3+")");
    conn.close();
}

}

Answer 1

你看看表结构是咋样的撒