JSP数据库连接

JSP数据库连接

利用jdbc:odbc连接

PreparedStatement:

<%@page contentType="text/html;charset=gb2312"%>

<%@page import ="java.sql.*"%>

<%

       String driver="sun.jdbc.odbc.JdbcOdbcDriver";

       String url="jdbc:odbc:mldn";

 

       Connection con=null;

       PreparedStatement pstmt=null;

       String sql=null;

       ResultSet rs=null;

 

%>

<%

       request.setCharacterEncoding("GB2312");

       String name=request.getParameter("uname");

       String password=request.getParameter("upass");

       int age=0;

       try

       {

             

              age =Integer.parseInt(request.getParameter("age"));

       }

       catch(Exception ex)

       {

              out.println(ex);

       }

       //sql="insert into person(name,password,age) values(?,?,?)";

       sql="select * from person";

       try

       {

              Class.forName(driver);

              con=DriverManager.getConnection(url);

              pstmt=con.prepareStatement(sql);

              /*

             

              pstmt.setString(1,name);

              pstmt.setString(2,password);

              pstmt.setInt(3,age);

              //pstmt.executeUpdate();

              */

              rs=pstmt.executeQuery();

              while(rs.next())

              {

                     int id=rs.getInt(1);

                      name=rs.getString(2);

                      password=rs.getString(3);

                      age=rs.getInt(4);

                     %>

                     <h1>id:<%=id%>,姓名:<%=name%>,密码:<%=password%>,年龄:<%=age%>

                     <%

              }

 

 

       }

       catch(Exception e)

       {

              out.println("数据库操作失败");

       }

       try

       {

              pstmt.close();

              con.close();

 

       }

       catch(Exception ee)

       {

              out.println("数据库关闭失败");

       }

%>

 

Statement:

<%@ page contentType="text/html;charset=gb2312"%>

<%@ page import="java.sql.*"%>

<%--

       此代码主要进行查询操作

--%>

<%!

       // 定义数据库驱动程序

       String DBDRIVER = "sun.jdbc.odbc.JdbcOdbcDriver" ;

       // 定义数据库连接地址

       String DBURL = "jdbc:odbc:mldn" ;

 

       // 定义数据库连接对象，属于java.sql包中的接口

       Connection conn = null ;

 

       // 定义Statement对象，用于操作数据库

       Statement stmt = null ;

 

       // 定义一字符串变量，用于保存SQL语句

       String sql = null ;

 

       // 查询返回的结果集对象

       ResultSet rs = null ;

%>

<%

       // 1、加载驱动程序

       try

       {

              Class.forName(DBDRIVER) ;

       }

       catch(Exception e)

       {

              // 此处使用out.print是处于演示目的，在实际开发中所有的错误消息，绝对不能够通过out.print打印，否则会存在安全问题

              out.println("数据库驱动程序加载失败！！！") ;

       }

 

       // 2、连接数据库

       try

       {

              conn = DriverManager.getConnection(DBURL) ;

       }

       catch(Exception e)

       {

              out.println("数据库连接失败！！！") ;

       }

 

       // 3、操作数据库

       // 通过Connection对象实例化Statement对象

       try

       {

              stmt = conn.createStatement() ;

              // 编写查询的SQL语句

              sql = "SELECT id,name,password,age FROM person" ;

              // 查询数据库，此方法返回ResultSet对象

              rs = stmt.executeQuery(sql) ;

%>

       <table border="1" width="80%">

       <tr>

              <td>ID</td>

              <td>姓名</td>

              <td>密码</td>

              <td>年龄</td>

       </tr>

<%

              while(rs.next())

              {

                     int id = rs.getInt(1) ;

                     String name = rs.getString(2) ;

                     String password = rs.getString(3) ;

                     int age = rs.getInt(4) ;

%>

                     <tr>

                            <td><%=id%></td>

                            <td><%=name%></td>

                            <td><%=password%></td>

                            <td><%=age%></td>

                     </tr>

<%

              }

%>

       </table>

<%

       }

       catch(Exception e)

       {

              out.println("操作数据库失败！！！") ;

       }

       // 4、关闭数据库

       try

       {

              // 关闭结果集

              rs.close() ;

              // 关闭操作

              stmt.close() ;

              // 关闭连接

              conn.close() ;

       }

       catch(Exception e)

       {

              out.println("数据库关闭失败！！！") ;

       }

%>