jsp调用数据库插入数据失败

Question

往数据库插入数据总是显示空白页，错在哪儿了？下面注释掉的那段代码需要吗（加上也不行）

<%@ page contentType="text/html;charset=gb2312" import="java.util.*" language="java"%>
<% request.setCharacterEncoding("gb2312"); %>
<%@ page import="java.io.*,java.sql.*"%>
<%
/*String gysname=request.getParameter("gysname");

String dm=request.getParameter("dm");

String address=request.getParameter("address");
String uzbm=request.getParameter("uzbm");
String lxr=request.getParameter("lxr");
String tel=request.getParameter("tel");*/
Connection con;
String sql;

try{

Class.forName("oracle.jdbc.driver.OracleDriver");

String dbUrl = "jdbc:oracle:thin:@localhost:1521:sale";//这里要写上IP地址和oracle的那个数据库的服务名
String dbUser = "tanton";
String dbPwd = "******";

con = DriverManager.getConnection(dbUrl,dbUser,dbPwd);
sql="INSERT INTO AGENCY_CONFIG(AGENCY_CODE，AGENCY_NAME，MAILING_ADDRESS，ZIP_CODE，SUPERVISOR，TELEPHONE，BANK_NAME) VALUES('03','呵呵','菏泽','274000','王老板','5555555')";

Statement stmt=con.createStatement();

PreparedStatement pst = con.prepareStatement(sql);

/*pst.setString(1,dm);
pst.setString(2,gysname);
pst.setString(3,address);
pst.setString(4,uzbm);
pst.setString(5,lxr);
pst.setString(6,tel);*/
pst.executeUpdate();
out.println("插入记录执行成功!");
}
catch(Exception e){
e.printStackTrace();}
%>

Answer 1

con.close(); ---------------这里关闭早了把
}catch (ClassNotFoundException e){
e.printStackTrace();
}catch(SQLException e){
e.printStackTrace();
}