src/com/bar/db/Myusers.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package com.bar.db;
import java.sql.*;

/**
 *DROP TABLE IF EXISTS `myusers`; 
CREATE TABLE `myusers` (
`myuserid` bigint(20) unsigned not null auto_increment ,
`myuname` char(36) NOT NULL default '',
`sex` enum('男','女') NOT NULL default '男',
`pname` char(50) NOT NULL default '',
`address` varchar(255) NOT NULL default '', 
`email` char(50) NOT NULL default '',
`tel` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`myuserid`),
  UNIQUE KEY `myuserid` (`myuserid`)
) TYPE=MyISAM;
 * @author asus
 */
public class Myusers extends ExecuteDB
{
   private long myuserid;
   private String myuname;
   private String sex;
   private String pname;
   private String address;
   private String email;
   private String tel;
   private String strSql;

   public Myusers()
   {
       this.myuserid=0;
       this.myuname="";
       this.sex="";
       this.pname="";
       this.address="";
       this.email="";
       this.tel="";
       this.strSql="";
   }
   public boolean add()
   {
       this.strSql="insert into myusers ";
       this.strSql=this.strSql + "(myuname,sex,pname,address,email,tel) ";
       this.strSql=this.strSql + "values('" + this.myuname + "','" + this.sex + "','" + this.pname + "','" + this.address + "','" + this.email + "','" + this.tel + "')";
       boolean isAdd = super.exeSql(this.strSql);
       return isAdd;
   }
    public boolean delete(String sMyuserid)
        {
            this.strSql = "delete from myusers where myuserid in (";
            this.strSql = this.strSql + sMyuserid +")";

            boolean isDelete = super.exeSql(this.strSql);
            return isDelete;