📄 index.jsp
字号:
<%@ page language = "java" contentType = "text/html;charset=GBK" pageEncoding = "GBK"%>
<%@ page import = "java.sql.*"%>
<%@ page import = "javax.sql.*"%>
<%@ page import = "javax.naming.*"%>
<html>
<head>
<title>
test datasource!
</title>
</head>
<body>
<%
try{
Connection conn = null;
Context initCtx = new InitialContext();
if(initCtx == null)
throw new Exception("Context can't be getted!");
Context ctx = (Context)initCtx.lookup("java:comp/env");
Object obj = (Object)ctx.lookup("/Default_JDBC");
javax.sql.DataSource ds = (javax.sql.DataSource)obj;
conn = ds.getConnection();
Statement stmt = conn.createStatement();
PreparedStatement ps = conn.prepareStatement("select * from teacher");
ResultSet rs = ps.executeQuery();
while(rs.next()){
out.println(rs.getInt(1));
out.println(rs.getString(2));
out.println(rs.getString(3));
out.println("<br>");
}
rs.close();
stmt.close();
conn.close();
}catch(Exception e){
e.printStackTrace();
}
%>
Hello,everyone!
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -