📄 list_all.java
字号:
package project1;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class list_all extends HttpServlet {
private static final String CONTENT_TYPE = "text/html; charset=GBK";
public void init(ServletConfig config) throws ServletException {
super.init(config);
}
public void service(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException
{response.setContentType(CONTENT_TYPE);
PrintWriter out = response.getWriter();
out.println("<html>");
out.println("<head><title>list_all</title></head>");
out.println("<body>");
//验证登录：
HttpSession sess = request.getSession();
if(sess.getAttribute("token")==null){
out.print("对不起，请先登录");
response.setHeader("Refresh","1;URL=login.jsp");
}
else{
//设定编码类型，以便正确解码
request.setCharacterEncoding("GBK");
//设置变量
String str;
//获得要修改的id
String update_id=request.getParameter("frd_id");
//out.print(update_id);
//获得变量
String frd_name=request.getParameter("frd_name");
//out.print(frd_name);
String frd_sex=request.getParameter("frd_sex");
//out.print(frd_sex);
String frd_type=request.getParameter("frd_type");
//out.print(frd_type);
//构造SQL语句
String sqlString=null;
if(frd_sex==null||frd_sex.trim().length()==0){
sqlString="SELECT frd_id,frd_name, frd_type, frd_tele, frd_sex, frd_email, frd_birth, frd_describe FROM friends AS f LEFT JOIN friend_type AS ft ON f.frd_type_id=ft.frd_type_id where frd_belong ='"+sess.getAttribute("token")+"'";
}else{
sqlString="SELECT frd_id,frd_name, frd_type, frd_tele, frd_sex, frd_email, frd_birth, frd_describe FROM friends AS f LEFT JOIN friend_type AS ft ON f.frd_type_id=ft.frd_type_id where frd_belong ='"+sess.getAttribute("token")+"'and frd_sex='"+frd_sex.trim()+"'";
}
if(frd_name==null||frd_name.trim().length()==0)
;//什么都不做
else{
sqlString = sqlString+" and frd_name='"+frd_name+"'";
}
if(frd_type==null||frd_type.trim().length()==0)
;
else{
sqlString = sqlString+" and frd_type='"+frd_type+"'";
}
//String sqlString = "SELECT * FROM friends where frd_belong ='"+sess.getAttribute("token")+"'";
Connection conn;
Statement sql,sql2,sql3,sql4;
ResultSet rs,rs2,rs3,rs4;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception e)
{
out.print("类找不到！");
}
try
{
conn=DriverManager.getConnection("jdbc:odbc:myaddressBook");
sql=conn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
sql2=conn.createStatement();
sql3=conn.createStatement();
sql4=conn.createStatement();
//text
/*rs2=sql2.executeQuery("SELECT count(*) AS topmark FROM friend_type");
rs2.next();
int topmark = rs2.getInt("topmark");
out.print(topmark);
rs2.close();*/
rs=sql.executeQuery(sqlString);
out.print("<Table Border style='font-size: 10pt'>");
out.print("<TR><td colspan=10 align=center>朋友信息</td></tr>");
out.print("<TR>");
out.print("<form action=list_all name=form1 method=post >");
out.print("<tr><td>查询条件：</td>");
out.print("<td colspan=6>");
out.print("姓名：<input type=text name=frd_name>");
//性别选项
out.print(" 性别：<select name=frd_sex>");
out.print("<option value='男' selected>男</option>");
out.print("<option value='女' selected>女</option>");
out.print("<option value='' selected>所有</option></select>");
//朋友类别选项
out.print(" 朋友类别：<select name=frd_type>");
rs3 = sql3.executeQuery("select * from friend_type");
while(rs3.next()){
//out.print(rs3.getString("frd_type"));
String type = rs3.getString("frd_type");
out.print("<option value='"+type+"' selected>"+type+"</option>");
}
out.print("<option value='' selected>所有</option></select>");
rs3.close();
out.print(" <input type=submit value=提交>");
out.print("</td>");
out.print("<td><a href='add_new.jsp'>增加好友</a>");
out.print("</td></tr></form>");
//out.print("<Td width=120 >"+"朋友编号");
out.print("<Td width=120 >"+"朋友姓名");
out.print("<Td width=120 >"+"朋友类别");
out.print("<Td width=120 >"+"朋友电话");
out.print("<Td width=120 >"+"性别");
out.print("<Td width=120 >"+"e-mail");
out.print("<Td width=120 >"+"朋友生日");
out.print("<Td width=120 >"+"描述");
out.print("<td width=120>"+"操作");
out.print("</TR>");
if(update_id==null){
while(rs.next())
{ out.print("<TR>");
str=rs.getString("frd_id");
//out.print("<TD >"+rs.getString("frd_id")+"</TD>");
out.print("<TD >"+rs.getString("frd_name")+"</TD>");
out.print("<TD >"+rs.getString("frd_type")+"</TD>");
out.print("<TD >"+rs.getString("frd_tele")+"</TD>");
out.print("<TD >"+rs.getString("frd_sex")+"</TD>");
out.print("<TD >"+rs.getString("frd_email")+"</TD>");
out.print("<TD >"+rs.getString("frd_birth")+"</TD>");
out.print("<TD >"+rs.getString("frd_describe")+"</TD>");
out.print("<td><a href='list_all?frd_id="+str+"'>修改</a> or <a href='delete?frd_id="+str+"'>删除</a></td>");
out.print("</TR>") ;
}
rs.close();
conn.close();
}
//<----页面修改---->
else{
int frd_id;
String update_frd_type_id;
String update_frd_type;
rs.beforeFirst();
while(rs.next()){
out.print("<TR>");
frd_id = rs.getInt("frd_id");
if(frd_id==Integer.valueOf(update_id)){
out.print("<form name='form11' method='post' action='xiugai'>");
out.print("<TR>");
out.print("<input type='hidden' value='"+update_id+"' name='frd_id'>");
out.print("<td> <input type='text' name='frd_name' value='"+rs.getString("frd_name")+"' maxlength='12' size='12'/></td>");
out.print("<td><select name=update_frd_type_id>");
rs4 = sql4.executeQuery("select * from friend_type");
while(rs4.next()){
update_frd_type_id=rs4.getString("frd_type_id");
update_frd_type = rs4.getString("frd_type");
out.print("<option value='"+update_frd_type_id+"' selected>"+update_frd_type+"</option>");
}
out.print("<option value='0' selected>"+rs.getString("frd_type")+"(当前设置)</option></select>");
rs4.close();
out.print("</td>");
out.print("<td> <input type='text' name='frd_tele' value='"+rs.getString("frd_tele")+"' maxlength='12' size='12'/></td>");
out.print("<td> <input type='text' name='frd_sex' value='"+rs.getString("frd_sex")+"' maxlength='12' size='12'/></td>");
out.print("<td> <input type='text' name='frd_email' value='"+rs.getString("frd_email")+"' maxlength='12' size='12'/></td>");
out.print("<td> <input type='text' name='frd_birth' value='"+rs.getString("frd_birth")+"' maxlength='12' size='12'/></td>");
out.print("<td> <input type='text' name='frd_describe' value='"+rs.getString("frd_describe")+"' maxlength='12' size='12'/></td>");
out.print("<td><input type='submit' name='submit' value='确认提交'/></td>");
out.print("</TR>");
out.print("</form>");
}
else{
str=rs.getString("frd_id");
out.print("<TD >"+rs.getString("frd_name")+"</TD>");
out.print("<TD >"+rs.getString("frd_type")+"</TD>");
out.print("<TD >"+rs.getString("frd_tele")+"</TD>");
out.print("<TD >"+rs.getString("frd_sex")+"</TD>");
out.print("<TD >"+rs.getString("frd_email")+"</TD>");
out.print("<TD >"+rs.getString("frd_birth")+"</TD>");
out.print("<TD >"+rs.getString("frd_describe")+"</TD>");
out.print("<td><a href='list_all?frd_id="+str+"'>修改</a> or <a href='delete?frd_id="+str+"'>删除</a></td>");
}
}
}
}catch(SQLException e1)
{
out.print(e1);
}
}
out.println("</body></html>");
out.close();
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -