📄 select.jsp
字号:
<%@ page contentType="text/html;charset=GB2312"%>
<%@ page import="java.sql.*"%>
<HTML>
<HEAD>
<TITLE>select</TITLE>
</HEAD>
<BODY>
<table border=1>
<tr>
<th>姓名</th>
<th>部门</th>
</tr>
<%
String strSql = "select * from tab";
String DBurl = "jdbc:odbc:quchch";
String user = "sa";
String password ="";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(DBurl,user,password);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(strSql);
while(rs.next()){
String name = rs.getString("name");
String dept = rs.getString("dept");
%>
<tr>
<td><%=name%></td>
<td><%=dept%></td>
</tr>
<%
}
rs.close();
stmt.close();
conn.close();
}catch(Exception e){
System.out.println("出错信息：" + e);
}
%>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -