Jsp连接数据库代码

最新推荐文章于 2019-11-10 12:04:41 发布

ganzhijie

最新推荐文章于 2019-11-10 12:04:41 发布

阅读量276

点赞数

分类专栏： Jsp&Xml

本文链接：https://blog.csdn.net/ganzhijie/article/details/38489307

版权

Jsp&Xml 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*" %>
<html>
<body>
<%

try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}

catch(ClassNotFoundException e){
out.print("数据库驱动程序装入错误");
}

try{

String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+request.getRealPath("/")+"data.mdb";

//特别注意上面的Driver和(*.mdb)之间是有空格的

Connection conn=DriverManager.getConnection(url);

Statement stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery("SELECT * FROM info_student");

while(rs.next()){
out.print(rs.getString("id")+" ");
out.print(rs.getString("name")+" ");
out.println("<br>");
}

rs.close();
stmt.close();
conn.close();
}

catch(Exception ex){
out.print(ex);
}

%>
</body>
</html>

下面是做插入的，修改和删除的类似
<%@page contentType="text/html;charset=gb2312"%>
<%@page import="java.sql.*" %>
<html>
<body>
<%

try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}

catch(ClassNotFoundException e){
out.print("数据库驱动程序装入错误");
}

try{

String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+request.getRealPath("/")+"data.mdb";

Connection conn=DriverManager.getConnection(url);

Statement stmt=conn.createStatement();

stmt.executeUpdate("insert into info_student(name) values('zhao6')");

stmt.close();
conn.close();
}

catch(Exception ex){
out.print(ex);
}

%>
</body>
</html>