|
Connection conn=null;
??Statement stmt=null;
??ResultSet rs=null;
??String sql="";
?????? PrintWriter out=response.getWriter();
?????? request.setCharacterEncoding("gb2312");
??????
???? long stars=Long.parseLong(request.getParameter("starts"));
???? long ends=Long.parseLong(request.getParameter("ends"));
???? System.out.println("输入的第一个数："+stars);
???? System.out.println("输入的第二个数："+ends);
????? try?
????? {?
????? Class.forName( "com.microsoft.sqlserver.jdbc.SQLServerDriver" );?
????? conn = DriverManager.getConnection( "jdbc:sqlserver://localhost:1433;databaseName=MyOffice","sa","sa" );?
????
????? stmt=conn.createStatement();?
????? sql="select * from subgrouptable";?
????? rs=stmt.executeQuery(sql);?
??????????? int k=0;
????? while(rs.next())?
????? {?
????? ?
????? ?if(((stars>=Long.parseLong(rs.getString("starts"))&&stars<=Long.parseLong(rs.getString("ends")))
????? ?||(ends>=Long.parseLong(rs.getString("starts"))&&ends<=Long.parseLong(rs.getString("ends"))))
????? ?&&(stars!=-1&&ends!=-1)
????? ?
????? ?){
????? ??
????? ??k=k+1;
????? ??break;
????? ?}
????? ?if((stars<=Long.parseLong(rs.getString("starts"))&&ends>=Long.parseLong(rs.getString("ends")))&&
????? ???(stars!=-1&&ends!=-1)){
????? ??
????? ??k=k+1;
????? ??break;
????? ?}
?????????
????? ?
????? ?//Long.parseLong(rs.getString("starts"));
????? ?//Long.parseLong(rs.getString("ends"));
????? }?
????? if(k==0){
????? System.out.println("输入正确");
????? }else{
????? ?System.out.println("输入错误");
????? }
//????? Iterator<jihe> itr = listall.iterator();
//????? while (itr.hasNext()) {
//???????????? System.out.println(itr.next().getStarts());
//????? }
?????
?????
????? rs.close();?
????? stmt.close();?
????? conn.close();?
????? }?
????? catch(Exception e)?
????? {?
????? e.printStackTrace();?
????? }?
????? }?
?
}
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
