UC知道JSP连接SQL server2000的表格查询问题
来源：百度知道 编辑：UC知道 时间：2024/06/27 10:51:52
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.util.*"%>
<%@ page import="java.io.*"%>
<html>
<head>
<title>JSP1-1</title>
</head>
<body>
<table border="2">
<%! Statement stmt;
ResultSet rs; %>
<%
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
}
catch(Exception e){}
Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jsp1","sa","123");
stmt=conn.createStatement();
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="SELECT * FROM stu_table";
ResultSet rs=stmt.executeQue
<%@ page import="java.util.*"%>
<%@ page import="java.io.*"%>
<html>
<head>
<title>JSP1-1</title>
</head>
<body>
<table border="2">
<%! Statement stmt;
ResultSet rs; %>
<%
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
}
catch(Exception e){}
Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jsp1","sa","123");
stmt=conn.createStatement();
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="SELECT * FROM stu_table";
ResultSet rs=stmt.executeQue
1.可能是需要去掉空格:if(s2.trim().equals("男"))
2.也可能是中文字符的问题，out.print(s2);输出的结果是什么？
你在给S2赋值的时候去掉尾部空格试试rs.getstring(3).trim试试