?? 7-06.jsp
字號:
<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*"%>
<HTML><BODY>
<%
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException ce){
out.println(ce.getMessage());
}
request.setCharacterEncoding("GBK");
String str = request.getParameter("keywords");
if( str == null)
str = "";
try{
conn=DriverManager.getConnection("jdbc:odbc:grade");
stmt=conn.createStatement();
rs=stmt.executeQuery("SELECT * FROM grade WHERE 姓名 LIKE '%" + str + "%'");
out.print("<TABLE BORDER='1'>");
while(rs.next()){
out.print("<TR><TD>"+rs.getString("學號")+"</TD>");
out.print("<TD>"+rs.getString("姓名")+"</TD>");
out.print("<TD>"+rs.getString("語文")+"</TD>");
out.print("<TD>"+rs.getString("數學")+"</TD>");
out.print("<TD>"+rs.getString("英語")+"</TD></TR>");
}
out.print("</TABLE>");
}
catch(SQLException e){
System.out.println(e.getMessage());
}
finally{
stmt.close();
conn.close();
}
%>
<FORM Action="7-06.jsp" Method=POST>
輸入姓名關鍵字:
<INPUT Type="Text" Name="keywords" Value="<%=str%>"><P>
<INPUT Type=Submit Value=" 執行">
</FORM>
</BODY></HTML>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -