📄 trydatabase.jsp

📁 教务管理系统,能够实现大部分学校教务工作的内容.

💻 JSP

字号:

<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'TryDatabase.jsp' starting page</title>
    
    <meta http-equiv="pragma" content="no-cache">
    <meta http-equiv="cache-control" content="no-cache">
    <meta http-equiv="expires" content="0">
    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
    <meta http-equiv="description" content="This is my page">
    
    <!--
    <link rel="stylesheet" type="text/css" href="styles.css">
    -->
  </head>
  
  <body>
<% 
	Connection con;
	Statement stm;
	ResultSet rs;
	try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e){out.print("-----"+e);}
	try{	
		String  url="jdbc:odbc:linbaowei";  
		String user="sa";
		String password="linbaowei";
		con=DriverManager.getConnection(url,user,password); 
		stm=con.createStatement();
		String condition="insert into Student_RP values(2,'234',2,'1','1')";
		try{stm.executeUpdate(condition);}
		catch(Exception df){out.print("-----"+df);}
		con.close();
		}
		catch (Exception ee)
		{out.print("-----"+ee);}
%>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -