JAVA SERVER PAGES

function setDelete(){

if(confirm("Are you sure you want to delete this file?")){

//do something

//of course delete something

}else{

//do nothing

}

}

jgalacambraa at 2007-7-21 9:19:53 >

then it would be:

function setDelete(){

if(confirm("Are you sure you want to delete this file?")){

//do something

//of course delete something

return true;

}else{

//do nothing

return false;

}

}

jgalacambraa at 2007-7-21 9:19:53 >

can be inserted into jsp as scriptlets

RegisterBean rb = (RegisterBean)form;

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();

Connection conn = DriverManager.getConnection("jdbc:odbc:SampleDB","","");

PreparedStatement pstmt = conn.prepareStatement("insert into logintable values(?,?,?,?,?,?,?,?,?,?,?)");

pstmt.setString(1,rb.getUsername());

pstmt.setString(2,rb.getPassword());

pstmt.setString(3,rb.getLastname());

pstmt.setString(4,rb.getFirstname());

pstmt.setString(5,rb.getMiddlename()!=null?rb.getMiddlename():" ");

pstmt.setString(6,rb.getAddress()!=null?rb.getAddress():" ");

pstmt.setString(7,rb.getPhone()!=null?rb.getPhone():" ");

pstmt.setString(8,rb.getEmail());

pstmt.setString(9,rb.getGender());

pstmt.setString(10,rb.getCivilstatus());

pstmt.setString(11,"3");

insert = pstmt.executeUpdate();

conn.commit();

conn.close();

} catch (Exception ex)

{

ex.printStackTrace();

}

jgalacambraa at 2007-7-21 9:19:58 >

see ,this problem can be solved very simply.

do as follow.

when u enter the value,before the cursor move to next field,we have to check the values.

For doing this,

code is:

<input type="text" name="userid" onBlur=checkUserId()>

see function:

checkUserId()

{

<%//here u get connection.

u write the query as follow

ResultSet rs=st.executeQuery("select * from tablename where userid='textfieldvalue';

so that u can test

if(rs.next())

//means alreday exists

else

//not exist.

}

I think u can understood cleary because i had given just a template

Cheers

Sudha.

9819542886.

sudha_1234a at 2007-7-21 9:19:58 >

hi jhe,

how to count a button click?

for example:

<td class="results_col" bgcolor="#F3F3E9"><input type="submit" name="myBox" value="Enable" onClick = "return confirm('Want to Enable?')"></td>

<%

String[] checkboxvalue = request.getParameterValues("myBox");

if(checkboxvalue != null)

{

fileName = rec.getfileName();

String downstatus = "";

batchb.modifydownstatusof(fileName,downstatus.toUpperCase().trim());

}

}

else

{ %>

<td class="results_col" bgcolor="#F3F3E9"> -- </td>

<% }

if i click the button

i should hava a count that how many times i clicked

sudhinaa at 2007-7-21 9:19:58 >

hi jhe,

my tomcat is starting up with this exception,

SEVERE: Catalina.start:

LifecycleException: Protocol handler start failed: java.net.BindException: Addr

ess already in use: JVM_Bind:8080

at org.apache.coyote.tomcat5.CoyoteConnector.start(CoyoteConnector.java:

1529)

at org.apache.catalina.core.StandardService.start(StandardService.java:4

89)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:231

3)

at org.apache.catalina.startup.Catalina.start(Catalina.java:556)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

sorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:324)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:287)

at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:425)

how to solve this,

thanks,

sujatha

sudhinaa at 2007-7-21 9:20:08 >