我是新手,我对jsp中提取java代码到一个类中不是很熟,希望高手帮我提取一下。我jsp中代码如下
<%@ page language="java" import="java.util.*,cndbk.disp.*"
pageEncoding="GB2312"%>
<%@ page import="cndbk.database.*,java.sql.*,javax.sql.*;"%><%
String sql,s,s2;
ResultSet rs ,rs4;
int a,d,e;
s = request.getParameter("id");
s2 = request.getParameter("type");
int did = Integer.parseInt(s);
DBConnect dbc = new DBConnect();
//DBConnect connect=new DBConnect();
try{
sql = "SELECT COUNT(id) as ad FROM evaluation WHERE DAY(create_time)-DAY(NOW())<1 AND user_id=8 AND interpret_id="+did;
ResultSet rs2 = dbc.executeQuery(sql);
a=rs2.getInt("ad");
if(a==1){
out.println("你不能在同一天对同一条解释进行评价");
}else{
sql="INSERT INTO evaluation(interpret_id,f_e,user_id) VLUES("+did+",'"+s2+"',8)" ;
dbc.executeUpdate();
}
}catch(SQLException sqle){
System.out.println(sqle);
}
try{
sql="SELECT interpret_id FROM evaluation ";
rs=dbc.executeQuery(sql);
while(rs.next()){
int c=rs.getInt(0);
s="SELECT COUNT(interpret_id) as fl FROM evaluation WHERE interpret_id="+c+"AND type='flower'";
dbc.executeQuery(s);
d=rs.getInt("fl");
s="SELECT COUNT(interpret_id) as egg FROM evaluation WHERE interpret_id="+c+"AND type='egg'";
e=rs.getInt("egg");
%>
<html>
<head>
<title>My JSP 'jifen.jsp' starti</title>
</head><body>
<table width="513" height="135" border="1" align="center">
<tr>
<td width="74" height="34" align="center" bgcolor="#99CCCC">
<div align="center">id</div>
</td>
<td width="94" align="center" bgcolor="#99CCCC">
<div align="center">鲜花数</div>
</td>
<td width="94" align="center" bgcolor="#99CCCC">
<div align="center">鸡蛋数</div>
</td>
</tr> <tr> </div>
<%--<%while(rs.next()){%>--%>
<td>
<div align="center"><%=rs.getInt("intpret_id")%>
</td>
<td>
<div aligin="center"><A href="jifen.jsp?id=<%=rs.getInt("intpret_id")%>&type=flower" title="鲜花"><%=d%></A>
</td>
<td>
<div align="center"><A href="jifen.jsp?<%=rs.getInt("intpret_id")%>&type=egg" title="鸡蛋"><%=e%></A>
</td>
</tr>
<%}}catch(SQLException sqle){
System.out.println(sqle);
}%>
</table>
</body>
</html>
<%@ page language="java" import="java.util.*,cndbk.disp.*"
pageEncoding="GB2312"%>
<%@ page import="cndbk.database.*,java.sql.*,javax.sql.*;"%><%
String sql,s,s2;
ResultSet rs ,rs4;
int a,d,e;
s = request.getParameter("id");
s2 = request.getParameter("type");
int did = Integer.parseInt(s);
DBConnect dbc = new DBConnect();
//DBConnect connect=new DBConnect();
try{
sql = "SELECT COUNT(id) as ad FROM evaluation WHERE DAY(create_time)-DAY(NOW())<1 AND user_id=8 AND interpret_id="+did;
ResultSet rs2 = dbc.executeQuery(sql);
a=rs2.getInt("ad");
if(a==1){
out.println("你不能在同一天对同一条解释进行评价");
}else{
sql="INSERT INTO evaluation(interpret_id,f_e,user_id) VLUES("+did+",'"+s2+"',8)" ;
dbc.executeUpdate();
}
}catch(SQLException sqle){
System.out.println(sqle);
}
try{
sql="SELECT interpret_id FROM evaluation ";
rs=dbc.executeQuery(sql);
while(rs.next()){
int c=rs.getInt(0);
s="SELECT COUNT(interpret_id) as fl FROM evaluation WHERE interpret_id="+c+"AND type='flower'";
dbc.executeQuery(s);
d=rs.getInt("fl");
s="SELECT COUNT(interpret_id) as egg FROM evaluation WHERE interpret_id="+c+"AND type='egg'";
e=rs.getInt("egg");
%>
<html>
<head>
<title>My JSP 'jifen.jsp' starti</title>
</head><body>
<table width="513" height="135" border="1" align="center">
<tr>
<td width="74" height="34" align="center" bgcolor="#99CCCC">
<div align="center">id</div>
</td>
<td width="94" align="center" bgcolor="#99CCCC">
<div align="center">鲜花数</div>
</td>
<td width="94" align="center" bgcolor="#99CCCC">
<div align="center">鸡蛋数</div>
</td>
</tr> <tr> </div>
<%--<%while(rs.next()){%>--%>
<td>
<div align="center"><%=rs.getInt("intpret_id")%>
</td>
<td>
<div aligin="center"><A href="jifen.jsp?id=<%=rs.getInt("intpret_id")%>&type=flower" title="鲜花"><%=d%></A>
</td>
<td>
<div align="center"><A href="jifen.jsp?<%=rs.getInt("intpret_id")%>&type=egg" title="鸡蛋"><%=e%></A>
</td>
</tr>
<%}}catch(SQLException sqle){
System.out.println(sqle);
}%>
</table>
</body>
</html>
--------------------------------
不太明白,解释一下具体是想做什么
* $Id:$
*/
package answer;
import java.util.*;
import cndbk.disp.*;
import java.sql.*;
import javax.sql.*;
import cndbk.database.*; class Hello {
public void test() {
String sql,s,s2;
ResultSet rs ,rs4;
int a,d,e;
s = request.getParameter("id");
s2 = request.getParameter("type");
int did = Integer.parseInt(s);
DBConnect dbc = new DBConnect();
// DBConnect connect=new DBConnect();
try{
sql = "SELECT COUNT(id) as ad FROM evaluation WHERE DAY(create_time)-DAY(NOW())<1 AND user_id=8 AND interpret_id="+did;
ResultSet rs2 = dbc.executeQuery(sql);
a=rs2.getInt("ad");
if(a==1){
System.out.println("你不能在同一天对同一条解释进行评价");
}else{
sql="INSERT INTO evaluation(interpret_id,f_e,user_id) VLUES("+did+",'"+s2+"',8)" ;
dbc.executeUpdate();
}
}catch(SQLException sqle){
System.out.println(sqle);
}
try{
sql="SELECT interpret_id FROM evaluation ";
rs=dbc.executeQuery(sql);
while(rs.next()){
int c=rs.getInt(0);
s="SELECT COUNT(interpret_id) as fl FROM evaluation WHERE interpret_id="+c+"AND type='flower'";
dbc.executeQuery(s);
d=rs.getInt("fl");
s="SELECT COUNT(interpret_id) as egg FROM evaluation WHERE interpret_id="+c+"AND type='egg'";
e=rs.getInt("egg");
while(rs.next()){
System.out.println(rs.getInt("intpret_id"));
System.out.println(rs.getInt("intpret_id"));
System.out.println(rs.getInt("intpret_id"));
}
}
}catch(SQLException sqle){
System.out.println(sqle);
}
}
}
ok 全部提取了