这是我的程序package test;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class CounterServlet extends HttpServlet
{
private static final String CONTENT_TYPE = "text/html; charset=GBK";
private String indata;
private String s, t, f;
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
/*接受客户端信息*/
response.setContentType (CONTENT_TYPE);
PrintWriter out = response.getWriter();
indata = request.getParameter("DATA");
/*与数据库连接查询*/
String url = url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=chfjava";
Connection con;
Statement stmt;
String query = "select * from shop";
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
try {
out.println("<html>");
out.println("<body>");
out.println("<head><title>商品搜索结果</title></head>");
out.println("<h2 align='center'>" + "搜索结果" + "</h2>");
out.println("<P>klfjkljkljkljkl</P>");
out.println("<P>fsjdkljfklsdjfklsd</P>");
out.println(query);
//out.println(indata);
out.println("<P>"+ indata + "</P>");
con = DriverManager.getConnection(url, "sa", "");
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
s = rs.getString("id");
t = rs.getString("name");
f = rs.getString("price");
out.println(s);
out.println(t);
out.println(f);
}
out.println("sjdklfjklsdjfkljsdklfjkljskl");
stmt.close();
con.close();
//out.println(indata);
out.println("</body>");
out.println("</html>");
out.close();
}
catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
}
}为什么我输入5sdfsdf
输出结果为
搜索结果
klfjkljkljkljklfsjdkljfklsdjfklsdselect * from shop
5sdfsdf
为什么这几句不输出啊 out.println("sjdklfjklsdjfkljsdklfjkljskl");
数据库查询后面的都没有结果,数据库查询的结果也不输出??
我的数据库内容为
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class CounterServlet extends HttpServlet
{
private static final String CONTENT_TYPE = "text/html; charset=GBK";
private String indata;
private String s, t, f;
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
/*接受客户端信息*/
response.setContentType (CONTENT_TYPE);
PrintWriter out = response.getWriter();
indata = request.getParameter("DATA");
/*与数据库连接查询*/
String url = url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=chfjava";
Connection con;
Statement stmt;
String query = "select * from shop";
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
try {
out.println("<html>");
out.println("<body>");
out.println("<head><title>商品搜索结果</title></head>");
out.println("<h2 align='center'>" + "搜索结果" + "</h2>");
out.println("<P>klfjkljkljkljkl</P>");
out.println("<P>fsjdkljfklsdjfklsd</P>");
out.println(query);
//out.println(indata);
out.println("<P>"+ indata + "</P>");
con = DriverManager.getConnection(url, "sa", "");
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
s = rs.getString("id");
t = rs.getString("name");
f = rs.getString("price");
out.println(s);
out.println(t);
out.println(f);
}
out.println("sjdklfjklsdjfkljsdklfjkljskl");
stmt.close();
con.close();
//out.println(indata);
out.println("</body>");
out.println("</html>");
out.close();
}
catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
}
}为什么我输入5sdfsdf
输出结果为
搜索结果
klfjkljkljkljklfsjdkljfklsdjfklsdselect * from shop
5sdfsdf
为什么这几句不输出啊 out.println("sjdklfjklsdjfkljsdklfjkljskl");
数据库查询后面的都没有结果,数据库查询的结果也不输出??
我的数据库内容为
解决方案 »
- ftl页面获取name相同的控件的值时自动在首尾添加方括号怎么办
- webjava问题
- java的优点
- JSP页面打开动态页面非常卡,静态页没问题,同服务器其它网站动态页没问题
- jsp页面里怎么用Cookie
- 哪位高手能把这段java代码转换成JS代码?比较急。。。.十分感谢!
- ExtJS的formPanel提交后,不能执行success。
- 跪求JavaMail认证方式的设置
- 请部能不能用servlet对数据库操作,将查询的值保存在javabean中,然后在jsp页面中使用这个javabean将先前保存在里面的值再取出来
- 多条件查询数据库,为何没有输出结果!!!帮忙看看!!!
- 请教 找不到配置文件路径! 在线等!
- 求一些例子~~~~
楼主【cschf】截止到2008-06-24 13:50:56的历史汇总数据(不包括此帖):
发帖数:3 发帖分:190
结贴数:3 结贴分:190
未结数:0 未结分:0
结贴率:100.00% 结分率:100.00%
敬礼!
id name price
1 chf 12
2 chfjf 15
con = DriverManager.getConnection(url, "sa", "");
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
s = rs.getString("id");
t = rs.getString("name");
f = rs.getString("price");
out.println(s);
out.println(t);
out.println(f);
}
看不到你的数据库内容,不知道具体什么错误。
这是我的程序
package test;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class CounterServlet extends HttpServlet
{
private static final String CONTENT_TYPE = "text/html; charset=GBK";
private String indata;
private String s, t, f;
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
/*接受客户端信息*/
response.setContentType (CONTENT_TYPE);
PrintWriter out = response.getWriter();
indata = request.getParameter("DATA");
/*与数据库连接查询*/
String url = url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=chfjava";
Connection con;
Statement stmt;
String query = "select * from shop";
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
try {
out.println("<html>");
out.println("<body>");
out.println("<head><title>商品搜索结果</title></head>");
out.println("<h2 align='center'>" + "搜索结果" + "</h2>");
out.println("<P>klfjkljkljkljkl</P>");
out.println("<P>fsjdkljfklsdjfklsd</P>");
out.println(query);
//out.println(indata);
out.println("<P>"+ indata + "</P>");
con = DriverManager.getConnection(url, "sa", "");
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
s = rs.getString("id");
t = rs.getString("name");
f = rs.getString("price");
out.println(s);
out.println(t);
out.println(f);
}
out.println("sjdklfjklsdjfkljsdklfjkljskl");
stmt.close();
con.close();
//out.println(indata);
out.println("</body>");
out.println("</html>");
out.close();
}
catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
}
}为什么我输入5sdfsdf
输出结果为
搜索结果
klfjkljkljkljkl fsjdkljfklsdjfklsd select * from shop
5sdfsdf
为什么这几句不输出啊 out.println("sjdklfjklsdjfkljsdklfjkljskl");
数据库查询后面的都没有结果,数据库查询的结果也不输出??
为什么我输入5sdfsdf
输出结果为
搜索结果
klfjkljkljkljkl fsjdkljfklsdjfklsd select * from shop
5sdfsdf
为什么这几句不输出啊 out.println("sjdklfjklsdjfkljsdklfjkljskl");
数据库查询后面的都没有结果,数据库查询的结果也不输出??
我的数据库内容为
id name price
1 chf 12
2 chfjf 15
[/code]
这是我的程序
package test;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
public class CounterServlet extends HttpServlet
{
private static final String CONTENT_TYPE = "text/html; charset=GBK";
private String indata;
private String s, t, f;
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
/*接受客户端信息*/
response.setContentType (CONTENT_TYPE);
PrintWriter out = response.getWriter();
indata = request.getParameter("DATA");
/*与数据库连接查询*/
String url = url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=chfjava";
Connection con;
Statement stmt;
String query = "select * from shop";
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(java.lang.ClassNotFoundException e) {
System.err.print("ClassNotFoundException: ");
System.err.println(e.getMessage());
}
try {
out.println("<html>");
out.println("<body>");
out.println("<head><title>商品搜索结果</title></head>");
out.println("<h2 align='center'>" + "搜索结果" + "</h2>");
out.println("<P>klfjkljkljkljkl</P>");
out.println("<P>fsjdkljfklsdjfklsd</P>");
out.println(query);
//out.println(indata);
out.println("<P>"+ indata + "</P>");
con = DriverManager.getConnection(url, "sa", "");
stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
s = rs.getString("id");
t = rs.getString("name");
f = rs.getString("price");
out.println(s);
out.println(t);
out.println(f);
}
out.println("sjdklfjklsdjfkljsdklfjkljskl");
stmt.close();
con.close();
//out.println(indata);
out.println("</body>");
out.println("</html>");
out.close();
}
catch(SQLException ex) {
System.err.println("SQLException: " + ex.getMessage());
}
}
}为什么我输入5sdfsdf
输出结果为
搜索结果
klfjkljkljkljkl fsjdkljfklsdjfklsd select * from shop
5sdfsdf
为什么这几句不输出啊 out.println("sjdklfjklsdjfkljsdklfjkljskl");
数据库查询后面的都没有结果,数据库查询的结果也不输出??
为什么我输入5sdfsdf
输出结果为
搜索结果
klfjkljkljkljkl fsjdkljfklsdjfklsd select * from shop
5sdfsdf
为什么这几句不输出啊 out.println("sjdklfjklsdjfkljsdklfjkljskl");
数据库查询后面的都没有结果,数据库查询的结果也不输出??
我的数据库内容为
id name price
1 chf 12
2 chfjf 15
s = rs.getString("id");
t = rs.getString("name");
f = rs.getString("price");
out.println(s);
out.println(t);
out.println(f);
}
这段代码有问题。
看看con有没有得到