-
Notifications
You must be signed in to change notification settings - Fork 1
/
-brijco5.jsp
103 lines (88 loc) · 2.83 KB
/
-brijco5.jsp
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
<%--
Document : f4
Created on : Jan 26, 2009, 11:04:53 AM
Author : db2admin
--%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import ="java.util.*"%>
<%@page import ="java.sql.*"%>
<%@page import ="java.io.Serializable"%>
<%@page import="java.io.*"%>
<%@page import ="java.net.*"%>
<%@page import="javax.servlet.*"%>
<%@page import ="javax.servlet.http.*"%>
<%@page import ="java.lang.*"%>
<%
PreparedStatement pstmt, pstmtq, pstmt1, pstmt2, pstmtw,pstmt3,pstmtn;
HttpSession ses=request.getSession(true);
Enumeration enume = null;
java.util.Date now = new java.util.Date();
String date=""+now.getDate()+"";
String day=""+now.getDay()+"";
String sem=(String)ses.getAttribute("sem");
String sec=(String)ses.getAttribute("sec");
String roll=(String)ses.getAttribute("roll");
String branch=(String)ses.getAttribute("branch");
ses.setAttribute("sem",sem);
ses.setAttribute("branch",branch);
ses.setAttribute("sec",sec);
enume=request.getParameterNames();
//Connection con = DriverManager.getConnection("jdbc:odbc:zx","scott","tiger");
Connection conn = DriverManager.getConnection("jdbc:odbc:attendance");
// char c[];
String data="";
int p=2,prl=0;
%>
<form action="-brijco2sp.jsp">
<%
while(enume.hasMoreElements())
{
data=(String)enume.nextElement();
int len= data.length();
for(int i=0;i<len;i++)
{
if(data.charAt(i)=='w')
{
//out.println(i);
prl=i;
}
}
//out.println(len);
//String s1=new String(data,0,2);
/*for(int i=0;i<prl;i++)
{
c[i] =data.charAt(i);
}
String pr=new String(c);
out.println("PRIORITY IS==="+pr);
*/
String pr=data.substring(0,prl);
//out.println("PRIORITY="+pr);
String da=data.substring(prl+1,len);
// out.println("date="+da);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String qu = "select * from csjan where roll=?";
pstmtw = conn.prepareStatement(qu);
pstmtw.setString(1,roll);
ResultSet rs = pstmtw.executeQuery();
int q = 0;
String s = "vvvvvvvvvvv";
while (rs.next())
{
s = rs.getString(da);
}
StringBuffer sb = new StringBuffer(s);
p=Integer.parseInt(pr);
int qw=2;
sb.setCharAt(p-1,'e');
String sd=sb+"";
String strii="UPDATE csjan SET "+da+"=? WHERE roll =?" ;
//pstmt2 = con.prepareStatement(strii);
pstmt2 = conn.prepareStatement(strii);
pstmt2.setString(1,sd);
pstmt2.setString(2,roll);
pstmt2.executeUpdate();
}
//response.sendRedirect("co2sp.jsp");
%>
<input type=submit value=89></form>