以后是我的代码! 红色部份为出问题的地方! 我是看出不来. 是不是我有的地方没有配对呀! catch(){}捕到了这个错误! <%@ page contentType="text/html; charset=GB2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%!
String Driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
//String Url ="jdbc:sqlserver://localhost:1433;DatabaseName=gxhk";
//String Username = "sa";
//String Password = "123";
Connection con ;
Statement st ;
ResultSet rs ;
//String sql = "select * from gxhk_login" ;
%>
<%
try
{
Class.forName(Driver);
out.println("successs");
}
catch(Exception e)
{
out.println("faile");
}
%>
<%
try
{
con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=gxhk","sa","123");
out.println("successs2");
}
catch(Exception e)
{
out.println("faile8");
}
%>
<%
try
{
rs =st.executeQuery("SELECT * FROM gxhk_login"); rs.close();
st.close();
con.close(); }
catch(Exception e)
{
out.println("faile5"); // 页面中提示我这个是错误的! 郁闷咯!其它的都通过咯
}/* if(rs.next())
{
out.println("win");
}
}
catch(Exception e)
{
out.println("faile4");
}*/%>
</body>
</html>
<%@ page import="java.sql.*"%>
<html>
<body>
<%!
String Driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
//String Url ="jdbc:sqlserver://localhost:1433;DatabaseName=gxhk";
//String Username = "sa";
//String Password = "123";
Connection con ;
Statement st ;
ResultSet rs ;
//String sql = "select * from gxhk_login" ;
%>
<%
try
{
Class.forName(Driver);
out.println("successs");
}
catch(Exception e)
{
out.println("faile");
}
%>
<%
try
{
con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=gxhk","sa","123");
out.println("successs2");
}
catch(Exception e)
{
out.println("faile8");
}
%>
<%
try
{
rs =st.executeQuery("SELECT * FROM gxhk_login"); rs.close();
st.close();
con.close(); }
catch(Exception e)
{
out.println("faile5"); // 页面中提示我这个是错误的! 郁闷咯!其它的都通过咯
}/* if(rs.next())
{
out.println("win");
}
}
catch(Exception e)
{
out.println("faile4");
}*/%>
</body>
</html>
Statement st ;
ResultSet rs ;
这样就算定义好了?
但是我在红色的代码部份加入以下代码!以后没有任何的反应呀!
try
{
rs = st.executeQuery("SELECT * FROM gxhk_login");
if(rs.next())
{
out.println("win");
}
else
{
out.println("falis");
} rs.close();
st.close();
con.close(); }
<%@ page contentType="text/html; charset=GB2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%!
String Driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
//String Url ="jdbc:sqlserver://localhost:1433;DatabaseName=gxhk";
//String Username = "sa";
//String Password = "123";
Connection con = null ;
Statement st = null;
ResultSet rs = null ;
//String sql = "select * from gxhk_login" ;
%>
<%
try
{
Class.forName(Driver);
out.println("successs");
}
catch(Exception e)
{
out.println("faile");
}
%>
<%
try
{
con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=gxhk","sa","123");
out.println("successs2");
}
catch(Exception e)
{
out.println("faile8");
}
%>
<%
try
{
rs = st.executeQuery("SELECT * FROM gxhk_login");
if(rs.next())
{
out.println("win"); //这是我想要的结果咯!
}
else
{
out.println("falis");
}
rs.close();
st.close();
con.close(); }
catch(Exception e)
{
e.printStackTrace();
} %>
</body>
</html>
Statement st ;
ResultSet rs ;
这三个还都是null的啊 null的有什么用啊
new 对象
迷茫! 写代码一定要注意结构
rs = con.executeQuery("SELECT * FROM gxhk_login");