📄 listservlet.java
字号:
package shopcart;import java.io.*;import javax.servlet.*;import javax.servlet.http.*;import java.sql.*;public class listServlet extends HttpServlet{ public void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { resp.setContentType("text/html"); resp.setCharacterEncoding("gb2312"); PrintWriter out = resp.getWriter(); out.println("<html><body>"); try { //this code are use to open the database connection //use the jdbc-odbc bridge ,you can use any other jdbc driver //before use this program ,you must change you password and //username,and database //source name(URL,such as jdbc:odbc:test). Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String url="jdbc:microsoft:sqlserver://192.168.228.17:1433;DatabaseName=fancy"; String user="sa"; String password="25121982"; Connection conn =DriverManager.getConnection(url,user,password); Statement stmt=conn.createStatement(); String strSQL="SELECT * FROM goods"; ResultSet rs=stmt.executeQuery(strSQL); ResultSetMetaData rsmd=rs.getMetaData(); int colCount=rsmd.getColumnCount(); //out.println(colCount); int count=1; out.println("<table border='0'>"); out.println("<tr>"); out.println("<td bgcolor='#FFCCCC'>商品名</td>"); out.println("<td bgcolor='#FFCCCC'>类型</td>"); out.println("<td bgcolor='#FFCCCC'>简介</td>"); out.println("<td bgcolor='#FFCCCC'>价格</td>"); out.println("<td bgcolor='#FFCCCC'>折扣</td>"); out.println("<td bgcolor='#FFCCCC'>编号</td>"); out.println("<td bgcolor='#FFCCCC'>数量</td>"); out.println("<td bgcolor='#FFCCCC'>操作</td>"); out.println("</tr>"); while(rs.next()) { out.println("<tr>"); out.println("<td bgcolor='#FFCC33'>"); String name=rs.getString(1); out.println(name); out.println("</td>"); out.println("<td bgcolor='#FFCC33'>"); String type=rs.getString(2); out.println(type); out.println("</td>"); out.println("<td bgcolor='#FFCC33'>"); out.println(rs.getObject(3)); out.println("</td>"); out.println("<td bgcolor='#FFCC33'>"); float price=rs.getFloat(4); out.println(price); out.println("</td>"); out.println("<td bgcolor='#FFCC33'>"); float off=rs.getFloat(5); out.println(off); out.println("</td>"); out.println("<td bgcolor='#FFCC33'>"); int id=rs.getInt(6); out.println(id); out.println("</td>"); out.println("<form method='post' action='shopcart/add.jsp' target='cart'>"); out.println("<input type='hidden' name='name' value="+name+">"); out.println("<input type='hidden' name='type' value="+type+">"); out.println("<input type='hidden' name='price' value="+price+">"); out.println("<input type='hidden' name='off' value="+off+">"); out.println("<input type='hidden' name='id' value="+id+">"); out.println("<td bgcolor='#CCCCCC'><input type='text' name='number' size=4></td>"); out.println("<td bgcolor='#CCCC33'><input type='submit' value='add'></td>"); out.println("</form>"); out.println("</tr>"); count++; } rs.close(); count--; out.println("Total Search Records:"+count); out.println("</table>"); stmt.close(); conn.close(); } catch (Exception fe) { out.println(fe); } out.println("</body></html>"); // to do: code goes here. }}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -