307036446384001d1bf6c7a55400e167

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

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