📄 untitled.jsp~6~

📁 一个完整的门户网站,基于JSP环境下开发的,使用SQL数据库.

💻 JSP~6~

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.bwm.model.User" %>
<%@ page import="com.bwm.model.Guestboard" %>
<%@ page import="com.bwm.core.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<!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=gb2312">
<title>无标题文档</title>
</head>
<body bgcolor="#ffffff">
<h1>
JBuilder Generated JSP
</h1>
<br>
<%
        Connection con = null;
        ResultSet rs = null;
        Statement ps = null;
        try {
                Class.forName("com.mysql.jdbc.Driver");
                //Class.forName("org.gjt.mm.mysql.Driver");
            con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/mingri");
            ps = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
//            rs = ps.executeQuery("SELECT * FROM (user) WHERE name ='顾问'");
            rs = ps.executeQuery("SELECT * FROM (link) WHERE name ='网易'");
            while (rs.next()) {
                out.print(rs.getString("uid"));
                out.print("aaaaaa");
            }
        }catch(Exception e){
            out.print(e.getMessage());
           e.printStackTrace();
        }finally{
                        try{
                con.close();
                        }catch(Exception e){}

                }
%>
<br>
</body>
</html>
<strong></strong>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -