81,092
社区成员
发帖
与我相关
我的任务
分享
public class CoursesServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public CoursesServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String sDBDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String dbURL = "jdbc:sqlserver://localhost:1433; databasename=sample";
Connection dbconn = null;
try {
Class.forName(sDBDriver);
dbconn = DriverManager.getConnection(dbURL, "user", "pwd");
String sql = "select * from courses for xml path";
Statement stmt = dbconn.createStatement();
ResultSet res = stmt.executeQuery(sql);
PrintWriter out = response.getWriter();
if (res.next())
out.print("<table>" + res.getString(1) + "</table>");
dbconn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
<servlet>
<servlet-name>CoursesServlet</servlet-name>
<servlet-class>servlet.xml.CoursesServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>CoursesServlet</servlet-name>
<url-pattern>/xml/Courses</url-pattern>
</servlet-mapping>
<?xml version="1.0" encoding="UTF-8" ?>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix="x" uri="http://java.sun.com/jsp/jstl/xml"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Insert title here</title>
</head>
<body>
<c:import url="/xml/Courses" var="courses" />
<x:parse xml="${courses}" var="doc" />
<table border="1">
<x:forEach var="row" select="$doc/table/row">
<tr>
<x:forEach select="$row/*" var="col">
<td><x:out select="$col" /></td>
</x:forEach>
</tr>
</x:forEach>
</table>
</body>
</html>
用Java语言从access数据库中,把一些数据导入到SQL数据库中。
<iframe align=center marginWidth=0 marginHeight=0 src="http://images.chinabyte.com/adjs/iframe-pip/y-software-pip.html" frameBorder=0 width=360 scrolling=no height=300></iframe>
原Access数据库表结构:
表:production
<table cellSpacing=0 width="90%" align=center border=1> <tr> <td>产品型号</td> <td>字符串型</td> <td>产品编号</td></tr> <tr> <td>零件图号</td> <td>字符串型</td> <td>零件编号</td></tr> <tr> <td>图号 </td> <td>字符串型</td> <td>工具编号</td></tr></table>
SQL Server中数据表结构:
Project 产品表
<table cellSpacing=0 width="60%" align=center border=1> <tr> <td>Id </td> <td>int </td> <td>标识</td></tr> <tr> <td>Number</td> <td>varchar64</td> <td>编号</td></tr></table>
Product 零件表
<table cellSpacing=0 width="66%" align=center border=1> <tr> <td>Id </td> <td>int </td> <td>标识</td></tr> <tr> <td>pid</td> <td>int</td> <td>产品标识号(与project表中的id相关联)</td></tr> <tr> <td>Number</td> <td>varchar64</td> <td>编号</td></tr></table>
Componenttype 与零件对应的生产工具表
<table cellSpacing=0 width="78%" align=center border=1> <tr> <td width="16%">Id</td> <td width="20%">int</td> <td width="64%">标识</td></tr> <tr> <td>aid</td> <td>int</td> <td>零件标识(与product表中的id关联)</td></tr> <tr> <td>Number</td> <td>varchar64 </td> <td>编号</td></tr></table>
要求把原来的编号分别放到下面的SQL Server数据库的三个表格中,并用id关联起来。
考虑到数据库连接可能有变化,决定使用xml来配置数据连接。Dbs.xml文件内容如下:
<table borderColor=#ffcc66 cellSpacing=0 width="90%" align=center bgColor=#c8be9d border=1> <tr> <td><?xml version="1.0" encoding="GBK"?>
<dbcopy>
<source>
<class>sun.jdbc.odbc.JdbcOdbcDriver</class>
<url>jdbc:odbc:asrs</url>
<user>""</user>
<password>""</password>
</source>
<dest>
<class>com.microsoft.jdbc.sqlserver.SQLServerDriver</class>
<url>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=vxms</url>
<user>vxms</user>
<password>vxms</password>
</dest>
</dbcopy></td></tr></table>
zmbbs=1;
去看看
http://www.99inf.net/SoftwareDev/Java/44078.htm