81,094
社区成员
发帖
与我相关
我的任务
分享这个应该怎么做?
/*
* 创建日期 2004-6-21
*
* 更改所生成文件模板为
* 窗口 > 首选项 > Java > 代码生成 > 代码和注释
*/
package test;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
//import java.util.*;
/**
* @author Administrator
*
* 更改所生成类型注释的模板为
* 窗口 > 首选项 > Java > 代码生成 > 代码和注释
*/
public class helloservlet extends HttpServlet {
private static final String CONTENT_TYPE="text/html;charset=GBK";
public void init() throws ServletException{
}
public void doGet(HttpServletRequest request,HttpServletResponse response) throws
ServletException,IOException{
response.setContentType(CONTENT_TYPE);
ServletOutputStream out=response.getOutputStream();
out.println("<html>");
out.println("<head><title>heeeee</title></head>");
out.println("<body bgcolor=\"#00ffff\">");
out.println("<form method=get action=hl>");
out.println("<input type=text name=username>");
out.println("<input type=password name=password>");
out.println("<input type=button value=提交>");
out.println("</form>");
out.println("<table>");
out.println("<tr>");
out.println("<td>");
out.println("NAME");
out.println("</td>");
out.println("<td>");
out.println("PASSWORD");
out.println("</td>");
out.println("<tr>");
Connection connection,con1;
Statement statement,st;
ResultSet resultset=null,rs;
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
connection=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pms1_1hq","sa","");
statement=connection.createStatement();
con1=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pms1_1hq","sa","");
st=con1.createStatement();
rs=st.executeQuery("select * from gg_employee );
while (rs.next())
{
out.println("<TR>");
out.println("<TD>");
out.println(rs.getString("员工姓名"));
out.println("</TD>");
out.println("<TD>");
out.println(rs.getString("口令"));
out.println("</TD>");
out.println("</TR>");
}
con1.close();
}
catch(Exception e)
{//System.out.println(e);
e.printStackTrace();
}
out.println("</table>");
out.print("sdaf"+request.getRemoteAddr());
out.print("<br>");
out.print("</br>");
out.print("<a href=a.jsp>");
out.print( "sadfasfd");
out.print("</a>");
//out.print("</center>");
out.print("<input type=submit value=汉字> ");
out.print("</form>");
out.print("</body></html>");
}
public void destroy(){}
}
这个servlet能把数据库 中的内容全部显示出来,现在我想实现如下功能:
在一打开次页得时候,显示出上面的查询按钮,输入一个东西到username中后,点按扭从数据库中查询出仅仅符合条件的数据,我把这句话
rs=st.executeQuery("select * from gg_employee );
改为
rs=st.executeQuery("select * from gg_employee WHERE 员工姓名="+request.getParameterValues(username));
为什么出错呢?应该怎么改正,谢谢!
* 创建日期 2004-6-21
*
* 更改所生成文件模板为
* 窗口 > 首选项 > Java > 代码生成 > 代码和注释
*/
package test;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
//import java.util.*;
/**
* @author Administrator
*
* 更改所生成类型注释的模板为
* 窗口 > 首选项 > Java > 代码生成 > 代码和注释
*/
public class helloservlet extends HttpServlet {
private static final String CONTENT_TYPE="text/html;charset=GBK";
public void init() throws ServletException{
}
public void doGet(HttpServletRequest request,HttpServletResponse response) throws
ServletException,IOException{
response.setContentType(CONTENT_TYPE);
ServletOutputStream out=response.getOutputStream();
out.println("<html>");
out.println("<head><title>heeeee</title></head>");
out.println("<body bgcolor=\"#00ffff\">");
out.println("<form method=get action=hl>");
out.println("<input type=text name=username>");
out.println("<input type=password name=password>");
out.println("<input type=button value=提交>");
out.println("</form>");
out.println("<table>");
out.println("<tr>");
out.println("<td>");
out.println("NAME");
out.println("</td>");
out.println("<td>");
out.println("PASSWORD");
out.println("</td>");
out.println("<tr>");
Connection connection,con1;
Statement statement,st;
ResultSet resultset=null,rs;
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
connection=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pms1_1hq","sa","");
statement=connection.createStatement();
con1=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pms1_1hq","sa","");
st=con1.createStatement();
rs=st.executeQuery("select * from gg_employee );
while (rs.next())
{
out.println("<TR>");
out.println("<TD>");
out.println(rs.getString("员工姓名"));
out.println("</TD>");
out.println("<TD>");
out.println(rs.getString("口令"));
out.println("</TD>");
out.println("</TR>");
}
con1.close();
}
catch(Exception e)
{//System.out.println(e);
e.printStackTrace();
}
out.println("</table>");
out.print("sdaf"+request.getRemoteAddr());
out.print("<br>");
out.print("</br>");
out.print("<a href=a.jsp>");
out.print( "sadfasfd");
out.print("</a>");
//out.print("</center>");
out.print("<input type=submit value=汉字> ");
out.print("</form>");
out.print("</body></html>");
}
public void destroy(){}
}
这个servlet能把数据库 中的内容全部显示出来,现在我想实现如下功能:
在一打开次页得时候,显示出上面的查询按钮,输入一个东西到username中后,点按扭从数据库中查询出仅仅符合条件的数据,我把这句话
rs=st.executeQuery("select * from gg_employee );
改为
rs=st.executeQuery("select * from gg_employee WHERE 员工姓名="+request.getParameterValues(username));
为什么出错呢?应该怎么改正,谢谢!
...全文
请发表友善的回复…
发表回复
lovelymaomao 2004-08-04
- 打赏
- 举报
rs=st.executeQuery("select * from gg_employee WHERE 员工姓名="+request.getParameterValues(username));
改为 员工姓名= '"+ request.getParameterValues("username") +"' ;
userName是从前面一个页面传过来的参数~~
改为 员工姓名= '"+ request.getParameterValues("username") +"' ;
userName是从前面一个页面传过来的参数~~
