下面是一段数据库查询的代码但不知道错在什么位置,文件:login.jsp<%@page contentType="text/html"%>
<%@page pageEncoding="GB2312"%>
<%@page import = "java.sql.*" %>
<%
String name = new String
(request.getParameter("user_name"));
String port = new String
(request.getParameter("user_port"));
String sql;
sql="select name,camtype,mac,ip,port from ddns where name='"+name+"' and port='"+port+"'";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url;
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=emicam";
Connection con = DriverManager.getConnection(url,"sa","cam888"); Statement smt =con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = smt.executeQuery(sql);
while(rs.next()){
var top=window.parent.topFrame.document.form1;
top.cam_host.value=rs.getString("name");
top.cam_mac.value=rs.getString("mac");
top.cam_type.value=rs.getString("camtype");
top.cam_port.value=rs.getString("port"); con.close();
response.sendRedirect("video.htm");
%>请各位大虾帮帮忙,谢谢了
<%@page pageEncoding="GB2312"%>
<%@page import = "java.sql.*" %>
<%
String name = new String
(request.getParameter("user_name"));
String port = new String
(request.getParameter("user_port"));
String sql;
sql="select name,camtype,mac,ip,port from ddns where name='"+name+"' and port='"+port+"'";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url;
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=emicam";
Connection con = DriverManager.getConnection(url,"sa","cam888"); Statement smt =con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = smt.executeQuery(sql);
while(rs.next()){
var top=window.parent.topFrame.document.form1;
top.cam_host.value=rs.getString("name");
top.cam_mac.value=rs.getString("mac");
top.cam_type.value=rs.getString("camtype");
top.cam_port.value=rs.getString("port"); con.close();
response.sendRedirect("video.htm");
%>请各位大虾帮帮忙,谢谢了
String name = new String(request.getParameter("user_name"));
String port = new String(request.getParameter("user_port"));request.getParameter本来就返回一个String ,你还new哪门子啊,浪费内存资源
top.cam_host.value=rs.getString("name");
top.cam_mac.value=rs.getString("mac");
top.cam_type.value=rs.getString("camtype");
top.cam_port.value=rs.getString("port");这段是js代码,你混到<%%>中干吗
%>
<script>
var top=window.parent.topFrame.document.form1;
top.cam_host.value='<%=rs.getString("name")%>' ;
top.cam_mac.value='<%=rs.getString("mac")%>';
top.cam_type.value='<%=rs.getString("camtype")%>';
top.cam_port.value='<%=rs.getString("port")%>';
</script>
<%
}
这条语句通过不了
估计又是Error establish socket,你的sqlserver打sp3补丁没有??
<%@page contentType="text/html"%>
<%@page pageEncoding="GB2312"%>
<%@page import = "java.sql.*" %>
<%
String name = request.getParameter("user_name");
String port = request.getParameter("user_port");
String sql;
sql="select name,camtype,mac,ip,port from ddns where name='"+name+"' and port='"+port+"'";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url;
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=emicam";
try
{
Connection con = DriverManager.getConnection(url,"sa","cam888");
Statement smt =con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = smt.executeQuery(sql);
while(rs.next()){
%>
<script>
var top=window.parent.topFrame.document.form1;
top.cam_host.value='<%=rs.getString("name")%>' ;
top.cam_mac.value='<%=rs.getString("mac")%>';
top.cam_type.value='<%=rs.getString("camtype")%>';
top.cam_port.value='<%=rs.getString("port")%>';
</script>
<%
}
con.close();
}
catch()
{
response.sendRedirect("video.htm"); }
response.sendRedirect("video.htm");
%>
{
out.print(e.toString());}
response.sendRedirect("video.htm");
%>试试
那怎么样可以解决呢?
换成sun的那个,下面的在改一下。看看如何?
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url;
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=emicam";
Connection con = DriverManager.getConnection(url,"sa","cam888"); Statement smt =con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = smt.executeQuery(sql);
while(rs.next()){
var top=window.parent.topFrame.document.form1;
top.cam_host.value=rs.getString("name");
top.cam_mac.value=rs.getString("mac");
top.cam_type.value=rs.getString("camtype");
top.cam_port.value=rs.getString("port"); con.close();
response.sendRedirect("video.htm");
}catch(Exception e){
e.printStackTrace();
}
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=emicam";
是不是url写错了哈
url="jdbc:microsoft:sqlserver://localhost:1433/emicam";还是其他之类的?
你写的这是什么啊,js 和 java代码 写一起