hi,i have created the following coding.but i cant access java bean from jsp.pls help.
Event.java:
package newEvent;
import java.io.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Event {
private String Event;
public void SetEvent(String Event) {
this.Event = Event;
}
public String GetEvent() {
return Event;
}
public void InsertEvent()
{
try{
Connection con=null;
Statement st=null;
ResultSet rs= null;
Class.forName("sun.jdbc.odbc.Driver");
con=DriverManager.getConnection("jdbc:odbc:College");
st=con.createStatement();
int EventID=0;
String sq="select max(EventID)+1 as EveID from NewEvent";
rs=st.executeQuery(sq);
while(rs.next())
{
EventID=rs.getInt("EveID");
}
if(EventID==0)
EventID=1001;
String sql="insert into NewEvent(EventID,EventDate,Event) values("+EventID+",curdate(),' " + Event + " ')";
System.out.println(sql);
st.executeUpdate(sql);
System.out.println("Event is saved and Your Event ID Is:"+EventID);
}
catch(Exception e)
{
System.out.println(e);
}
}
}
My jsp coding is,
Event.jsp:
package newEvent;
import java.io.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class Event {
private String Event;
public void SetEvent(String Event) {
this.Event = Event;
}
public String GetEvent() {
return Event;
}
public void InsertEvent()
{
try{
Connection con=null;
Statement st=null;
ResultSet rs= null;
Class.forName("sun.jdbc.odbc.Driver");
con=DriverManager.getConnection("jdbc:odbc:College");
st=con.createStatement();
int EventID=0;
String sq="select max(EventID)+1 as EveID from NewEvent";
rs=st.executeQuery(sq);
while(rs.next())
{
EventID=rs.getInt("EveID");
}
if(EventID==0)
EventID=1001;
String sql="insert into NewEvent(EventID,EventDate,Event) values("+EventID+",curdate(),' " + Event + " ')";
System.out.println(sql);
st.executeUpdate(sql);
System.out.println("Event is saved and Your Event ID Is:"+EventID);
}
catch(Exception e)
{
System.out.println(e);
}
}
}
