📄 testconn.jsp
字号:
<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="erp.dao.*" %>
<%@ page import="erp.stru.*" %>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>
testConn
</title>
</head>
<body>
<h1>
JBuilder Generated JSP
</h1>
<%
ConnFactory connFactory = ConnFactory.getInstance();
Connection conn = connFactory.getConnection( connFactory.getConnName(1));
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from test");
while ( rs.next() ) {
out.println( rs.getString(1) + ":" + rs.getString(2) + "<br>" );
}
rs.close();
stmt.close();
connFactory.freeConnection(connFactory.getConnName(1), conn);
ErrorTable errorTable = new ErrorTable( request );
errorTable.Slog_username = "吴继勇";
errorTable.Slog_program = "testConn";
errorTable.Slog_status = "正常";
errorTable.Slog_remark = "备注";
LogDbFactory.getInstance().WriteDB(errorTable);
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -