📄 example5_11.jsp.bak

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

💻 BAK

字号:

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

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

<%!		Connection con=null;
%>

<%		
		Statement sql=null;
		ResultSet rs=null;
		if(con==null)
		{
			try
			{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			}catch(ClassNotFoundException e){out.print(e);}
			try
			{
	con=DriverManager.getConnection("jdbc:odbc:moon","sa","");
			sql=con.createStatement();
			rs=sql.executeQuery("SELECT * FROM students");
			out.print("I am the first.");
			} catch(SQLException e1){ out.print(e1);}
		}
		else
		{
			synchronized(con)
			{
				try
				{
					sql=con.createStatement();
					rs=sql.executeQuery("SELECT * FROM students");
					out.print("I am not the first.");
				} catch(SQLException e1){ out.print(e1);}
			}
		}
		try
		{
			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>");
		}catch(SQLException e1){}
%>

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

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -