用struts:Connect2.java:package com;import java.io.IOException;import java.io.PrintWriter;
import java.sql.*;
import java.util.ArrayList;
import java.util.List;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import org.apache.struts2.ServletActionContext;import com.opensymphony.xwork2.ActionSupport;public class Connect2 extends ActionSupport { protected String select() throws ServletException, IOException {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost/shangpin";
String user = "root";
String password = "root";
try{
Class.forName(driver);
Connection conn = DriverManager.getConnection(url,user,password);
if(!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");
Statement statement = conn.createStatement();
String sql = "select richang from shenghuo";
ResultSet rs = statement.executeQuery(sql);
String name = "1";
ArrayList list = new ArrayList();
while(rs.next()){
name = rs.getString("richang");
list.add(name);
System.out.println(name);
}
rs.close();
conn.close();
}catch(ClassNotFoundException e){
System.out.println("Sorry,can't find the Driver");
e.printStackTrace();
}catch(SQLException e){
e.printStackTrace();
}catch(Exception e){
e.printStackTrace();
}
return SUCCESS;
}
}struts.xml:
<struts> <constant name="struts.devMode" value="false" />
<package name="default" extends="struts-default">
<action name="post" class="com.Connect2" method="select">
<result name="success">index.jsp</result>
</action>
</package></struts>index.jsp:<form action="post" method="select">
<div id="1" style="display:none; position:absolute; left:112px; top:15px;border:1px solid; width:100px">
<li>${name}</li>
</div>
</form>用servlet:Connect3.java:
package com;import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;public class Connect3 extends HttpServlet { public void init(ServletConfig config) throws ServletException {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost/shangpin";
String user = "root";
String password = "root";
try{
Class.forName(driver);
Connection conn = DriverManager.getConnection(url,user,password);
if(!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");
Statement statement = conn.createStatement();
String sql = "select richang from shenghuo";
ResultSet rs = statement.executeQuery(sql);
String name = "1";
String text="";
while(rs.next()){
name = rs.getString("richang");
text += name;
System.out.println(name);
}
System.out.println(text);
rs.close();
conn.close();
}catch(ClassNotFoundException e){
System.out.println("Sorry,can't find the Driver");
e.printStackTrace();
}catch(SQLException e){
e.printStackTrace();
}catch(Exception e){
e.printStackTrace();
}
}
}web.xml: <servlet>
<servlet-name>servlet</servlet-name>
<servlet-class>com.Connect3</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>servlet</servlet-name>
<url-pattern>/ms</url-pattern>
</servlet-mapping>index.jsp:<form method="ms">
<div id="1" style="display:none; position:absolute; left:112px; top:15px;border:1px solid; width:100px">
<li>${name}</li>
</div>
</form>坐等
import java.sql.*;
import java.util.ArrayList;
import java.util.List;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;import org.apache.struts2.ServletActionContext;import com.opensymphony.xwork2.ActionSupport;public class Connect2 extends ActionSupport { protected String select() throws ServletException, IOException {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost/shangpin";
String user = "root";
String password = "root";
try{
Class.forName(driver);
Connection conn = DriverManager.getConnection(url,user,password);
if(!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");
Statement statement = conn.createStatement();
String sql = "select richang from shenghuo";
ResultSet rs = statement.executeQuery(sql);
String name = "1";
ArrayList list = new ArrayList();
while(rs.next()){
name = rs.getString("richang");
list.add(name);
System.out.println(name);
}
rs.close();
conn.close();
}catch(ClassNotFoundException e){
System.out.println("Sorry,can't find the Driver");
e.printStackTrace();
}catch(SQLException e){
e.printStackTrace();
}catch(Exception e){
e.printStackTrace();
}
return SUCCESS;
}
}struts.xml:
<struts> <constant name="struts.devMode" value="false" />
<package name="default" extends="struts-default">
<action name="post" class="com.Connect2" method="select">
<result name="success">index.jsp</result>
</action>
</package></struts>index.jsp:<form action="post" method="select">
<div id="1" style="display:none; position:absolute; left:112px; top:15px;border:1px solid; width:100px">
<li>${name}</li>
</div>
</form>用servlet:Connect3.java:
package com;import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;public class Connect3 extends HttpServlet { public void init(ServletConfig config) throws ServletException {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost/shangpin";
String user = "root";
String password = "root";
try{
Class.forName(driver);
Connection conn = DriverManager.getConnection(url,user,password);
if(!conn.isClosed())
System.out.println("Succeeded connecting to the Database!");
Statement statement = conn.createStatement();
String sql = "select richang from shenghuo";
ResultSet rs = statement.executeQuery(sql);
String name = "1";
String text="";
while(rs.next()){
name = rs.getString("richang");
text += name;
System.out.println(name);
}
System.out.println(text);
rs.close();
conn.close();
}catch(ClassNotFoundException e){
System.out.println("Sorry,can't find the Driver");
e.printStackTrace();
}catch(SQLException e){
e.printStackTrace();
}catch(Exception e){
e.printStackTrace();
}
}
}web.xml: <servlet>
<servlet-name>servlet</servlet-name>
<servlet-class>com.Connect3</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>servlet</servlet-name>
<url-pattern>/ms</url-pattern>
</servlet-mapping>index.jsp:<form method="ms">
<div id="1" style="display:none; position:absolute; left:112px; top:15px;border:1px solid; width:100px">
<li>${name}</li>
</div>
</form>坐等
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货