把catch放到最后去。import java.io.*;
import java.sql.*;
public class expic{ public expic() {
} public String showpic(String str)
{
{
String returnString = null;
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dboil" ;
Connection conn = DriverManager.getConnection(url,"sa","sa");
Statement stmt = conn.createStatement();
String sql= "select top 1 al_id from well_alarm where wl_id='"+str+"' and al_receive_time is null order by al_come_time ";
ResultSet rs = stmt.executeQuery(sql);
if (rs.next())
{
returnString = "<img border=0 src=images/red.gif width=20 height=30>";
}
else
{
returnString="<img border=0 src=images/blue.gif width=20 height=30>"; } stmt.close();
conn.close();
}
catch(Exception ex){//××××××××××
} //×××××××××× return returnString;
}
}
}
import java.sql.*;
public class expic{ public expic() {
} public String showpic(String str)
{
{
String returnString = null;
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dboil" ;
Connection conn = DriverManager.getConnection(url,"sa","sa");
Statement stmt = conn.createStatement();
String sql= "select top 1 al_id from well_alarm where wl_id='"+str+"' and al_receive_time is null order by al_come_time ";
ResultSet rs = stmt.executeQuery(sql);
if (rs.next())
{
returnString = "<img border=0 src=images/red.gif width=20 height=30>";
}
else
{
returnString="<img border=0 src=images/blue.gif width=20 height=30>"; } stmt.close();
conn.close();
}
catch(Exception ex){//××××××××××
} //×××××××××× return returnString;
}
}
}
解决方案 »
- 关于注册时的验证码(后台报错,前台正常)
- 一点小问题 谢谢
- javamail处理https格式邮件的问题
- FileUpload问题
- 我在oracle中写了一个存储过程(带参数),请问在jsp中如何调用这个过程啊???急急急
- 关于在jsp页面上利用代码画图(急!!!救命!新手)
- 请问有关于struts框架的中英文互译或英文的资料吗
- 为什么写在<textarea>中的文字无论是硬回车还是软回车,在提交之后都检测不出来呢?
- 有没有什么标签可以屏蔽掉CSS对某一段HTML代码的解析?急!
- 如何配置jdk的环境变量
- 我用ie打开word文件的问题
- asp取出来的数据变成word,最好有源代码,高分,在线等
把它声明为全局的