package com.hisoft.web;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.text.SimpleDateFormat;
import oracle.jdbc.driver.*;
import java.util.*;
import java.util.Date;
/**
* Servlet Class
*
* @web.servlet name="Submit"
* display-name="Name for Submit"
* description="Description for Submit"
* @web.servlet-mapping url-pattern="/Submit"
* @web.servlet-init-param name="A parameter"
* value="A value"
*/
public class Submit extends HttpServlet {
public Submit() {
super();
}
protected void doGet(HttpServletRequest req, HttpServletResponse res)
throws ServletException,
IOException {
doPost(req,res);
}
protected void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException,
IOException {
PrintWriter out = null;
String uname = null;
String ui = null;
HttpSession session = req.getSession();
uname=(String)session.getAttribute("username");
ui=(String)session.getAttribute("userid");
System.out.println(uname);
out = res.getWriter();
String tid = req.getParameter("tId");
String tname = req.getParameter("topicName");
String cont = req.getParameter("content");
System.out.println(tname);
System.out.println(cont);
System.out.println(tid);
// -------if input is empty or not-------------
if(uname==null){
out.println("<html><body>");
out.println(" You must input name and password");
out.println("<br><input type='button' value='return' onclick=\"window.location.href='/testweb/index.html'\">");
out.println("</body></html>");
}
ResultSet rset = null;
Statement stmt =null;
res.setContentType("text/html");
Connection con = null;
String URL = "jdbc:oracle:thin:@3.242.120.16:1521:ORA92";
String USER = "myuser";
String PASSWORD= "myuser";
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(URL,USER,PASSWORD);
System.out.println("9");
}catch (SQLException e) {
e.printStackTrace();
}catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
//------Create createstatemennt----
stmt = con.createStatement ();
SimpleDateFormat df=new SimpleDateFormat("yyyyMMdd HH:mm:ss");
String s=df.format(new Date());
String td = s;
System.out.println(td);
System.out.println(ui);
PreparedStatement pstmt = con.prepareStatement("update mb_topic set NAME=?,CONTENT=?,T_DATE=? where ID=?");
pstmt.setString(1,tname);
pstmt.setString(2,cont);
pstmt.setString(3,td);
pstmt.setString(4,tid);
rset = pstmt.executeQuery();
if(rset.next()){
out.println("<html><body>");
out.println(" This operation is successful!");
out.println("<br><input type='button' value='return' onclick=\"window.location.href='/testweb/myMessage.jsp'\">");
out.println("</body></html>");
return;
}
}catch (SQLException e) {
e.printStackTrace();
}finally{
try {
rset.close();
stmt.close();
}catch (SQLException e) {
e.printStackTrace();
}
}
}
}
