30f642d26584001d1bf6c7a55400e167

来自「一个简单的备忘录实现全部功能基于MVC框架开发以MySql为数据库」· 代码 · 共 57 行

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;


import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


public class RegMo {

	public String write(HttpServletRequest request,HttpServletResponse response){
		
		
		String	username=request.getParameter("uname");
		String	password=request.getParameter("upass");
		String  rpassword=request.getParameter("rupass");
		if(!("".equals(username)||"".equals(password) || "".equals(rpassword))){
			if(password.equals(rpassword)){
				String driverName="com.mysql.jdbc.Driver";
				String dbURL="jdbc:mysql://localhost:3306/test";
				String dbuser="root";
				String dbpass="1234";
				Connection dbcon;
			try {
				Class.forName(driverName);
				dbcon = DriverManager.getConnection(dbURL, dbuser, dbpass);
				String sql = "insert into User(username,password) VALUES(?,?)";
				PreparedStatement pstmt = dbcon.prepareStatement(sql);
				pstmt.setString(1, username);
				pstmt.setString(2, password);
				pstmt.executeUpdate();
			
			
				} catch (Exception e) {
					// TODO: handle exception
			}	}
		}
		else{
			
			try {
				response.sendRedirect("./fai.jsp");
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}
		
		return null;
	
	
	}
}