📄 testmysql.jsp

📁 java大型企业DRP系统源码带sql数据库

💻 JSP

字号:

<%@ page language="java" contentType="text/html; charset=GB18030"
    pageEncoding="GB18030"%>
<%@page import="javax.sql.*" %>    
<%@page import="java.sql.*" %>
<%@page import="javax.naming.*" %>
<%
	DataSource ds = null;
	Connection conn = null;
	Statement stmt = null;
	ResultSet rs = null;
	try {
		Context initContext = new InitialContext();
		Context ctx = (Context)initContext.lookup("java:comp/env");
		ds = (DataSource)ctx.lookup("jdbc/drp");
		conn = ds.getConnection();
		stmt = conn.createStatement();
		rs = stmt.executeQuery("select * from t_user");
		while (rs.next()) {
			out.println(rs.getString(1));
		}
	}catch(Exception e) {
		e.printStackTrace();
	}finally {
	try {
		if (rs != null) {rs.close();}
		if (stmt != null){stmt.close();}
		if (conn != null){conn.close();}
	}catch(SQLException e)	{} 
	}
 %>
    
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GB18030">
<title>Insert title here</title>
</head>
<body>=&nbsp;


</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -