JSPÁ¬½ÓSQL SERVER 2008 ÕÒ²»µ½Çý¶¯
ÄÄλ¸ßÊÖÄܰïÎÒ¿´ÏÂΪʲôÅ׳öÕâЩÒì³££¿
´úÂë
<%@ page language="java" import="java.util.*" contentType="text/html; charset=ISO-8859-1"
pageEncoding="GB2312"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<jsp:directive.page import="java.lang.Class"/>
<jsp:directive.page import="java.sql.DriverManager"/>
<jsp:directive.page import="java.sql.Connection"/>
<jsp:directive.page import="java.sql.Statement"/>
<jsp:directive.page import="java.sql.ResultSet"/>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>SQL Server 2008</title>
</head>
<body topmargin="0">
<%
out.println("hello");
String driverClass="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=JSP_TEST";
String username="DONGJIN";
String password="dongjin";
try
{
Class.forName(driverClass);
}
catch(ClassNotFoundException e)
{
out.println("------ÔÚ¼ÓÔØÊý¾Ý¿âÇý¶¯Ê±Å׳öÒì³££¬ÄÚÈÝÈçÏ£º");
e.printStackTrace();
}
Connection conn=DriverManager.getConnection(url,username,password); //½¨Á¢Á¬½Ó
Statement stmt=conn.createStatement(); //´´½¨Á¬½Ó״̬
ResultSet rs=stmt.executeQuery("select * from table1"); //Ö´ÐÐselectÓï¾ä
%>
<tr>
<td align="center">
<table width="30%" bordercolor="#00CC66" border="1">
<tr align="center" bgcolor="#FF6633">
<td>񅧏</td>
&nb
Ïà¹ØÎĵµ£º
<?xml version="1.0" encoding="UTF-8"?>
<%@ page contentType="text/html; charset=UTF-8" language="java" import="java.sql.*" errorPage="" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+pat ......
ÃæµÄÉϱã»áµ¯³öÓò¿ØÑéÖ¤µÄ
¸÷λ,ÉÏ´ÎÔÚȺÖÐÎʵ½¹ØÓÚJsp WEBϵͳµÇ¼ÓëÓò¿Ø½áºÏ×öÓû§ÑéÖ¤µÄÎÊÌâ,ÏÖÔÚÒѾ½â¾ö,½«½â¾ö°ì·¨Óë¸÷λ·ÖÏíÏÂ:
½â¾ö·½°¸:ʹÓÃsamba×éÖ¯µÄ¿ªÔ´ÏîÄ¿jCIFS
ÏîÄ¿Ê×Ò³:http://jcifs.samba.org/
²Î¿¼×ÊÁÏ:
ʹÓÃjcifs.jar¿ÉÒԷdz£ºÃʵÏÖ£¬ÏÂÔØÒ»¸ö×îеÄjcifs.jar£¬·Åµ½WEB-INFlibÏÂÃæ£¬È»ºóÐÞ¸Ä ......
SAP ʹÓÃSQL Trace£¨ST05£©
SAP R/3 Ìṩ±ê×¼ABAP SQL ¸ú×Ù¹¤¾ß¡£Ê¹ÓÃT-Code:ST05 ¿ÉÒÔ½øÈë×·×ÙÉ趨»Ã棺
ÔÚTrace Modes ÇøÓòÖÐÑ¡ÔñÐèÒªÔÚSAP R/3 Server ÉÏtrace µÄ·¶Î§£º
SQL Trace: ×·×Ù¸ÃA ......
[MySQLÓÅ»¯] -- ÈçºÎÁ˽âSQLµÄÖ´ÐÐÆµÂÊ
ʱ¼ä:2010-2-28À´Ô´:HaCMS¿ªÔ´ÉçÇø ×÷Õß:chuxu
MySQL ¿Í»§¶ËÁ¬½Ó³É¹¦ºó£¬Í¨¹ý show [session|global]status ÃüÁî ¿ÉÒÔÌṩ·þÎñÆ÷״̬ÐÅÏ¢£¬Ò²¿ÉÒÔÔÚ²Ù×÷ϵͳÉÏʹÓà mysqladmin extended-status ÃüÁî»ñµÃÕâЩÏûÏ¢¡£ show [session|global] status ¿ÉÒÔ¸ù¾ÝÐèÒª¼ÓÉϲÎÊý&ldquo ......
¶¨Ò壺 ºÎΪ´¥·¢Æ÷£¿ÔÚSQL ServerÀïÃæÒ²¾ÍÊǶÔijһ¸ö±íµÄÒ»¶¨µÄ²Ù×÷£¬´¥·¢Ä³ÖÖÌõ¼þ£¬´Ó¶øÖ´ÐеÄÒ»¶Î³ÌÐò¡£´¥·¢Æ÷ÊÇÒ»¸öÌØÊâµÄ´æ´¢¹ý³Ì¡£
³£¼ûµÄ´¥·¢Æ÷ÓÐÈýÖÖ£º·Ö±ðÓ¦ÓÃÓÚInsert , Update , Delete ʼþ¡£(SQL Server 2000¶¨ÒåÁËеĴ¥·¢Æ÷£¬Õ ......