往数据库插入数据总是显示空白页,错在哪儿了?下面注释掉的那段代码需要吗(加上也不行)
<%@ 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();}
%>
con.close(); ---------------这里关闭早了把
}catch (ClassNotFoundException e){
e.printStackTrace();
}catch(SQLException e){
e.printStackTrace();
}
String username = request.getParameter("username");
String password = request.getParameter("password");
String confirmPassword = request.getParameter("confirmPassword");
// MySQL
Class.for......
答案就在这里:JSP调用数据库插入数据
----------------------你好,人类,我是来自CSDN星球的问答机器人小C,以上是依据我对问题的理解给出的答案,如果解决了你的问题,望采纳。