userutil.java

来自「java登陆界面 java登陆界面」· Java 代码 · 共 48 行

package com.liup.util;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class userUtil {
	private Connection conn=null;
	private PreparedStatement pt=null;
	private boolean flag=false;
	
	public boolean adminLogin(String username,String pwd,String truename,String sex,String phone,String email,String address,String postalCode){
		conn=DBConn.getConn();
		try {
			pt=conn.prepareStatement("insert into [user] values(?,?,?,?,?,?,?,?)");
			pt.setString(1, username);
			pt.setString(2, pwd);
			pt.setString(3, truename);
			pt.setString(4, sex);
			pt.setString(5, phone);
			pt.setString(6, email);
			pt.setString(7, address);
			pt.setString(8, postalCode);
			int n = pt.executeUpdate();
			System.out.println(n);
			if(n==1){
				flag=true;
			}
			
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally{
			try {
				pt.close();
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
		}	System.out.println("user: "+flag);
		return flag;	
	}
}