2044e4776384001d1bf6c7a55400e167

一个简单的备忘录实现全部功能基于MVC框架开发以MySql为数据库

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))){
		
		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
		}
		}
		
		return null;
	
	
	}
}