登録/登録ページについてのまとめ

登録/ログインWebページのデータベースへの接続について:
登録:

 String id = request.getParameter("id");
	String member = request.getParameter("member");
	String pass = request.getParameter("pass");
	String name = request.getParameter("name");
	try {
        //1，    
        Class.forName("com.mysql.jdbc.Driver");
        //2，    
        java.sql.Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/sht", "root", "root");
        //3，  sql    
        Statement stmt = conn.createStatement();       
        //4， sql    sql             ，     
		String sql = "insert into member value('"+id+"','"+member+"','"+pass+"','"+name+"')";
        stmt.executeUpdate(sql); 
        stmt.close();
        conn.close();

ジャンプコード:

response.sendRedirect("login.html");//   login.html

ログイン:

<form id="form1" name="form1" method="post" action="dologin.jsp">//           dologin.jsp

リストsqlを表示するには:

try{
  Class.forName("com.mysql.jdbc.Driver");
  java.sql.Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/sht","root","root");
  Statement stmt = conn.createStatement();
  String sql = "select * from member";  
  ResultSet rs = stmt.executeQuery(sql);	  
  while(rs.next()){

変更ページに移動し、変更する行の「id」を渡します.

<a href="update.jsp?id=<%=rs.getString(1)%>">  </a>

ここでid=<%=rs.getString(1)%>は伝送IDである

try {
        //1，    
        Class.forName("com.mysql.jdbc.Driver");
        //2，    
        java.sql.Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/sht", "root", "root");
        //3，  sql    
        Statement stmt = conn.createStatement();       
        //4， sql    sql             ，     
		String sql = "update member set member ='"+member+"',pass='"+pass+"',name='"+name+"' where id='"+id+"'";//    
        stmt.executeUpdate(sql); 
        stmt.close();
        conn.close();
	 } catch (Exception e) {
        System.out.println(e);
    }
	 response.sendRedirect("dolist.jsp");

削除ページに移動し、削除する行の「id」を渡します.

<a href="delete.jsp?id=<%=rs.getString(1)%>">

try {
        //1，    
        Class.forName("com.mysql.jdbc.Driver");
        //2，    
        java.sql.Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/sht", "root", "root");
        //3，  sql    
        Statement stmt = conn.createStatement();       
        //4， sql    sql             ，     
		String sql = "delete  from member  where id='"+id1+"'";//    delete  from member  
        stmt.executeUpdate(sql); 
        stmt.close();
        conn.close();
	 } catch (Exception e) {
        System.out.println(e);
    }
	 response.sendRedirect("dolist.jsp");