求详细连接sql2005的方法~
解决方案 »
- Spring+Hibernate框架下Mysql读写分离、主从数据库配置无法选择数据源
- 关于网站的毕业设计
- 请教大虾们关于在线预订
- 用java写的web程序是不是必须要放在WEB-INF的classes目录?可不可以自己另外指定一个其它路径?
- 求助····三级动态下拉列表的实现,和思想!
- 如果实现外部提示表单到服务器端的数据库?
- 请教各位jbuilder9+weblogic+oracle9i开发,需要怎样设置?????
- 奇怪:jsp 分页问题
- 字符数组问题
- 按教程制作helloworld.java,编译通过,但是页面中不能调用,何解?
- 急求js日历,结合表单使用示例
- 用socket采用POST 方式请求一个servlet,但servlet能解析出参数名称来,参数不对,请问怎么回事啊
import java.sql.DriverManager;
import java.sql.SQLException;public class DBConnection {
public static Connection getConnection() {
String drivrename = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dabaseurl = "jdbc:sqlserver://localhost:1433;DatabaseName=yourdb";
String dbUser = "sa";
String dbPassword = "";
Connection con = null; try {
Class.forName(drivrename);
con = DriverManager.getConnection(dabaseurl, dbUser, dbPassword);
return con;
} catch (java.lang.ClassNotFoundException e) {
System.err.println(e);
} catch (SQLException er) {
System.err.println(er.getMessage());
} return null;
}}
import java.sql.DriverManager;
import java.sql.SQLException;public class DBConnection {
public static Connection getConnection() {
String drivrename = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dabaseurl = "jdbc:sqlserver://localhost:1433;DatabaseName=yourdb";
String dbUser = "sa";
String dbPassword = "";
Connection con = null; try {
Class.forName(drivrename);
con = DriverManager.getConnection(dabaseurl, dbUser, dbPassword);
return con;
} catch (java.lang.ClassNotFoundException e) {
System.err.println(e);
} catch (SQLException er) {
System.err.println(er.getMessage());
} return null;
}}[/code]
String drivrename = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dabaseurl = "jdbc:sqlserver://localhost:1433;DatabaseName=yourdb";
放在web工程的\WEB-INF\lib下
代码这么写import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;public class DBConnection {
public static Connection getConnection() {
String drivrename = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dabaseurl = "jdbc:sqlserver://localhost:1433;DatabaseName=yourdb";
String dbUser = "sa";
String dbPassword = "";
Connection con = null; try {
Class.forName(drivrename);
con = DriverManager.getConnection(dabaseurl, dbUser, dbPassword);
return con;
} catch (java.lang.ClassNotFoundException e) {
System.err.println(e);
} catch (SQLException er) {
System.err.println(er.getMessage());
} return null;
}}
HTTP Status 500 -type Exception reportmessagedescription The server encountered an internal error () that prevented it from fulfilling this request.exceptionorg.apache.jasper.JasperException: org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 3 in the jsp file: /user_reg_save.jsp
Generated servlet error:
Void methods cannot return a valueAn error occurred at line: 3 in the jsp file: /user_reg_save.jsp
Generated servlet error:
Void methods cannot return a valueAn error occurred at line: 3 in the jsp file: /user_reg_save.jsp
Generated servlet error:
Syntax error, insert "Finally" to complete TryStatementGenerated servlet error:
Syntax error on token "catch", Identifier expectedGenerated servlet error:
out cannot be resolvedGenerated servlet error:
_jspx_out cannot be resolvedGenerated servlet error:
out cannot be resolvedGenerated servlet error:
out cannot be resolvedGenerated servlet error:
out cannot be resolvedGenerated servlet error:
_jspx_page_context cannot be resolvedGenerated servlet error:
_jspx_page_context cannot be resolvedGenerated servlet error:
Syntax error on token "finally", { expectedGenerated servlet error:
_jspxFactory cannot be resolvedGenerated servlet error:
_jspxFactory cannot be resolvedGenerated servlet error:
_jspx_page_context cannot be resolved
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:565)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:354)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)root causeorg.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 3 in the jsp file: /user_reg_save.jsp
Generated servlet error:
Void methods cannot return a valueAn error occurred at line: 3 in the jsp file: /user_reg_save.jsp
Generated servlet error:
Void methods cannot return a valueAn error occurred at line: 3 in the jsp file: /user_reg_save.jsp
Generated servlet error:
Syntax error, insert "Finally" to complete TryStatementGenerated servlet error:
Syntax error on token "catch", Identifier expectedGenerated servlet error:
out cannot be resolvedGenerated servlet error:
_jspx_out cannot be resolvedGenerated servlet error:
out cannot be resolvedGenerated servlet error:
out cannot be resolvedGenerated servlet error:
out cannot be resolvedGenerated servlet error:
_jspx_page_context cannot be resolvedGenerated servlet error:
_jspx_page_context cannot be resolvedGenerated servlet error:
Syntax error on token "finally", { expectedGenerated servlet error:
_jspxFactory cannot be resolvedGenerated servlet error:
_jspxFactory cannot be resolvedGenerated servlet error:
_jspx_page_context cannot be resolved
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:85)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:329)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:415)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:308)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:273)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:566)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:314)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)note The full stack trace of the root cause is available in the Apache Tomcat/6.0.7 logs.
具体jsp页面
<%@ page language="java" import="java.util.*" pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*" %>
<% String drivrename = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dabaseurl = "jdbc:sqlserver://localhost:1433;DatabaseName=BBS";
String dbUser = "sa";
String dbPassword = "leileiHOME041";
Connection con = null; try
{
Class.forName(drivrename);
con = DriverManager.getConnection(dabaseurl, dbUser, dbPassword);
return con;
}
catch (java.lang.ClassNotFoundException e)
{
System.err.println(e);
}
catch (SQLException er)
{
System.err.println(er.getMessage());
} return null;
}
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'user_reg_save.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
--> </head>
<body><br><br></body>
</html>
干吗这么麻烦~~~~
<Context path="/webname" docBase="webname" debug="5" reloadable="true" crossContext="true" >
<Resource name="jdbc/db_telecom_SQLPool" auth="Container"
type="javax.sql.DataSource" maxActive="100" maxIdle="50"
maxWait="10000" username="sa" password="" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://localhost:1433;DatabaseName=dbname" />
</Context>