JSP连接 SQL-SEVER2000个人版 失败
来源:百度知道 编辑:UC知道 时间:2024/05/22 13:24:52
ODBC 配置完成,名字是jianren,并且自测可以连接到Sql ,现在用
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
<% Connection con;
Statement sql;
ResultSet rs;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){out.print(e);}
try { con=DriverManager.getConnection("jdbc:odbc:jianren","sa","admin");
}
catch(Exception e1) {out.print("!!"+e1);}
%>
</BODY>
</HTML>
IE打开后报错,说
!!JSP data source name not found and default driver specified
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
<% Connection con;
Statement sql;
ResultSet rs;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){out.print(e);}
try { con=DriverManager.getConnection("jdbc:odbc:jianren","sa","admin");
}
catch(Exception e1) {out.print("!!"+e1);}
%>
</BODY>
</HTML>
IE打开后报错,说
!!JSP data source name not found and default driver specified
你这样
<%@ page import="java.lang.*, java.io.*, java.sql.*, java.util.*" contentType="text/html; charset=EUC_CN" %>
<html>
<body>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=first_DB"; // first_DB是数据库名称
String user="sa"; //安装时请选择混合模式,并设好sa的密码
String password="sa的密码";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from first_table"; // MEMBERS_INFO是表名
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的