JSP基本的增删改查操作--MySql(备忘)

好吧，最近学了一阵子的ssh回过头来发现，JSP简单的CRUD忘得差不多了，基础不牢靠，记录记录(最原始的写法)

insert

 <%
    	Class.forName("com.mysql.jdbc.Driver");
		Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/book","root","123456");
		String sql = "insert into booktype (detail,title,id) values (?,?,null)";
		PreparedStatement ps = conn.prepareStatement(sql);
		ps.setString(1,"descripton");
		ps.setString(2,"Japan");
		ps.executeUpdate();
		ps.close();
		conn.close();
		
     %>

update

<%
    	Class.forName("com.mysql.jdbc.Driver");
		Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/book","root","123456");
		String sql = "update booktype set title = ? where id = ?";
		PreparedStatement ps = conn.prepareStatement(sql);
		ps.setString(1,"china");
		ps.setInt(2,2);
		ps.executeUpdate();
		ps.close();
		conn.close();
		
     %>

select

<%
    	Class.forName("com.mysql.jdbc.Driver");
		Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/book","root","123456");
		String sql = "select * from booktype";
		PreparedStatement psQuery = conn.prepareStatement(sql);
		ResultSet rs = psQuery.executeQuery();
		while(rs.next()){
			int id = rs.getInt("id");
			String title = rs.getString("title");
			String detail = rs.getString("detail");
			System.out.println(id);
			System.out.println(title);
			System.out.println(detail);
		}
		rs.close();
		psQuery.close();
		conn.close();
		
     %>

delete

  <%
    	Class.forName("com.mysql.jdbc.Driver");
		Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/book","root","123456");
		String sql = "delete from booktype where id = ?";
		PreparedStatement ps = conn.prepareStatement(sql);
		ps.setInt(1,1);
		ps.executeUpdate();
		ps.close();
		conn.close();
		
     %>