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();
}
}
}