jsp1.jsp

来自「java」· JSP 代码 · 共 35 行

<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.io.*,java.util.*,java.lang.*,java.sql.*" %>
<%@ page import="erp.html.*,erp.stru.table.*,erp.trade.*,erp.dao.ConnFactory" %>
<html>
<head>
<title>
Jsp1
</title>
</head>
<body>
<%
int iBack = 0;
ConnFactory connFactory = ConnFactory.getInstance();
Connection conn = connFactory.getConnection(connFactory.getConnName());
try {
  String sQuery = "UPDATE dg_main set bcph=?,bchh=? where bcph=? and bchh=?";
  PreparedStatement pstmt = conn.prepareStatement( sQuery );
  pstmt.setString( 1, "aaa" );
  pstmt.setString( 2, "bbb" );
  pstmt.setString( 3, "333" );
  pstmt.setString( 4, "444" );
  iBack = pstmt.executeUpdate();
  pstmt.close();
}
catch ( SQLException e ) {
  iBack = -1;
}
finally {
  connFactory.freeConnection(connFactory.getConnName(),conn);
}
out.println( iBack );
%>
</body>
</html>