<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" import="java.sql.*"%> Insert title here

论文成果信息表

<% request.setCharacterEncoding("utf-8"); Class.forName("com.mysql.jdbc.Driver"); String username = "root"; String url = "jdbc:mysql://127.0.0.1:3306/teamessage?serverTimezone=UTC"; String password = "1314"; Connection conn = DriverManager.getConnection(url,username,password); String sql = "SELECT * from article"; Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql); while(rs.next()){ int id = rs.getInt(1); %> <% } rs.close(); stmt.close(); conn.close(); %>
论文作者 论文题目 论文奖项
<%=rs.getString("authArticle")%> <%=rs.getString("titleArticle")%> <%=rs.getString("prizeArticle")%>