JDBC连接SQLServer 2000的问题 - Java / Web 开发
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: An exception occurred processing JSP page /save.jsp at line 18
15: }else
16: {
17: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
18: Connection connection=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=web","sa","");
19: String sql="insert into guestbook(content,author,email,tel) values(?,?,?,?)";
20: PreparedStatement ps=connection.prepareStatement(sql);
21: ps.setString(1,con);
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
javax.servlet.ServletException: java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlser
相关问答:
题目:
有1,2,3,4,5,6六个数字排序,用java程序计算出排序的种类。
要求:一,以4开头
二,2,3不能相邻
三,不能以5开头
希望大家能即 ......
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 52 in the jsp file: /vip_info.jsp
ÕË cannot be resolved
49: <table border="1& ......
有谁用java做过打印发票的程序,感觉这方面不是很好控制,希望给点建议,最好能给出代码
简单点就调用window.print()
你也可以把下面代码放到你JSP中:
<html>
<head>
<title> ......
使用java在windows7 32位下连接MSSQL。
两台机器,windows7 32位,在控制面板里面全部设置语言和区域选项都english-unitedstates
唯一区别只有在安装SQL server 2008的时候 选择的字符集不一样,
exec sp_helpsor ......
insert into [ScholarshipManagement].[dbo].[department] ([department],[specialization] ,[grade]) output inserted.departmentID values(? ,? ,? )
请问大哥们这个sql 语句应该用Java里的那个数据库操作方法? ......