?? 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 + -