配置版本:
eclipse3.1+ jdk1.5.0 + tomcat5.5 + myeclpise4.0
window2003 +SQL2000+SQLsp3+JDBC(udpate3)
配置正确
如下代码连接SQL2000数据库测试通过,没问题.说明jdbc配置成功.
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%!
public static String getGBString(String src) {
try {
return new String(src.getBytes("ISO-8859-1"), "gb2312");
} catch (java.io.UnsupportedEncodingException e) {
return null;
}
}
%>
<html>
<body> <%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://192.168.1.114:1433;DatabaseName=pubs";
//pubs你的数据库的
String user="sa";
String password="1";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from titles";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=getGBString(rs.getString(1))%> <br>
您的第二个字段内容为:<%=getGBString(rs.getString(2))%> <br>
<%}%>
<%out.print("数据库操作成功,恭喜你");%> <br>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
==========================
问题:可是 在myeclipse中代码如下:package wu;
import java.sql.*;public class jdbc {
public jdbc(){}
Connection conn = null;
String gvDriver = "";
private String uid="sa";
private String passwd="1";
private String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs";
private String classforname="com.microsoft.jdbc.sqlserver.SQLServerDriver";
//设置你的数据库ip
java.sql.Connection getConn(){
try{
Class.forName(classforname);
conn=DriverManager.getConnection(url, uid, passwd);
}
catch(ClassNotFoundException e){
e.printStackTrace();
}
catch(SQLException e){
e.printStackTrace();
}
return conn;
}
}
=================
出现错误
2006-2-13 9:45:56 org.apache.coyote.http11.Http11BaseProtocol init
严重: Error initializing endpoint
java.net.BindException: Address already in use: JVM_Bind:8887
at org.apache.tomcat.util.net.PoolTcpEndpoint.initEndpoint(PoolTcpEndpoint.java:297)
at org.apache.coyote.http11.Http11BaseProtocol.init(Http11BaseProtocol.java:141)
at org.apache.catalina.connector.Connector.initialize(Connector.java:1016)
.............2006-2-13 9:45:56 org.apache.catalina.startup.Catalina load
严重: Catalina.start
LifecycleException: Protocol handler initialization failed: java.net.BindException: Address already in use: JVM_Bind:8887
at org.apache.catalina.connector.Connector.initialize(Connector.java:1018)
at org.apache.catalina.core.StandardService.initialize(StandardService.java:580)
at org.apache.catalina.core.StandardServer.initialize(StandardServer.java:782)
at org.apache.catalina.startup.Catalina.load(Catalina.java:503)..........006-2-13 9:45:56 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 2469 ms
2006-2-13 9:45:56 org.apache.catalina.core.StandardService start
信息: Starting service Catalina
2006-2-13 9:45:56 org.apache.catalina.core.StandardEngine start
信息: Starting Servlet Engine: Apache Tomcat/5.5.15
2006-2-13 9:45:56 org.apache.catalina.core.StandardHost start
信息: XML validation disabled
2006-2-13 9:45:59 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: contextInitialized()
2006-2-13 9:45:59 org.apache.catalina.core.ApplicationContext log
信息: SessionListener: contextInitialized()
2006-2-13 9:45:59 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: contextInitialized()
2006-2-13 9:45:59 org.apache.catalina.core.ApplicationContext log
信息: SessionListener: contextInitialized()
2006-2-13 9:46:00 org.apache.catalina.core.ApplicationContext log
严重: Error starting endpoint
java.net.BindException: Address already in use: JVM_Bind:8887
at org.apache.tomcat.util.net.PoolTcpEndpoint.initEndpoint(PoolTcpEndpoint.java:297)...........
-----------------------------------------
基本就是说端口8887被使用吧?不知道是不是这样.
可是我改过很多个端口了.还是同样的提示.当然是我先停止Tomcat服务的.连进程中都停止了再改
server.xml文件的端口的.
不知道是什么原因会这样的,真是奇怪.各位高手,同行帮帮忙.啊.
eclipse3.1+ jdk1.5.0 + tomcat5.5 + myeclpise4.0
window2003 +SQL2000+SQLsp3+JDBC(udpate3)
配置正确
如下代码连接SQL2000数据库测试通过,没问题.说明jdbc配置成功.
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%!
public static String getGBString(String src) {
try {
return new String(src.getBytes("ISO-8859-1"), "gb2312");
} catch (java.io.UnsupportedEncodingException e) {
return null;
}
}
%>
<html>
<body> <%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://192.168.1.114:1433;DatabaseName=pubs";
//pubs你的数据库的
String user="sa";
String password="1";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from titles";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=getGBString(rs.getString(1))%> <br>
您的第二个字段内容为:<%=getGBString(rs.getString(2))%> <br>
<%}%>
<%out.print("数据库操作成功,恭喜你");%> <br>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
==========================
问题:可是 在myeclipse中代码如下:package wu;
import java.sql.*;public class jdbc {
public jdbc(){}
Connection conn = null;
String gvDriver = "";
private String uid="sa";
private String passwd="1";
private String url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs";
private String classforname="com.microsoft.jdbc.sqlserver.SQLServerDriver";
//设置你的数据库ip
java.sql.Connection getConn(){
try{
Class.forName(classforname);
conn=DriverManager.getConnection(url, uid, passwd);
}
catch(ClassNotFoundException e){
e.printStackTrace();
}
catch(SQLException e){
e.printStackTrace();
}
return conn;
}
}
=================
出现错误
2006-2-13 9:45:56 org.apache.coyote.http11.Http11BaseProtocol init
严重: Error initializing endpoint
java.net.BindException: Address already in use: JVM_Bind:8887
at org.apache.tomcat.util.net.PoolTcpEndpoint.initEndpoint(PoolTcpEndpoint.java:297)
at org.apache.coyote.http11.Http11BaseProtocol.init(Http11BaseProtocol.java:141)
at org.apache.catalina.connector.Connector.initialize(Connector.java:1016)
.............2006-2-13 9:45:56 org.apache.catalina.startup.Catalina load
严重: Catalina.start
LifecycleException: Protocol handler initialization failed: java.net.BindException: Address already in use: JVM_Bind:8887
at org.apache.catalina.connector.Connector.initialize(Connector.java:1018)
at org.apache.catalina.core.StandardService.initialize(StandardService.java:580)
at org.apache.catalina.core.StandardServer.initialize(StandardServer.java:782)
at org.apache.catalina.startup.Catalina.load(Catalina.java:503)..........006-2-13 9:45:56 org.apache.catalina.startup.Catalina load
信息: Initialization processed in 2469 ms
2006-2-13 9:45:56 org.apache.catalina.core.StandardService start
信息: Starting service Catalina
2006-2-13 9:45:56 org.apache.catalina.core.StandardEngine start
信息: Starting Servlet Engine: Apache Tomcat/5.5.15
2006-2-13 9:45:56 org.apache.catalina.core.StandardHost start
信息: XML validation disabled
2006-2-13 9:45:59 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: contextInitialized()
2006-2-13 9:45:59 org.apache.catalina.core.ApplicationContext log
信息: SessionListener: contextInitialized()
2006-2-13 9:45:59 org.apache.catalina.core.ApplicationContext log
信息: ContextListener: contextInitialized()
2006-2-13 9:45:59 org.apache.catalina.core.ApplicationContext log
信息: SessionListener: contextInitialized()
2006-2-13 9:46:00 org.apache.catalina.core.ApplicationContext log
严重: Error starting endpoint
java.net.BindException: Address already in use: JVM_Bind:8887
at org.apache.tomcat.util.net.PoolTcpEndpoint.initEndpoint(PoolTcpEndpoint.java:297)...........
-----------------------------------------
基本就是说端口8887被使用吧?不知道是不是这样.
可是我改过很多个端口了.还是同样的提示.当然是我先停止Tomcat服务的.连进程中都停止了再改
server.xml文件的端口的.
不知道是什么原因会这样的,真是奇怪.各位高手,同行帮帮忙.啊.
解决方案 »
- 使用servlet报找不到相关的类的错
- Struts2下校验失败后返回页面为什么原来填入的数据被清空了?
- css的用法及其基本定义初学者
- 客户端调用服务器端的SERVLET
- 请问监听器和过滤器有什么区别
- 请问谁可以给一下JSP+Mysql的人事管理系统或者OA系统的源代码?感激不尽啊!或者告诉哪里可以下载也好啊
- 请教关于动态加载树型菜单的问题!
- 初学java问两个简单问题??????请大虾帮忙
- 请教怎么从序列化的表单里取值问题,求帮忙,急急急啊!~
- 这条sql语句怎么写
- java中到底能不能让服务起来自动复写URL。手工为每一个连接添加response.encodeURL实在是麻烦。
- 如何使用javaBean
会不会配置有问题?
我装了myeclipse,只配置了他的myeclipse下的
application servers-->Tomcat5
的JDK.
其它就是部署了一下工程.
不知道还要不要什么其它的配置?
把 Apache Tomcat 服务停了
端口已经被使用了,
所以你的tomcat一定是已经启动了
然后你的myclipse再去启动tomcat就出错了