servlet连接数据库实例.doc

JAVA程序设计?1. jdk的安装?(1) 下载jdk-6u3-windows-i586-p.exe，安装到D:\Program Files\Java?(2) 配置jdk的环境变量?a) 在系统变量中新建JAVA_HOME，其值为?D:\Program Files\Java\jdk1.6.0_03?b) 在classpath中添加?.;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar;?c) 在Path中添加%JAVA_HOME\bin;?(3) 在DOS下输入java和javac命令，若均可用，则jdk安装成功。?2. tomcat的安装?(1)下载tomcat，下载地址/index.html?(2)把tomcat 拷贝到D盘，再配置环境变量。?a) 在系统变量中新建?CATALINA_HOME=D:\tomcat?CATALINA_BASE=D:\tomcat?b) 再在Path中添加%CATALINA_HOME%\common\lib\servlet.jar?(3)测试服务器,打开D:\tomcat\bin文件夹下的startup.bat,在浏览器地址栏输入http://localhost:8080/,如果能正确显示Tomcat服务器说明页面，则配置好。?3. 数据库的连接?(1) 下载SQLServer JDBC driver type4的类包mssqlserver.jar,msutil.jar和msbase.jar放在D盘下，然后在环境变量classpath中添加者三个jar文件的路径。?(2) 下载servlet-api.jar和jsp-api.jar，然后在环境变量中添加它们的路径。这个程序我是在eclipse中运行的，也可以在Project-Properties-Java Build Path-Add External JARs中添加它们，或者直接拷贝到%JAVA_HOME%\jre\lib\ext\。?(3) 如果是SQL2000，则需升级到sql2000 sp4。?(4) 运行下面的程序：结果为如图1，数据库内容如图2??图1??图2? 查看复制到剪切板打印 Package?test;?? import?java.sql.*;??? public?class?InsertCoffees?{??? ????????public?static?void?main(String?args[])?{??? ????????????????String?url?=?url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=chfjava;??? ????????????????Connection?con;??? ????????????????Statement?stmt;??? ????????????????String?query?=?select?*?from?clothes;??? ????????????????try?{??? ????????????????????????Class.forName(com.microsoft.jdbc.sqlserver.SQLServerDriver);??? ????????????????}??? ????????????????catch(java.lang.ClassNotFoundException?e)?{??? ????????????????????????System.err.print(ClassNotFoundException:?);??? ????????????????????????System.err.println(e.getMessage());??? ????????????????}??? ????????????????try?{??? ????????????????????????con?=?DriverManager.getConnection(url,?sa,?);??? ????????????????????????stmt?=?con.createStatement();?? ????????????????????????ResultSet?rs?=?stmt.executeQuery(query);??? ????????????????????????while?(rs.next())?{??? ????????????????????????????????String?s?=?rs.getString(id);??? ????????