", "操作",JOptionPane.PLAIN_MESSAGE);
}
catch(SQLException ex){
ex.printStackTrace();
}
finally{
if(ps!=null)try{ps.close();}catch(SQLException ignore){}
if(conn!=null)try{conn.close();}catch(SQLException ignore){}
}
}
private boolean roomOccupied(String roomNo)
{
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
boolean occupied=false;
try{
conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Restaurant;user=user;password=user");
ps=conn.prepareStatement("select BookNo from roomBook where roomNo=? and datediff(Day,roomBook.bookDate,CAST(? AS datetime))=0");
ps.setString(1,roomNo);
ps.setString(2,bookDate.getText());
rs=ps.executeQuery();
if(rs.next())
occupied=true;
}
catch(SQLException ex){
ex.printStackTrace();
}
finally{
if(rs!=null)try{rs.close();}catch(SQLException ignore){}
if(ps!=null)try{ps.close();}catch(SQLException ignore){}
if(conn!=null)try{conn.close();}catch(SQLException ignore){}
}
return occupied;
}
void cancel_actionPerformed(ActionEvent e) {
this.dispose();[b
上一篇:
BookSerices.java
下一篇:
爱情只不过就是,爱与不爱