//jdbc access
<%@ page import="java.sql.*"%>
<%
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Program Files/Apache Group/Tomcat 4.1/webapps/examples/myjsp/tushu/inc/db.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn= DriverManager.getConnection(strurl);
Statement stmt=conn.createStatement();
红色的为绝对路径
%>
------------------------------------------------------------------->
//jdbc sqlsever2000
public static Connection getConnection() throws SQLException{
String classforname="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=good";
String user="sa";
String pas="a7788250";
Connection conn=null;
try{
Class.forName(classforname);
conn=DriverManager.getConnection(url,user,pas);
}
catch(Exception e){
e.printStackTrace();
}
return conn;
}