conn.jsp

jsp+ajax实例

<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String db=getServletContext().getRealPath("\\")+"music.mdb";
File dbpath=new File(db);
String path = new java.io.File(db).getAbsolutePath();
Connection conn= DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};" +
"DBQ="+path);
//PreparedStatement stmt=conn.prepareStatement();
Statement stmt=conn.createStatement();
%>