My97DataPicker

来源：互联网发布：淘宝店铺微淘入口编辑：程序博客网时间：2024/04/28 12:49

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html>  <head>        <script language="javascript" src="My97DatePicker/WdatePicker.js"></script>        <title>My JSP 'first.jsp' starting page</title>     </head>    <body>    <form action="second.jsp" method="post">        <select name="type">    <option value="moto">moto</option>    <option value="nokia">nokia</option>        </select>        <input type="text" name="a" onfocus="new WdatePicker(this)">    <input type="text" name="b" onfocus="new WdatePicker(this)">                   <input type="submit" value="ok">            </form>  </body></html>

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%@ page import="java.sql.*" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html>  <head>        <title>My JSP 'second.jsp' starting page</title>      </head>    <body>    <%         String a=request.getParameter("a");          String b=request.getParameter("b");     try{     Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");     Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=shop","sa","sa");     Statement stmt=con.createStatement();     String sql="select * from users where users_date between '"+a+"' and '"+b+"'";          ResultSet rs=stmt.executeQuery(sql);     while(rs.next()){     out.print(rs.getString(2));     }     }     catch(Exception e){     e.printStackTrace();     }                        %>  </body></html>

DataPicker.rar (93.2 KB)
下载次数: 0