<%@ page language="java" isThreadSafe="true" import="java.sql.*,java.util.*" %> <%@ page import="javax.mail.*" %> <%@ page import="javax.activation.*" %> <%@ page import="javax.mail.internet.*" %> <%! String to,driver,type,from,msg,err,sub,connectionstring,qq,Tomail; Connection con; Statement stat,stat1; ResultSet rs1,rs; boolean st,st2; int new_mail; %> <% err=" "; String sccode=request.getParameter("sccode"); String selectstudents=request.getParameter("stuselect"); String simrequire=request.getParameter("simrequire"); String hindimedium=request.getParameter("hindim"); String englishmedium=request.getParameter("englishm"); String englishreq=request.getParameter("englishs"); String hindireq=request.getParameter("hindis"); String mathsreq=request.getParameter("mathss"); String sciencereq=request.getParameter("sciences"); String socialreq=request.getParameter("socialsciences"); ///////////////login check from database/////////////////// try { driver="org.gjt.mm.mysql.Driver"; connectionstring="jdbc:mysql://210.212.144.102/test"; //?user=root1"; Class.forName(driver).newInstance(); con=DriverManager.getConnection(connectionstring,"root1","vivek"); //con.autoCommit(false); stat = con.createStatement(); qq="insert into bedmaterial (sccode,selectstudents,simrequire,hindimedium,englishmedium,englishreq,hindireq,mathsreq,sciencereq,socialreq) values('"+sccode+"',"+selectstudents+","+simrequire+","+hindimedium+","+englishmedium+","+englishreq+","+hindireq+","+mathsreq+","+sciencereq+","+socialreq+")"; //('"+to+"','"+from+"','"+msg+"','"+sub+"','"+type+"','N',current_date)"; stat.executeQuery(qq); //"insert into message_clap (To_msg,from_msg,msg,subject,msg_type,read_status,post_date,mailed) values('"+to+"','"+from+"','"+msg+"','"+sub+"','"+type+"','N',current_date,'N')"); //st = rs.next(); /* Properties props = new Properties(); props.put("mail.smtp.host","210.212.144.100");//"mail.bhojvirtualuniversity.com" Session msession = Session.getDefaultInstance(props, null); Message msg1 = new MimeMessage(msession); InternetAddress toAddrs = new InternetAddress(Tomail); msg1.addRecipient(Message.RecipientType.TO, toAddrs); msg1.setSubject(sub); String frm=(String)session.getValue("mail"); msg1.setFrom(new InternetAddress(frm)); msg1.setText(msg); Transport.send(msg1); */ con.close(); //} //end of else }//end of try catch(Exception ee) { out.println("Exception Occurred"+ee.toString()); /*err="Sorry "; err+=" "+from+" , We couldn't sent your message to ";*/ } err="Your requirement Successfully post "; %>

Thank You