哦,这里是我的一个例子:
try
{
Class.forName(DATABASE[0]).newInstance();
DBConnectionManager connMgr = DBConnectionManager.getInstance();
Connection conn = null;
//ResultSet rs = null;
try
{
//conn = DriverManager.getConnection(DATABASE[1],DATABASE[2],DATABASE[3]);
conn = connMgr.getConnection("wsxk");
}catch(Exception ex){out.println("服务器忙...");}
String procedure = "{call P_XK (?,?,?,?,?,?) }";
CallableStatement cstmt = conn.prepareCall(procedure);
cstmt.setString(1,XH);
cstmt.setString(2,BH);
cstmt.setInt(3,KZH);
cstmt.setInt(4,KCXH);
cstmt.setString(5,IP);
cstmt.registerOutParameter(6,1);
try
{
//rs = cstmt.executeQuery();
cstmt.executeUpdate();
FHZ = cstmt.getString(6).trim();
}
catch(Exception ex)
{
out.println("<img src=\"images/false.gif\" align=\"absmiddle\"> 选课失败,请检查您是否已经选择了该课程。");
windowStatusMsg = "选课失败,请检查您是否已经选择了该课程。";
}
//rs.next();
//FHZ = rs.getString("FHZ");//返回值,用来标识选课结果:B=限选人数已达上限;A=选课成功;5=选时不可选(包含限选人数已达上限);4=该组限选门数已达上限
//rs.close();
cstmt.close();
//conn.close();
connMgr.freeConnection("wsxk", conn); //out.println(FHZ); if(FHZ.compareTo("A") == 0)
{
out.println("<img src=\"images/true.gif\" align=\"absmiddle\"> " + stateMsg[10]);
windowStatusMsg = stateMsg[10];
}
else if(FHZ.compareTo("4") == 0)
{
out.println("<img src=\"images/false.gif\" align=\"absmiddle\"> " + stateMsg[4]);
windowStatusMsg = stateMsg[4];
}
else if(FHZ.compareTo("B") == 0)
{
out.println("<img src=\"images/false.gif\" align=\"absmiddle\"> " + stateMsg[11]);
windowStatusMsg = stateMsg[11];
}
else if(FHZ.compareTo("5") == 0)
{
out.println("<img src=\"images/false.gif\" align=\"absmiddle\"> " + stateMsg[5]);
windowStatusMsg = stateMsg[5];
}
else if(FHZ.compareTo("C") == 0)
{
out.println("<img src=\"images/false.gif\" align=\"absmiddle\"> " + stateMsg[12]);
windowStatusMsg = stateMsg[12];
}
else
{
//out.println("-" + FHZ + "-");
//out.println(stateError);
}
}
catch(Exception ex)
{
//out.println(ex.toString());
//out.println("连接服务器异常。");
}
try
{
Class.forName(DATABASE[0]).newInstance();
DBConnectionManager connMgr = DBConnectionManager.getInstance();
Connection conn = null;
//ResultSet rs = null;
try
{
//conn = DriverManager.getConnection(DATABASE[1],DATABASE[2],DATABASE[3]);
conn = connMgr.getConnection("wsxk");
}catch(Exception ex){out.println("服务器忙...");}
String procedure = "{call P_XK (?,?,?,?,?,?) }";
CallableStatement cstmt = conn.prepareCall(procedure);
cstmt.setString(1,XH);
cstmt.setString(2,BH);
cstmt.setInt(3,KZH);
cstmt.setInt(4,KCXH);
cstmt.setString(5,IP);
cstmt.registerOutParameter(6,1);
try
{
//rs = cstmt.executeQuery();
cstmt.executeUpdate();
FHZ = cstmt.getString(6).trim();
}
catch(Exception ex)
{
out.println("<img src=\"images/false.gif\" align=\"absmiddle\"> 选课失败,请检查您是否已经选择了该课程。");
windowStatusMsg = "选课失败,请检查您是否已经选择了该课程。";
}
//rs.next();
//FHZ = rs.getString("FHZ");//返回值,用来标识选课结果:B=限选人数已达上限;A=选课成功;5=选时不可选(包含限选人数已达上限);4=该组限选门数已达上限
//rs.close();
cstmt.close();
//conn.close();
connMgr.freeConnection("wsxk", conn); //out.println(FHZ); if(FHZ.compareTo("A") == 0)
{
out.println("<img src=\"images/true.gif\" align=\"absmiddle\"> " + stateMsg[10]);
windowStatusMsg = stateMsg[10];
}
else if(FHZ.compareTo("4") == 0)
{
out.println("<img src=\"images/false.gif\" align=\"absmiddle\"> " + stateMsg[4]);
windowStatusMsg = stateMsg[4];
}
else if(FHZ.compareTo("B") == 0)
{
out.println("<img src=\"images/false.gif\" align=\"absmiddle\"> " + stateMsg[11]);
windowStatusMsg = stateMsg[11];
}
else if(FHZ.compareTo("5") == 0)
{
out.println("<img src=\"images/false.gif\" align=\"absmiddle\"> " + stateMsg[5]);
windowStatusMsg = stateMsg[5];
}
else if(FHZ.compareTo("C") == 0)
{
out.println("<img src=\"images/false.gif\" align=\"absmiddle\"> " + stateMsg[12]);
windowStatusMsg = stateMsg[12];
}
else
{
//out.println("-" + FHZ + "-");
//out.println(stateError);
}
}
catch(Exception ex)
{
//out.println(ex.toString());
//out.println("连接服务器异常。");
}
[email protected]