📄 newresult.jsp

📁 可以让初学者有一个感性的认识

💻 JSP

字号:

<HTML>
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*" %>

<BODY bgcolor=pink><Font size=3>

<%	String name=request.getParameter("name");
	if(name ==null) name ="";
	byte b[]=name.getBytes("ISO-8859-1");
	name=new String(b);
	
	String newMath=request.getParameter("math");
	if(newMath ==null) newMath ="-100";
	
	String newEnglish=request.getParameter("english");
	if(newEnglish ==null) newEnglish ="-100";
	
	String newPhysics=request.getParameter("physics");
	if(newPhysics ==null) newPhysics ="-100";
	
	Connection con=null;
	Statement sql=null;
	ResultSet rs=null;
	
	String xingming,number;
	int math,english,physics;
	
	try
	{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	}catch(ClassNotFoundException e){}
	
	try
	{
		con=DriverManager.getConnection("jdbc:odbc:sun","","");
		sql=con.createStatement();
		String condition1="UPDATE students SET 数学成绩="+newMath+" WHERE 姓名="+"'"+name+"'";
		String condition2="UPDATE students SET 英语成绩="+newEnglish+" WHERE 姓名="+"'"+name+"'";
		String condition3="UPDATE students SET 物理成绩="+newPhysics+" WHERE 姓名="+"'"+name+"'";
		sql.executeUpdate(condition1);
		sql.executeUpdate(condition2);
		sql.executeUpdate(condition3);
	}catch(SQLException e1){}
%>

<P>数据库更新后的数据记录

<%	
	try
	{	rs=sql.executeQuery("SELECT * FROM students");
		out.print("<Table Border>");
			out.print("<TR>");
				out.print("<TH width=100>"+"学号");
				out.print("<TH width=100>"+"姓名");
				out.print("<TH width=50>" +"数学成绩");
				out.print("<TH width=50>" +"英语成绩");
				out.print("<TH width=50>" +"物理成绩");
			out.print("</TR>");
			while(rs.next())
			{
				out.print("<TR>");
					out.print("<TD>"+ rs.getString(1)+"</TD>");
					out.print("<TD>"+ rs.getString(2)+"</TD>");
					out.print("<TD>"+ rs.getInt("数学成绩")+"</TD>");
					out.print("<TD>"+ rs.getInt("英语成绩")+"</TD>");
					out.print("<TD>"+ rs.getInt("物理成绩")+"</TD>");
				out.print("</TR>");
			}
		out.print("</Table>");
		con.close();
	}catch(SQLException e1){}
%>

</FONT>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -