后台注册信息的jdbc代码

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Register {
	public boolean passwordsregister(String passwords,String name,String phonenumbers,String email,String gender,String association,String address,String QQ,String VIP,String blog){//密码必须是18位以内
		ResultSet rs = null;//建立一个数据库表的对象
		Statement stmt = null;//用于执行静态SQL的对象
		Connection conn = null;//用于建立联系的对象
		try {
			Class.forName("com.mysql.jdbc.Driver");//构造一个"com.mysql.jdbc.Driver"类
			conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/firstdatabase", "root","family");//与数据库建立联系
			stmt = conn.createStatement();//创建一个 Statement 对象来将 SQL 语句发送到数据库
			String s = new String();
			rs=stmt.executeQuery("select * from tb_tab1 where name = '"+name+"'");//执行给定的 SQL 语句，该语句返回单个 ResultSet 对象
	        if(rs.next()){
	        	System.out.println("用户已存在！");
	        	return false;
	        }
	        else{
	        	rs=stmt.executeQuery("select * from tb_tab1 where email = '"+email+"'");//执行给定的 SQL 语句，该语句返回单个 ResultSet 对象
		        if(rs.next()){
		        	System.out.println("对不起，您的email地址与其他用户的email地址冲突，请换一个地址试一下！");
		        	return false;
		        }
		        else{
					s=passwords+"','"+name+"','"+phonenumbers+"','"+email+"','"+QQ+"','"+address+"','"+VIP+"','"+blog+"','"+gender+"','"+association;
					int i = stmt.executeUpdate("INSERT INTO tb_tab1 (passwords,name,phonenumbers,email,QQ,address,VIP,blog,gender,association) VALUES ('"+s+"');");//执行给定的 SQL 语句，该语句返回单个 ResultSet 对象
			        if(i==1){
			        	System.out.println("密码注册正确！");
			        	return true;
			        }	
			        else{
			        	System.out.println("密码不符合要求！");
			        	return false;
			        }
		        }
	        }
		}catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try{
				if(rs!=null){//如果不等于空
					rs.close();//关闭
				}
				if(stmt!=null){//如果不等于空
					stmt.close();//关闭
				}
				if(conn!=null){//如果不等于空 
					conn.close();//关闭
				}
			}catch(SQLException e){
				e.printStackTrace();
			}
		}		
		return true;
	}
	public static void main(String args[]){
		Register reg = new Register();
		String s = new String();
		reg.passwordsregister("1933","karld","10654","6143hg6@qq.com","male","CSDN协会",null,null,null,null);
	}
}