usermanager.java

这些是用java编写的小程序

package com.tw.net.service;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.List;
import java.util.Vector;

import com.tw.net.Person;

public class UserManager extends DBBase implements IUer {

	public Person regist(Person p) {
		// TODO 自动生成方法存根
		String insert = "insert into person values ('" + p.getName() + "','"
				+ p.getPassword() + "','" + p.getAddress() + "','" + p.getSex()
				+ "')";
		int i = executeUpdate(insert);
		
		if (i == 1)
			return p;
		else
			return null;
	}

	public boolean login(int id, String password) {
		String reg_sql = "select * from person where id=" + id;
		ResultSet rs = executeQuery(reg_sql);
		try {
			if (rs.next()) {
				if (rs.getString("password").equals(password))
					return true;
			}
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		} finally {
			close();
		}
		return false;
	}
	public void modify(Person p){
		String update = "update person set name='"+p.getName()
		+"',password='"+p.getPassword()+"','"+p.getAddress()
		+"','"+p.getSex()+"' where id="+p.getId();
		System.out.println(update);
		executeUpdate(update);
	}

}