📄 chaxingming.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY background="1.jpg" ><Font size=4>
<%!//处理中文字符串的函数
public String codeToString(String str)
{
String s=str;
try
{
byte tempB[]=s.getBytes("ISO-8859-1");
s=new String(tempB);
return s;
}
catch(Exception e)
{
return s;
}
}
%>
<%//构造查询SQL语句
String sqlString=null;
String name=codeToString(request.getParameter("xingming"));
if(name==null || name.trim().length()==0)
sqlString=new String("select * from student");
else
sqlString=new String("select * from student where name like '%"+name.trim()+"%'");
%>
<%
Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e)
{out.print(e.toString());}
try
{
con=DriverManager.getConnection("jdbc:odbc:student");
sql=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery(sqlString);
rs.last();
int rowNumber=rs.getRow();
out.print("<table border>");
out.print("<tr><td colspan=9 align=center>用户数据(共"+rowNumber+"条记录)</td></tr>");
out.print("<tr>");
out.print("<td width=130>"+"学号");
out.print("<td width=100>"+"姓名");
out.print("<td width=100>"+"性别");
out.print("<td width=100>"+"专业");
out.print("<td width=100>"+"高数");
out.print("<td width=100>"+"C语言");
out.print("<td width=100>"+"JAVA");
out.print("<td width=100>"+"JSP");
out.print("<td width=100>"+"英语");
out.print("</tr>");
rs.beforeFirst();
while(rs.next())
{
out.print("<tr>");
out.print("<td>"+rs.getString("sno")+"</td>");
out.print("<td>"+rs.getString("name")+"</td>");
out.print("<td>"+rs.getString("sex")+"</td>");
out.print("<td>"+rs.getString("zhuanye")+"</td>");
out.print("<td>"+rs.getInt("gaoshu")+"</td>");
out.print("<td>"+rs.getInt("Cyuyan")+"</td>");
out.print("<td>"+rs.getInt("JAVA")+"</td>");
out.print("<td>"+rs.getInt("JSP")+"</td>");
out.print("<td>"+rs.getInt("English")+"</td>");
out.print("</tr>");
}
out.print("</table>");
con.close();
}
catch(SQLException el)
{out.print("");}
%>
</FONT>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -