我用JSP做网站 其中登陆器和注册怎么连数据库啊,我做出了界面但是数据库不知道怎么连,急急急``

来源:百度知道 编辑:UC知道 时间:2024/06/04 12:40:01
连接Access

楼上说了那么多也没说到点子上去!!

连ACCESS:
String spath = "zdco/test.mdb";
String dbpath = application.getRealPath(spath);
String dbname = "";
String user = "";
String url ="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="+dbpath;

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(); String sql = "select * from user";
ResultSet rs = stmt.executeQuery(sql);

例子:
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e1){}
try{
con=DriverManager.getConnection("jdbc:odbc:sun","","");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery("SELECT * FROM zhuanye");
while(rs.next()){
f++;