环境:jdk1.5,tomcat5.59,sql2000+sp4,win2003+sp1,Microsoft SQL Server 2000 Driver for JDBC Service Pack 3
问题一:很多人介绍要配置什么系统变量path,classpath等,我没配置安装完jdk和tomcat后就可以运行HelloWorld,也能打开http://localhost:8080/。
问题二:怎么连接数据库?我搞了一天,也没搞出来, 那个高手指点一下。谢谢了先。
问题一:很多人介绍要配置什么系统变量path,classpath等,我没配置安装完jdk和tomcat后就可以运行HelloWorld,也能打开http://localhost:8080/。
问题二:怎么连接数据库?我搞了一天,也没搞出来, 那个高手指点一下。谢谢了先。
解决方案 »
- js怎么实现国际化?
- 如何将struts2导入myeclipse6.5的java web 工程中?
- 高手帮帮忙
- jsp的IDE问题
- 关于Exception的问题,急急急!!!在线等,希望帮帮忙~~~小弟先谢谢了~~~
- 問一下<Context docBase="C:/JavaTest/demo/webroot" path="/demo" reloadable="true">的意思!!
- select * from 表名 where 字段=变量 没有记录会报错误!
- 在OA里邮箱何实现的?
- 问一个菜鸟的问题,关于jdbc:odbc数据源
- 读过《数据结构(java语言版)》的朋友,每个例子都要载入ConsoleReader.*类,
- 求hibernate2.X中的Apache Derby数据库的dialect
- Servlet 轻松拿下100分!
import java.sql.*;
public class dtbs
{
public static void main(String[] args)
{
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=exam";
String user="sa";
String password="(Jiao4@Yu2$Hua3*)";
Connection conn = DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement();
String sql = "select * from xt_yhlb";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
}
}
catch (Exception e)
{
System.out.println(e.getMessage());
}
}
}
rs=null;stmt.close();
stmt=null;conn.close();
conn = null;连接数据库,将下面三个文件放在类的classpath即可如系统的环境变量中的classpath如果是tomcat 则放在 %catalina_home%/common/lib/下msbase.jar,mssqlserver.jar,msutil.jar
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSP
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:565)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:293)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.io.UTFDataFormatException: Invalid byte 1 of 1-byte UTF-8 sequence.
org.apache.jasper.xmlparser.UTF8Reader.invalidByte(UTF8Reader.java:620)
org.apache.jasper.xmlparser.UTF8Reader.read(UTF8Reader.java:491)
org.apache.jasper.xmlparser.XMLEncodingDetector.load(XMLEncodingDetector.java:999)
org.apache.jasper.xmlparser.XMLEncodingDetector.skipString(XMLEncodingDetector.java:950)
org.apache.jasper.xmlparser.XMLEncodingDetector.scanXMLDecl(XMLEncodingDetector.java:1208)
org.apache.jasper.xmlparser.XMLEncodingDetector.getEncoding(XMLEncodingDetector.java:120)
org.apache.jasper.xmlparser.XMLEncodingDetector.getEncoding(XMLEncodingDetector.java:108)
org.apache.jasper.compiler.ParserController.determineSyntaxAndEncoding(ParserController.java:304)
org.apache.jasper.compiler.ParserController.doParse(ParserController.java:169)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:100)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:146)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:286)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:267)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:255)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:556)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:293)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.9 logs.
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=exam";
String user="sa";
String password="(Jiao4@Yu2$Hua3*)";
Connection conn = DriverManager.getConnection(url,user,password);
Statement stmt = conn.createStatement();
String sql = "select * from xt_yhlb";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
}
}
catch (Exception e)
{
System.out.println(e.getMessage());
}
------------------------------
你再试下???