jsp使用jdbc、连接操作MySql数据库

jsp连接操作数据库的方法可能有很多,今天给大家介绍的是Statement方法
步骤分为以下几步:

  1. 加载数据库连接驱动
    Class.forName("com.mysql.jdbc.Driver");
  2. 获取数据库连接
    Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/myschol", "root", "qq694201656");
  3. 获取Statement对象,执行sql语句
String sql = "select * from `student`"; // 执行sql语句
Statement st =conn.createStatement();
ResultSet rs=st.executeQuery(sql);//获取数据集合
  1. 遍历,处理sql执行结果
while(rs.next()){
    int studentId = rs.getInt("StudentNo");
    String studentName = rs.getString("StudentName");
    String addRESS = rs.getString("AddRESS");
    String email = rs.getString("Email");
    System.out.println("studentId:"+studentId+"studentName:"+studentName+"addRESS:"+addRESS+"email"+email);
}
  1. 关闭流
rs.close();
st.close();
conn.close();

全部代码参考下面:

public static void main(String[] args) {
    Connection conn =null;
    Statement st = null;
    ResultSet rs=null;
        
    try {
        // 1. 加载数据库连接驱动
        Class.forName("com.mysql.jdbc.Driver");
        // 2. 获取数据库连接
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/myschol", "root", "qq694201656");
        // 3. 获取Statement对象,执行sql语句
        String sql = "select * from `student`"; // 执行sql语句
        st =conn.createStatement();
        rs=st.executeQuery(sql);//获取数据集合
        // 4. 遍历,处理sql执行结果
        while(rs.next()){
            int studentId = rs.getInt("StudentNo");
            String studentName = rs.getString("StudentName");
            String addRESS = rs.getString("AddRESS");
            String email = rs.getString("Email");        
                    System.out.println("studentId:"+studentId+"studentName:"+studentName+"addRESS:"+addRESS+"email"+email);
    }
    } catch (ClassNotFoundException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } finally{
        try {
            // 5. 关闭流
            rs.close();
            st.close();
            conn.close();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
            
    }
}

当然,使用Statement这种方法还有很多弊端,对于初学者,我们可以用以学习!!!

Last modification:December 15th, 2017 at 12:04 am
If you think my article is useful to you, please feel free to appreciate

Leave a Comment