java 开发+运行环境配置+连接 sql 2008

1 Resin 1.1将resin-pro-4.0.7.zip解压：D:/servers 1.2 设置JAVA_HOME 如：D:/Sun/SDK/jdk 1.3 设置RESIN_HOME 如：D:/servers/resin-pro-4.0.7 1.4 启动Resin D:/servers/resin-pro-4.0.7/lib>java -jar resin.jar Resin requires a command: console - start Resin in console mode status - watchdog status start - start a Resin server stop - stop a Resin server restart - restart a Resin server kill - force a kill of a Resin server shutdown - shutdown the watchdog

D:/servers/resin-pro-4.0.7/lib>java -jar resin.jar start Resin/4.0.7 launching watchdog at 127.0.0.1:6600 Resin/4.0.7 started -server for watchdog at 127.0.0.1:6600

D:/servers/resin-pro-4.0.7/lib>java -jar resin.jar stop Resin/4.0.7 stopped -server for watchdog at 127.0.0.1:6600

D:/servers/resin-pro-4.0.7/lib>

1.5

2 MyEclipse 我用的ALL IN ONE安全版myeclipse-8.5.0-win32.exe。安全好就可以了。

3 配置Resin与MyEclipse整合

配置好了就可以MyEclipse中启动Resin了

4 连接到Sql Server 2008 4.1 JDBC驱动 JDBC驱动用的Sql Server 2008官方驱动: SQL Server JDBC Driver 3.0 需要注意的是：现在JRE一般是1.6，所以，我们选用的是sqljdbc4.jar

4.2 创建Web项目

4.3添加JDBC驱动引用 先在项目上右击，然后

选择“Add External Archives”才会所JDBC驱动发布到应用目录中。

4.4添加jsp文件

4.5写代码

<%@ page import="java.sql.*" %> <h1>test</h1> <% // Create a variable for the connection string. String connectionUrl = "jdbc:sqlserver://192.168.0.201:2008;" + "databaseName=testA;user=sa;password=ikmbikmb;"; // Declare the JDBC objects. Connection con = null; Statement stmt = null; ResultSet rs = null; try { // Establish the connection. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); con = DriverManager.getConnection(connectionUrl); // Create and execute an SQL statement that returns a // set of data and then display it. String SQL = "SELECT top 100 * FROM Table_1;"; stmt = con.createStatement(); rs = stmt.executeQuery(SQL); System.out.println("a"); while (rs.next()) { out.println(rs.getString("val")+"<br>"); } } // Handle any errors that may have occurred. catch (Exception e) { e.printStackTrace(); } finally { if (rs != null) try { rs.close(); } catch(Exception e) {} if (stmt != null) try { stmt.close(); } catch(Exception e) {} if (con != null) try { con.close(); } catch(Exception e) {} } %>

5 发布项目

浏览：

完

SQL Server JDBC Driver 3.0 文档：