JSP数据库操作示例-优快云博客

本文链接：https://blog.youkuaiyun.com/Sir_LuciFer/article/details/4640551

1.创建数据库（自己进行）

略 .

<%--
 Document : index
 Created on : 2009-10-7, 14:27:45
 Author : lucifer
--%>

<%@page import="java.sql.*" contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
 "http://www.w3.org/TR/html4/loose.dtd">

<html>
 <head>
 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
 <title>JSP Page</title>
 </head>
 <%
 Class.forName
 ("com.mysql.jdbc.Driver").newInstance();
 String url = "jdbc:mysql://localhost/my" +
 "?user=root&password=lxh6589775"; //改成自己的
 Connection conn = DriverManager.getConnection(url);
 Statement stmt = conn.createStatement
 (ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

2.创建表：
          String sql = "create table Article(" +
                  "ID float NOT NULL UNIQUE," +
                  "Article varchar(50)," +
                  "UserID float," +
                  "Username varchar(30)," +
                  "HypotaxissubID float," +
                  "ReplyID float," +
                  "Clickcount float);";

stmt.execute(sql);

3.插入数据(实例)：
 String[] insertvalue = {"insert into article " +
 "values(1,'Welcome...',9999,'admin',1,null,80);",
 "insert into article " +
 "values(633,'My first article',3689,'onlyyou',3,null,90);",
 "insert into article " +
 "values(756,'My first too...',9973,'xixi',3,633,76);"};
 for(int i = 0;i <= insertvalue.length;i++){

stmt.execute(insertvalue[i]);

}

4.Select,ResultSet,ResultSetMetaData.
 String sqlstring = "select UserID,Username,Clickcount " +
 "from Article order by ID DESC;";

 ResultSet rs = stmt.executeQuery(sqlstring);
 ResultSetMetaData rsmd = rs.getMetaData();
 int columncount = rsmd.getColumnCount();
 for(int i =1;i <= columncount;i++){
 out.println(rsmd.getColumnLabel(i));
 out.println(rsmd.getColumnTypeName(i));
 out.print(" ");
 }
 out.println(" ");
 while(rs.next()){
 for(int j = 1;j <= columncount;j++){
 out.println(rs.getString(j));
 }
 out.println(" ");
 }
5.更新
 String updatestring = "update article set clickcount = " +
 "clickcount + 1 where id = 1;";
 stmt.executeUpdate(updatestring);

6.关闭数据库

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

7.异常

try{

...............

}

catch(SQLException ex){
 out.print("SQL exception caught!");
 while(ex != null){
 out.println("Message:" + ex.getMessage() + " ");
 out.println("SQL state:" + ex.getSQLState() + " ");
 out.println("Error code:" + ex.getErrorCode() + " ");
 ex = ex.getNextException();
 }
}

MySQL操作示例