userdaoimpl.java

来自「通过建立的数据库」· Java 代码 · 共 53 行

package test;

import java.sql.*;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2005</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
//操作员
public class UserDaoImpl{
	private JDBConnection connection = null;


	public UserDaoImpl() {
		this.connection = new JDBConnection();
	}


	//	登陆操作
	public String checkUser(String user) 
	{
		String sql = "select user_mm from tb_user where user_num='" + user + "'";
		try {
			ResultSet rs = connection.executeQuery(sql);
			if (rs.next())
			{
				return rs.getString(1);
			}
		}
		catch (SQLException ex) 
		{
		}
		return null;
	}
	//插入操作
	public void insertUser(String num,String mm,String name,String email,String tel)
	{
		
		String sql = "insert into tb_user values('"+num+"','"+mm+"','"+name+"','"+email+"','"+tel+"')";
		
			connection.executeQuery(sql);
		
	}
}