您所在位置：主题：让人疑惑的问题!
yangccs1234
[专家分：0] 发布于 2006-03-14 23:46:00
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=GB2312" %>
<html>
<head>
<title>DbJsp.jsp</title>
</head>
<body>
<%
try
{
Connection con;
Statement stmt;
ResultSet rs;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
String dbUrl="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=BookDB";
String dbUser="dbuser";
String dbPwd="1234";
con=DriverManager.getConnection(dbUrl,dbUser,dbPwd);
stmt=con.createStatement();
stmt.executeUpdate("INSERT INTO books(id,name,title,price) VALUES ('999','Tom','Tomcate Bible',55.4)");
rs=stmt.executeQuery("SELECT id,name,title,price from books");
out.println("<table border=1 width=400>");
while(rs.next())
{
String col1=rs.getString(1);
String col2=rs.getString(2);
String col3=rs.getString(3);
float col4=rs.getFloat(4);
out.println("<tr><td>"+col1+"</td><td>"+col2+"</td><td>"+col3+"</td><td>"+col4+"</td></tr>");
}
out.println("</table>");
stmt.executeUpdate("DELETE FROM books WHERE id='999'");
rs.close();
stmt.close();
con.close();
}
catch(Exception e)
{
out.println(e.getMessage());
}
%>
</body>
</html>
这段代码可以正常运行,而且有结果
下面一段代码就不行拉!显示 No suitable driver
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=GB2312" %>
<html>
<body>
<%
try
{
//加载注册驱动程序
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
//连接字符串
String url="jdbc:mircrosoft:sqlserver://localhost:1433;DatabaseName=bookshop";
String user="bookuser";
String pwd="123";
Connection conn=DriverManager.getConnection(url,user,pwd);
Statement stmt=conn.createStatement();
stmt.executeUpdate("INSERT INTO allorders(ID,orderId,BookNo,Amount) VALUES ('10','11','23','34')");
String sqlStr="SELECT ID,orderId,BookNo,Amount from allorders";
ResultSet rs=stmt.executeQuery(sqlStr);
while(rs.next())
{%>
你的第一个字段的内容：<%=rs.getString(1)%><br>
你的第二个字段的内容：<%=rs.getString(2)%><br>
你的第三个字段的内容：<%=rs.getString(3)%><br>
你的第四个字段的内容：<%=rs.getString(4)%><br>
<% } %>
<%
rs.close();
stmt.close();
conn.close();
}
catch(Exception e)
{
out.println(e.getMessage());
}
%>
</body>
</html>
我想这是驱动出的问题,但是这两段代码加载驱动是一样的代码!
不知道是为什么上面一个能行,而下面一个不行!
请教高手!
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=GB2312" %>
<html>
<head>
<title>DbJsp.jsp</title>
</head>
<body>
<%
try
{
Connection con;
Statement stmt;
ResultSet rs;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
String dbUrl="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=BookDB";
String dbUser="dbuser";
String dbPwd="1234";
con=DriverManager.getConnection(dbUrl,dbUser,dbPwd);
stmt=con.createStatement();
stmt.executeUpdate("INSERT INTO books(id,name,title,price) VALUES ('999','Tom','Tomcate Bible',55.4)");
rs=stmt.executeQuery("SELECT id,name,title,price from books");
out.println("<table border=1 width=400>");
while(rs.next())
{
String col1=rs.getString(1);
String col2=rs.getString(2);
String col3=rs.getString(3);
float col4=rs.getFloat(4);
out.println("<tr><td>"+col1+"</td><td>"+col2+"</td><td>"+col3+"</td><td>"+col4+"</td></tr>");
}
out.println("</table>");
stmt.executeUpdate("DELETE FROM books WHERE id='999'");
rs.close();
stmt.close();
con.close();
}
catch(Exception e)
{
out.println(e.getMessage());
}
%>
</body>
</html>
这段代码可以正常运行,而且有结果
下面一段代码就不行拉!显示 No suitable driver
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page contentType="text/html;charset=GB2312" %>
<html>
<body>
<%
try
{
//加载注册驱动程序
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//DriverManager.registerDriver(new com.microsoft.jdbc.sqlserver.SQLServerDriver());
//连接字符串
String url="jdbc:mircrosoft:sqlserver://localhost:1433;DatabaseName=bookshop";
String user="bookuser";
String pwd="123";
Connection conn=DriverManager.getConnection(url,user,pwd);
Statement stmt=conn.createStatement();
stmt.executeUpdate("INSERT INTO allorders(ID,orderId,BookNo,Amount) VALUES ('10','11','23','34')");
String sqlStr="SELECT ID,orderId,BookNo,Amount from allorders";
ResultSet rs=stmt.executeQuery(sqlStr);
while(rs.next())
{%>
你的第一个字段的内容：<%=rs.getString(1)%><br>
你的第二个字段的内容：<%=rs.getString(2)%><br>
你的第三个字段的内容：<%=rs.getString(3)%><br>
你的第四个字段的内容：<%=rs.getString(4)%><br>
<% } %>
<%
rs.close();
stmt.close();
conn.close();
}
catch(Exception e)
{
out.println(e.getMessage());
}
%>
</body>
</html>
我想这是驱动出的问题,但是这两段代码加载驱动是一样的代码!
不知道是为什么上面一个能行,而下面一个不行!
请教高手!