81,122
社区成员




public String sqlQuery(String num) {
Connection conn = null;
String connStr;
try {
connStr = "jdbc:microsoft:sqlserver://10.1.72.15:1433;DatabaseName=test";// "jdbc:oracle:thin:@local:1521:orcl";
DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
conn = DriverManager.getConnection(connStr, "sa", "");
PreparedStatement st = conn.prepareStatement("select * from NEIKON_NEWS where id=?");
st.setString(1, num);
ResultSet rs = st.executeQuery();
Array ry = rs.getArray(6);
String content = (String) ry.getArray();
return content;
} catch (SQLException ex) {
System.out.println("Error in Connecting to the Database " + '\n' + ex.toString());
} finally {
if (conn != null) {
try {
conn.close();
} catch (Exception ex) {}
}
}
}
String content=(String)ry.getArray();
return content; // 这里已经return 啦
conn.close(); // 这里就不可能被执行了
}catch(SQLException ex) {
public String test(){
return "hello";
String s="world";
}
st.setString(1, num);
ResultSet rs=st.executeQuery();
if(rs...)
{
Array ry=rs.getArray(6);
}
String id=request.getParameter("id");
if(!id.Equals(""))
{
String context=sqlQuery(id);
.....
}