Validation Issues & Image submission In JSP project.

Question

I am new to jsp and I am trying to make an apllication form in jsp which saves the details of the member in the mysql . Connectivity part is done it is taking in the details and saving them to mysql DB , issue is that few columns like pincode , mobile number & fax  ,validation is not working with them .

Please suggest me how to add validation to these columns .

Also I am trying to save the image of the applicant but it takes the image as an attachment and when I try to fetch the data from DB it only shows the attachment not the image .

Answer 1

When You are deleting records,

You can write query as

delete table AU_Delete

or
delete from table au_Delete.

you have to use * only in select queries.

try this

 SqlConnection con = new SqlConnection("Data Source=APPLE;Initial Catalog=sam;Integrated Security=True");

            SqlCommand cmd = new SqlCommand();

            cmd.Connection = con;

            con.Open();

            string str1 = "DELETE  AU_Delete";

            cmd.CommandText = str1;

            cmd.ExecuteNonQuery();

            con.Close();

          

Answer 2

Mohammed Shamsheer,

you can't write '*' for the delete Statements

string Query="delete from AU_DELETE";

Answer 3

Hi,

Remove '*' from your SQL Query and use

string str1 = "DELETE FROM AU_Delete";

You don't need to specify '*' for DELETE statement.