1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package opkd;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
import org.apache.commons.dbutils.DbUtils;
/**
*
* @author jane
*/
public class insert_update_training extends HttpServlet {
/**
* Processes requests for both HTTP
* <code>GET</code> and
* <code>POST</code> methods.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("UTF8");
PrintWriter out = response.getWriter();
Boolean result = true;
Integer id = null;
Date d_from = null;
Date d_to = null;
String d_from1 = null;
String d_to1 = null;
Integer dir_id = null;
Integer doc_id = null;
String doc_num = null;
String doc_date1 = null;
Date doc_date = null;
String note = null;
Integer place_id = null;
String protocol_date1 = null;
Date protocol_date = null;
String protocol_num = null;
Integer type_id = null;
Integer card_id = null;
String oper = null;
Connection con = null;
PreparedStatement ps = null;
DataSource datasource = null;
try {
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
datasource = (DataSource) envCtx.lookup("jdbc/oracle");
oper = request.getParameter("oper");
SimpleDateFormat dateFormat = new SimpleDateFormat("dd.MM.yyyy");
if (!oper.equals("del")) {
d_from1 = request.getParameter("d_from").trim();
d_to1 = request.getParameter("d_to").trim();
try {
d_from = dateFormat.parse(d_from1);
d_to = dateFormat.parse(d_to1);
if (d_from.before(d_to) == false&&!d_from1.equals(d_to1)) {
result = false;
}
} catch (ParseException ex) {
Logger.getLogger(insert_update_training.class.getName()).log(Level.SEVERE, null, ex);
}
dir_id = Integer.parseInt(request.getParameter("dir_name"));
doc_id = Integer.parseInt(request.getParameter("doc_name"));
doc_num = request.getParameter("doc_num");
doc_date1 = request.getParameter("doc_date");
if (!doc_date1.equals("")) {
doc_date = dateFormat.parse(doc_date1);
}
note = request.getParameter("note");
place_id = Integer.parseInt(request.getParameter("place_name"));
protocol_date1 = request.getParameter("protocol_date");
if (!protocol_date1.equals("")) {
protocol_date = dateFormat.parse(protocol_date1);
}
protocol_num = request.getParameter("protocol_num");
type_id = Integer.parseInt(request.getParameter("type_name"));
card_id = Integer.parseInt(request.getParameter("card_id"));
out.println("card_id=" + card_id);
}
if (oper.equals("edit") || oper.equals("del")) {
id = Integer.parseInt(request.getParameter("id").trim());
}
con = datasource.getConnection();
// con.setAutoCommit(false);
con.prepareStatement("ALTER SESSION SET CURRENT_SCHEMA = OPKD").execute();
if (result == true) {
if (oper.equals("add")) {
ps = con.prepareStatement("insert into opkd.training "
+ " (id,"
+ " card_id,"
+ " d_from,d_to,"
+ " type_id,place_id,"
+ " SPECIALITY,"
+ " doc_id,doc_num,doc_date,"
+ " protocol_num,protocol_date,"
+ " note)"
+ " values (opkd.training_seq.nextval,?,?,?,?,?,?,?,?,?,?,?,?)");
ps.setInt(1, card_id);
ps.setDate(2, new java.sql.Date(d_from.getTime()));
ps.setDate(3, new java.sql.Date(d_to.getTime()));
ps.setInt(4, type_id);
ps.setInt(5, place_id);
ps.setInt(6, dir_id);
if (doc_id == 0) {
ps.setNull(7, java.sql.Types.INTEGER);
ps.setNull(8, java.sql.Types.VARCHAR);
ps.setNull(9, java.sql.Types.DATE);
} else {
ps.setInt(7, doc_id);
ps.setString(8, doc_num);
ps.setDate(9, new java.sql.Date(doc_date.getTime()));
}
if (protocol_num.equals("")) {
ps.setNull(10, java.sql.Types.VARCHAR);
ps.setNull(11, java.sql.Types.DATE);
} else {
ps.setString(10, protocol_num);
ps.setDate(11, new java.sql.Date(protocol_date.getTime()));
}
if (note.equals("")) {
ps.setNull(12, java.sql.Types.VARCHAR);
} else {
ps.setString(12, note);
}
ps.executeUpdate();
} else if (oper.equals("edit")) {
ps = con.prepareStatement(" update opkd.training"
+ " set"
+ " d_from=?,"
+ " d_to=?,"
+ " type_id=?,"
+ " place_id=?,"
+ " SPECIALITY=?,"
+ " doc_id=?,"
+ " doc_num=?,"
+ " doc_date=?,"
+ " protocol_num=?,"
+ " protocol_date=?,"
+ " note=?"
+ " where id=?");
ps.setDate(1, new java.sql.Date(d_from.getTime()));
ps.setDate(2, new java.sql.Date(d_to.getTime()));
ps.setInt(3, type_id);
ps.setInt(4, place_id);
ps.setInt(5, dir_id);
if (doc_id == 0) {
ps.setNull(6, java.sql.Types.INTEGER);
ps.setNull(7, java.sql.Types.VARCHAR);
ps.setNull(8, java.sql.Types.DATE);
} else {
ps.setInt(6, doc_id);
ps.setString(7, doc_num);
ps.setDate(8, new java.sql.Date(doc_date.getTime()));
}
if (protocol_num.equals("")) {
ps.setNull(9, java.sql.Types.VARCHAR);
ps.setNull(10, java.sql.Types.DATE);
} else {
ps.setString(9, protocol_num);
ps.setDate(10, new java.sql.Date(protocol_date.getTime()));
}
if (note.equals("")) {
ps.setNull(11, java.sql.Types.VARCHAR);
} else {
ps.setString(11, note);
}
ps.setInt(12, id);
ps.executeUpdate();
} else if (oper.equals("del")) {
ps = con.prepareStatement("update OPKD.TRAINING set is_error=0 where id =?");
ps.setInt(1, id);
ps.executeUpdate();
ps.executeUpdate();
}
}
} catch (ParseException ex) {
Logger.getLogger(insert_update_training.class.getName()).log(Level.SEVERE, null, ex);
} catch (NamingException ex) {
Logger.getLogger(insert_update_training.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(insert_update_training.class.getName()).log(Level.SEVERE, null, ex);
} finally {
DbUtils.closeQuietly(ps);
DbUtils.closeQuietly(con);
}
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/**
* Handles the HTTP
* <code>GET</code> method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Handles the HTTP
* <code>POST</code> method.
*
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Returns a short description of the servlet.
*
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return "Short description";
}// </editor-fold>
}
