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 http://localhost:8080/

 

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 发布项目

 

浏览：http://localhost:8080/testA/sql.jsp

 

完

SQL Server JDBC Driver 3.0 文档：
http://technet.microsoft.com/zh-cn/library/dd631800(SQL.10).aspx