Question

JDBC连接数据库 ，我要创建两条sql语句怎么办？

<script language="javascript" type="text/javascript">
<% Connection conn = null;
ResultSet rs = null;
PreparedStatement ps = null;
String sql = "select BC_ID,NAME,FID from JY_BUSINESS_CATEGORY where LEVELS=2";
conn = DBConnect.getConn();
ps = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs = ps.executeQuery();
int i = 0;%>
var arrData=new Array();
<%while (rs.next()) {%>
arrData[<%=i%>]=new Array("<%=rs.getString("NAME")%>","<%=rs.getString("FID")%>","<%=rs.getString("BC_ID")%>");
<%i++;
}
rs.close();
ps.close();
conn.close();%></script>
===============================================
<script type="text/javascript">

<% Connection conn1 = null;
ResultSet rs1 = null;
PreparedStatement ps1 = null;
String sql1 = "select BC_ID,NAME,FID from JY_BUSINESS_CATEGORY where LEVELS=3";
conn1 = DBConnect.getConn();
ps1 = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs1 = ps1.executeQuery();
int j = 0;%>
var arrData1=new Array();
<%while (rs1.next()) {%>
arrData1[<%=j%>]=new Array("<%=rs1.getString("NAME")%>","<%=rs1.getString("FID")%>","<%=rs1.getString("NAME")%>");
<%j++;
}
rs1.close();
ps1.close();
conn1.close();%></script>
这样写的话 报 java.sql.SQLException: 关闭的连接这个错误 该怎么写？

Answer 1

你定义的Connection conn1 = null;
但是你在使用ps1 = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE,
conn conn1不知道是不是这里错误，你看下

Answer 2

<script language="javascript" type="text/javascript">
<% Connection conn = null;
ResultSet rs = null;
PreparedStatement ps = null;
String sql = "select BC_ID,NAME,FID from JY_BUSINESS_CATEGORY where LEVELS=2";
conn = DBConnect.getConn();
ps = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs = ps.executeQuery();
int i = 0;%>
var arrData=new Array();
<%while (rs.next()) {%>
arrData[<%=i%>]=new Array("<%=rs.getString("NAME")%>","<%=rs.getString("FID")%>","<%=rs.getString("BC_ID")%>");
<%i++;
}
rs.close();
ps.close();
//这里不要关conn.close();%></script>
===============================================
<script type="text/javascript">

<% //这里不需要 Connection conn1 = null;
ResultSet rs1 = null;
PreparedStatement ps1 = null;
String sql1 = "select BC_ID,NAME,FID from JY_BUSINESS_CATEGORY where LEVELS=3";
//不需要conn1 = DBConnect.getConn();
ps1 = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs1 = ps1.executeQuery();
int j = 0;%>
var arrData1=new Array();
<%while (rs1.next()) {%>
arrData1[<%=j%>]=new Array("<%=rs1.getString("NAME")%>","<%=rs1.getString("FID")%>","<%=rs1.getString("NAME")%>");
<%j++;
}
rs1.close();
ps1.close();
//conn1.close();
conn.close();%></script>
一个Connection可以干好多事情的 而且很占资源 不要重复的去开于关