<body>
<SCRIPT language=JavaScript>
function qiandao1(){
<%
try{
Connection con;
Statement sql;
Statement sql1;
ResultSet rs;
Class.forName("com.mysql.jdbc.Driver");
String dbUrl="jdbc:mysql://localhost:3306/jf";
String dbUsr="root";
String dbPwd="23322535";
Calendar c = Calendar.getInstance();//可以对每个时间域单独修改
int year = c.get(Calendar.YEAR);
int month = c.get(Calendar.MONTH)+1;
int day = c.get(Calendar.DATE);
con=java.sql.DriverManager.getConnection(dbUrl,dbUsr,dbPwd);
sql=con.createStatement();
sql1=con.createStatement();
//String id=request.getParameter("id");
rs=sql.executeQuery("select year,month from qian where day='"+day+"'");
while(rs.next()){
%>
if(<%=rs.getInt(1)%>==<%=year%>&&<%=rs.getInt(2)%>==<%=month%>)
{var result = confirm("你今天已签过到了。");
alert(result);}
else{
<%sql1.executeUpdate("INSERT INTO qian(year, month, day) VALUES('"+year+"', '"+month+"','"+day+"')"); %>
var result1 = confirm("签到成功！");
alert(result1);
}
<%
}
rs.close();
sql.close();
sql1.close();
}catch(Exception e1){out.println(e1.toString());}
%>
}
</SCRIPT>
<input type="submit" name="submit2" value="test" style="border:0;FONT-SIZE: 9pt;background:#FF0000;color:#FFFFFF" onclick="qiandao1()"/>
</body>
图为数据库数据
