beantest.java

Grid based Search Engine

package p;
import java.sql.*;
public class beantest
{
Connection con;
public beantest()
{
}
public void connect() throws Exception
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 con=DriverManager.getConnection("jdbc:odbc:search");
}
public int insertmsg(String to,String from,String date,String sub,String msg) throws Exception
{
String sql="insert into sendmail values(?,?,?,?,?)";
PreparedStatement st=con.prepareStatement(sql);
st.setString(1,to);
st.setString(2,from);
st.setString(3,date);
st.setString(4,sub);
st.setString(5,msg);
int i=st.executeUpdate();
return i;
}

}