Разработка программы помощи судебному исполнителю

PrintWriter out = response.getWriter();

out.write(jo.toJSONString());

out.flush();

out.close();

}

if(request.getParameter("deleteobj")!=null&&request.getParameter("deleteobj").toString().equalsIgnoreCase("true"))

{

Imus is=null;

JSONObject jo=new JSONObject();

try

{

int id=Integer.parseInt(request.getParameter("id"));

imf.remove(imf.find(id));

jo.put("res",true);

}

catch(Exception e)

{

jo.put("res",false);

}

System.out.println(jo.toJSONString());

PrintWriter out = response.getWriter();

out.write(jo.toJSONString());

out.flush();

out.close();

}

if(request.getParameter("gettypes")!=null&&request.getParameter("gettypes").toString().equalsIgnoreCase("show"))

{

JSONArray arr=new JSONArray();

List <TypeIspList> tis=tif.findAll();

for(int i=0;i<tis.size();i++)

{

JSONObject jo=new JSONObject();

jo.put("id", tis.get(i).getId());

jo.put("name", tis.get(i).getName());

arr.add(jo);

}

PrintWriter out = response.getWriter();

out.write(arr.toJSONString());

out.flush();

out.close();

}

if(request.getParameter("getusers")!=null&&request.getParameter("getusers").toString().equalsIgnoreCase("show"))

{

JSONArray arr=new JSONArray();

List <User> ul=uf.findAll();

int login=(int)se.getAttribute("id");

for(int i=0;i<ul.size();i++)

{

if(ul.get(i).getLogin()!=login)

{

JSONObject jo=new JSONObject();

jo.put("id", ul.get(i).getLogin());

jo.put("pass", ul.get(i).getPass());

arr.add(jo);

}

}

PrintWriter out = response.getWriter();

out.write(arr.toJSONString());

out.flush();

out.close();

}

if(request.getParameter("deluser")!=null&&request.getParameter("deluser").toString().equalsIgnoreCase("true"))

{

User us=null;

JSONObject jo=new JSONObject();

try

{

int id=Integer.parseInt(request.getParameter("id"));

uf.remove(uf.find(id));

jo.put("res",true);

}

catch(Exception e)

{

jo.put("res",false);

}

PrintWriter out = response.getWriter();

out.write(jo.toJSONString());

out.flush();

out.close();

}

if(request.getParameter("deltype")!=null&&request.getParameter("deltype").toString().equalsIgnoreCase("true"))

{

TypeIspList til=null;

JSONObject jo=new JSONObject();

try

{

int id=Integer.parseInt(request.getParameter("id"));

tif.remove(tif.find(id));

jo.put("res",true);

}

catch(Exception e)

{

jo.put("res",false);

}

PrintWriter out = response.getWriter();

out.write(jo.toJSONString());

out.flush();

out.close();

}

if(request.getParameter("updtype")!=null&&request.getParameter("updtype").toString().equalsIgnoreCase("true"))

{

TypeIspList til=null;

JSONObject jo=new JSONObject();

try

{

String name=request.getParameter("name");

int id=Integer.parseInt(request.getParameter("id"));

System.out.println(id+ " id");

System.out.println(name+" name");

til=tif.find(id);

til.setName(name);

tif.edit(til);

jo.put("res",true);

}

catch(Exception e)

{

System.out.println("exception");

jo.put("res",false);

}

PrintWriter out = response.getWriter();

out.write(jo.toJSONString());

out.flush();

out.close();

}

if(request.getParameter("adduser")!=null&&request.getParameter("adduser").toString().equalsIgnoreCase("true"))

{

User us=null;

JSONObject jo=new JSONObject();

try

{

String pass=request.getParameter("pass");

uf.create(new User(pass));

int id=uf.findAll().get(uf.findAll().size()-1).getLogin();

jo.put("id",id);

jo.put("pass",uf.find(id).getPass());

}

catch(Exception e)

{

jo.put("res",false);

}

PrintWriter out = response.getWriter();

out.write(jo.toJSONString());

out.flush();

out.close();

}

if(request.getParameter("addtype")!=null&&request.getParameter("addtype").toString().equalsIgnoreCase("true"))

{

JSONObject jo=new JSONObject();

try

{

String name=request.getParameter("name");

tif.create(new TypeIspList(name));

int id=tif.findAll().get(tif.findAll().size()-1).getId();

jo.put("id",id);

jo.put("name",tif.find(id).getName());

}

catch(Exception e)

{

jo.put("res",false);

}

PrintWriter out = response.getWriter();

out.write(jo.toJSONString());

out.flush();

out.close();

}

if(request.getParameter("newpass")!=null&&request.getParameter("newpass").toString().equalsIgnoreCase("true"))

{

User us=null;

JSONObject jo=new JSONObject();

try

{

String pass=request.getParameter("pass");

int login=(int)se.getAttribute("id");

us=uf.find(login);

us.setPass(pass);

uf.edit(us);

jo.put("res",true);

}

catch(Exception e)

{

jo.put("res",false);

}

PrintWriter out = response.getWriter();

out.write(jo.toJSONString());

out.flush();

out.close();

}

if(request.getParameter("exit")!=null&&request.getParameter("exit").toString().equalsIgnoreCase("true"))

{

se=null;

response.sendRedirect("input");

}

}

}

catch(IllegalStateException e)

{

request.getRequestDispatcher("/mos_admin/input.jsp").forward(request, response);

se=null;

System.out.println("errorsession");

}

}

}

// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">

/**

* Handles the HTTP <code>GET</code> method.

*

* @param request servlet request

* @param response servlet response

* @throws ServletException if a servlet-specific error occurs

* @throws IOException if an I/O error occurs

*/

@Override

protected void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException

{

processRequest(request, response);

}

@Override

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException

{

processRequest(request, response);

}

/**

* Returns a short description of the servlet.

*

* @return a String containing servlet description

*/

@Override

public String getServletInfo()

{

return "Short description";

}// </editor-fold>

}

Файл AbstractFacade.java

package entitys;

import java.util.List;

import javax.persistence.EntityManager;

public abstract class AbstractFacade<T>

{

private Class<T> entityClass;

public AbstractFacade(Class<T> entityClass)

{

this.entityClass = entityClass;

}

protected abstract EntityManager getEntityManager();

public void create(T entity)

{

getEntityManager().persist(entity);

}

public void edit(T entity)

{

getEntityManager().merge(entity);

}

public void remove(T entity)

{

getEntityManager().remove(getEntityManager().merge(entity));

}

public T find(Object id)

{

return getEntityManager().find(entityClass, id);

}

public List<T> findAll()

{

javax.persistence.criteria.CriteriaQuery cq = getEntityManager().getCriteriaBuilder().createQuery();

cq.select(cq.from(entityClass));

return getEntityManager().createQuery(cq).getResultList();

}

public List<T> findRange(int[] range)

{

javax.persistence.criteria.CriteriaQuery cq = getEntityManager().getCriteriaBuilder().createQuery();

cq.select(cq.from(entityClass));

javax.persistence.Query q = getEntityManager().createQuery(cq);

q.setMaxResults(range[1] - range[0] + 1);

q.setFirstResult(range[0]);

return q.getResultList();

}

public int count()

{

javax.persistence.criteria.CriteriaQuery cq = getEntityManager().getCriteriaBuilder().createQuery();

javax.persistence.criteria.Root<T> rt = cq.from(entityClass);

cq.select(getEntityManager().getCriteriaBuilder().count(rt));

javax.persistence.Query q = getEntityManager().createQuery(cq);

return ((Long) q.getSingleResult()).intValue();

}

}

Файл DolgsFacade.java

package entitys;

import javax.ejb.Stateless;

import javax.persistence.EntityManager;

import javax.persistence.PersistenceContext;

import pojo.*;

@Stateless

public class DolgsFacade extends AbstractFacade<Dolgs>

{

@PersistenceContext(unitName = "StudentProjectPU")

private EntityManager em;

@Override

protected EntityManager getEntityManager()

{

return em;

}

public DolgsFacade()

{

super(Dolgs.class);

}

}

Файл ImusFacade.java

package entitys;

import javax.ejb.Stateless;

import javax.persistence.EntityManager;

import javax.persistence.PersistenceContext;

import pojo.*;

@Stateless

public class ImusFacade extends AbstractFacade<Imus>

{

@PersistenceContext(unitName = "StudentProjectPU")

private EntityManager em;

@Override

protected EntityManager getEntityManager()

{

return em;

}

public ImusFacade()

{

super(Imus.class);

}

}

Файл IspListsFacade.java

package entitys;

import javax.ejb.Stateless;

import javax.persistence.EntityManager;

import javax.persistence.PersistenceContext;

import pojo.*;

@Stateless

public class IspListsFacade extends AbstractFacade<IspLists>

{

@PersistenceContext(unitName = "StudentProjectPU")

private EntityManager em;

@Override

protected EntityManager getEntityManager()

{

return em;

}

public IspListsFacade()

{

super(IspLists.class);

}

}

Файл TypeIspListFacade.java

package entitys;

import javax.ejb.Stateless;

import javax.persistence.EntityManager;

import javax.persistence.PersistenceContext;

import pojo.*;

@Stateless

public class TypeIspListFacade extends AbstractFacade<TypeIspList>

{

@PersistenceContext(unitName = "StudentProjectPU")

private EntityManager em;

@Override

protected EntityManager getEntityManager()

{

return em;

}

public TypeIspListFacade()

{

super(TypeIspList.class);

}

}

Файл UserFacade.java

package entitys;

import javax.ejb.Stateless;

import javax.persistence.EntityManager;

import javax.persistence.PersistenceContext;

import pojo.*;

@Stateless

public class UserFacade extends AbstractFacade<User>

{

@PersistenceContext(unitName = "StudentProjectPU")

private EntityManager em;

@Override

protected EntityManager getEntityManager()

{

return em;

}

public void flush()

{

em.flush();

}

public UserFacade()

{

super(User.class);

}

}

Файл Dolgs.java

package pojo;

import java.io.Serializable;

import java.util.Collection;

import javax.persistence.Basic;

import javax.persistence.CascadeType;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.Lob;

import javax.persistence.NamedQueries;

import javax.persistence.NamedQuery;

import javax.persistence.OneToMany;

import javax.persistence.Table;

import javax.validation.constraints.Size;

import javax.xml.bind.annotation.XmlRootElement;

import javax.xml.bind.annotation.XmlTransient;

@Entity

@Table(name = "dolgs")

@XmlRootElement

@NamedQueries(

{

@NamedQuery(name = "Dolgs.findAll", query = "SELECT d FROM Dolgs d"),

@NamedQuery(name = "Dolgs.findById", query = "SELECT d FROM Dolgs d WHERE d.id = :id")

})

public class Dolgs implements Serializable

{

private static final long serialVersionUID = 1L;

@Id

@GeneratedValue(strategy = GenerationType.IDENTITY)

@Basic(optional = false)

@Column(name = "id")

private Integer id;

@Lob

@Size(max = 65535)

@Column(name = "name")

private String name;

@Lob

@Size(max = 65535)

@Column(name = "surname")

private String surname;

@Lob

@Size(max = 65535)

@Column(name = "lastname")

private String lastname;

@Lob

@Size(max = 65535)

@Column(name = "pasport")

private String pasport;

@OneToMany(cascade = CascadeType.ALL, mappedBy = "idDolg")

private Collection<Imus> imusCollection;

@OneToMany(cascade = CascadeType.ALL, mappedBy = "idDolg")

private Collection<IspLists> ispListsCollection;

public Dolgs()

{

}

public Dolgs(String surname, String name, String lastname, String pasport)

{

this.id=0;

this.surname=surname;

this.name=name;

this.pasport=pasport;

}

public Dolgs(Integer id)

{

this.id = id;

}

public Integer getId()

{

return id;

}

public void setId(Integer id)

{

this.id = id;

}

public String getName()

{

return name;

}

public void setName(String name)

{

this.name = name;

}

public String getSurname()

{

return surname;

}

public void setSurname(String surname)

{

this.surname = surname;

}

public String getLastname()

{

return lastname;

}

public void setLastname(String lastname)

{

this.lastname = lastname;

}

public String getPasport()

{

return pasport;

}

public void setPasport(String pasport)

{

this.pasport = pasport;

}

@XmlTransient

public Collection<Imus> getImusCollection()

{

return imusCollection;

}

public void setImusCollection(Collection<Imus> imusCollection)

{

this.imusCollection = imusCollection;

}

@XmlTransient

public Collection<IspLists> getIspListsCollection()

{

return ispListsCollection;

}

public void setIspListsCollection(Collection<IspLists> ispListsCollection)

{

this.ispListsCollection = ispListsCollection;

}

@Override

public int hashCode()

{

int hash = 0;

hash += (id != null ? id.hashCode() : 0);

return hash;

}

@Override

public boolean equals(Object object)

{

// TODO: Warning - this method won't work in the case the id fields are not set

if (!(object instanceof Dolgs))

{

return false;

}

Dolgs other = (Dolgs) object;

if ((this.id == null && other.id != null) || (this.id != null && !this.id.equals(other.id)))

{

return false;

}

return true;

}

@Override

public String toString()

{

return "pojo.Dolgs[ id=" + id + " ]";

}

}

Файл Imus.java

package pojo;

import java.io.Serializable;

import javax.persistence.Basic;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.JoinColumn;

import javax.persistence.Lob;

import javax.persistence.ManyToOne;

import javax.persistence.NamedQueries;

import javax.persistence.NamedQuery;

import javax.persistence.Table;

import javax.validation.constraints.Size;

import javax.xml.bind.annotation.XmlRootElement;

@Entity

@Table(name = "imus")

@XmlRootElement

@NamedQueries(

{

@NamedQuery(name = "Imus.findAll", query = "SELECT i FROM Imus i"),

@NamedQuery(name = "Imus.findById", query = "SELECT i FROM Imus i WHERE i.id = :id"),

@NamedQuery(name = "Imus.findByCost", query = "SELECT i FROM Imus i WHERE i.cost = :cost"),

@NamedQuery(name = "Imus.findByIsTorg", query = "SELECT i FROM Imus i WHERE i.isTorg = :isTorg")

})

public class Imus implements Serializable

{

private static final long serialVersionUID = 1L;

@Id

@GeneratedValue(strategy = GenerationType.IDENTITY)

@Basic(optional = false)

@Column(name = "id")

private Integer id;

@Lob

@Size(max = 65535)

@Column(name = "name")

private String name;

// @Max(value=?) @Min(value=?)//if you know range of your decimal fields consider using these annotations to enforce field validation

@Column(name = "cost")

private Double cost;

@Column(name = "is_torg")

private Boolean isTorg;

@JoinColumn(name = "id_dolg", referencedColumnName = "id")

@ManyToOne

private Dolgs idDolg;

public Imus()

{

}

public Imus(String name, double cost, Dolgs id)

{

this.id=0;

this.isTorg=false;

this.idDolg = id;

this.name = name;

this.cost = cost;

}

public Imus(Integer id)

{

this.id = id;

}

public Integer getId()

{

return id;

}

public void setId(Integer id)

{

this.id = id;

}

public String getName()

{

return name;

}

public void setName(String name)

{

this.name = name;

}

public Double getCost()

{

return cost;

}

public void setCost(Double cost)

{

this.cost = cost;

}

public Boolean getIsTorg()

{

return isTorg;

}

public void setIsTorg(Boolean isTorg)

{

this.isTorg = isTorg;

}

public Dolgs getIdDolg()

{

return idDolg;

}

public void setIdDolg(Dolgs idDolg)

{

this.idDolg = idDolg;

}

@Override

public int hashCode()

{

int hash = 0;

hash += (id != null ? id.hashCode() : 0);

return hash;

}

@Override

public boolean equals(Object object)

{

// TODO: Warning - this method won't work in the case the id fields are not set

if (!(object instanceof Imus))

{

return false;

}

Imus other = (Imus) object;

if ((this.id == null && other.id != null) || (this.id != null && !this.id.equals(other.id)))

{

return false;

}

return true;

}

@Override

public String toString()

{

return "pojo.Imus[ id=" + id + " ]";

}

}

Файл IspLists.java

package pojo;

import java.io.Serializable;

import javax.persistence.Basic;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.JoinColumn;

import javax.persistence.ManyToOne;

import javax.persistence.NamedQueries;

import javax.persistence.NamedQuery;

import javax.persistence.Table;

import javax.xml.bind.annotation.XmlRootElement;

@Entity

@Table(name = "isp_lists")

@XmlRootElement

@NamedQueries(

{

@NamedQuery(name = "IspLists.findAll", query = "SELECT i FROM IspLists i"),

@NamedQuery(name = "IspLists.findById", query = "SELECT i FROM IspLists i WHERE i.id = :id"),

@NamedQuery(name = "IspLists.findBySum", query = "SELECT i FROM IspLists i WHERE i.sum = :sum")

})

public class IspLists implements Serializable

{

private static final long serialVersionUID = 1L;

@Id

@GeneratedValue(strategy = GenerationType.IDENTITY)

@Basic(optional = false)

@Column(name = "id")

private Integer id;

@JoinColumn(name = "id_type", referencedColumnName = "id")

@ManyToOne

private TypeIspList idType;

@JoinColumn(name = "id_dolg", referencedColumnName = "id")

@ManyToOne

private Dolgs idDolg;

@Column(name = "sum")

private Double sum;

public Double getSum()

{

return sum;

}

public void setSum(Double sum)

{

this.sum = sum;

}

public IspLists()

{

}

public IspLists(TypeIspList idType,Dolgs idDolg, Double sum)

{

this.id = 0;

this.idDolg = idDolg;

this.idType = idType;

this.sum = sum;

}

public IspLists(Integer id)

{

this.id = id;

}

public Integer getId()

{

return id;

}

public void setId(Integer id)

{

this.id = id;

}

public TypeIspList getIdType()

{

return idType;

}

public void setIdType(TypeIspList idType)

{

this.idType = idType;

}

public Dolgs getIdDolg()

{

return idDolg;

}

public void setIdDolg(Dolgs idDolg)

{

this.idDolg = idDolg;

}

@Override

public int hashCode()

{

int hash = 0;

hash += (id != null ? id.hashCode() : 0);

return hash;

}

@Override

public boolean equals(Object object)

{

// TODO: Warning - this method won't work in the case the id fields are not set

if (!(object instanceof IspLists))

{

return false;

}

IspLists other = (IspLists) object;

if ((this.id == null && other.id != null) || (this.id != null && !this.id.equals(other.id)))

{

return false;

}

return true;

}

@Override

public String toString()

{

return "pojo.IspLists[ id=" + id + " ]";

}

}

Файл TypeIspList.java

package pojo;

import java.io.Serializable;

import java.util.Collection;

import javax.persistence.Basic;

import javax.persistence.CascadeType;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.Lob;

import javax.persistence.NamedQueries;

import javax.persistence.NamedQuery;

import javax.persistence.OneToMany;

import javax.persistence.Table;

import javax.validation.constraints.Size;

import javax.xml.bind.annotation.XmlRootElement;

import javax.xml.bind.annotation.XmlTransient;

@Entity

@Table(name = "type_isp_list")

@XmlRootElement

@NamedQueries(

{

@NamedQuery(name = "TypeIspList.findAll", query = "SELECT t FROM TypeIspList t"),

@NamedQuery(name = "TypeIspList.findById", query = "SELECT t FROM TypeIspList t WHERE t.id = :id")

})

public class TypeIspList implements Serializable

{

private static final long serialVersionUID = 1L;

@Id

@GeneratedValue(strategy = GenerationType.IDENTITY)

@Basic(optional = false)

@Column(name = "id")

private Integer id;

@Lob

@Size(max = 65535)

@Column(name = "name")

private String name;

@OneToMany(cascade = CascadeType.ALL,mappedBy = "idType")

private Collection<IspLists> ispListsCollection;

public TypeIspList()

{

}

public TypeIspList(Integer id)

{

this.id = id;

}

public TypeIspList(String name)

{

this.id = 0;

this.name=name;

}

public Integer getId()

{

return id;

}

public void setId(Integer id)

{

this.id = id;

}

public String getName()

{

return name;

}

public void setName(String name)

{

this.name = name;

}

@XmlTransient

public Collection<IspLists> getIspListsCollection()

{

return ispListsCollection;

}

public void setIspListsCollection(Collection<IspLists> ispListsCollection)

{

this.ispListsCollection = ispListsCollection;

}

@Override

public int hashCode()

{

int hash = 0;

hash += (id != null ? id.hashCode() : 0);

return hash;

}

@Override

public boolean equals(Object object)

{

// TODO: Warning - this method won't work in the case the id fields are not set

if (!(object instanceof TypeIspList))

{

return false;

}

TypeIspList other = (TypeIspList) object;

if ((this.id == null && other.id != null) || (this.id != null && !this.id.equals(other.id)))

{

return false;

}

return true;

}

@Override

public String toString()

{

return "pojo.TypeIspList[ id=" + id + " ]";

}

}

Файл User.java

package pojo;

import java.io.Serializable;

import javax.persistence.Basic;

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.Lob;

import javax.persistence.NamedQueries;

import javax.persistence.NamedQuery;

import javax.persistence.Table;

import javax.validation.constraints.Size;

import javax.xml.bind.annotation.XmlRootElement;

@Entity

@Table(name = "user")

@XmlRootElement

@NamedQueries(

{

@NamedQuery(name = "User.findAll", query = "SELECT u FROM User u"),

@NamedQuery(name = "User.findByLogin", query = "SELECT u FROM User u WHERE u.login = :login")

})

public class User implements Serializable

{

private static final long serialVersionUID = 1L;

@Id

@GeneratedValue(strategy = GenerationType.IDENTITY)

@Basic(optional = false)

@Column(name = "login")

private Integer login;

@Lob

@Size(max = 65535)

@Column(name = "pass")

private String pass;

public User()

{

}

public User(Integer login)

{

this.login = login;

}

public User(String pass)

{

this.login = 0;

this.pass=pass;

}

public Integer getLogin()

{

return login;

}

public void setLogin(Integer login)

{

this.login = login;

}

public String getPass()

{

return pass;

}

public void setPass(String pass)

{

this.pass = pass;

}

@Override

public int hashCode()

{

int hash = 0;

hash += (login != null ? login.hashCode() : 0);

return hash;

}

@Override

public boolean equals(Object object)

{

// TODO: Warning - this method won't work in the case the id fields are not set

if (!(object instanceof User))

{

return false;

}

User other = (User) object;

if ((this.login == null && other.login != null) || (this.login != null && !this.login.equals(other.login)))

{

return false;

}

return true;

}

@Override

public String toString()

{

return "pojo.User[ login=" + login + " ]";

}

}

Листинг скрипта генерации базы данных

/*

SQLyog Ultimate v9.50

MySQL - 5.5.23 : Database - Studentlaw

*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

CREATE DATABASE /*!32312 IF NOT EXISTS*/`Studentlaw` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin */;

USE `Studentlaw`;

/*Table structure for table `dolgs` */

DROP TABLE IF EXISTS `dolgs`;

CREATE TABLE `dolgs` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` text COLLATE utf8_bin,

`surname` text COLLATE utf8_bin,

`lastname` text COLLATE utf8_bin,

`pasport` text COLLATE utf8_bin,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `dolgs` */

insert into `dolgs`(`id`,`name`,`surname`,`lastname`,`pasport`) values (1,'Иван','Иванов','Иванович','вм 1234567'),(2,'Петр','Петров','Петрович','вм 5674564'),(4,'Василий','Хапанков','Игоревич','ВМ 1724567');

/*Table structure for table `imus` */

DROP TABLE IF EXISTS `imus`;

CREATE TABLE `imus` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` text COLLATE utf8_bin,

`cost` double DEFAULT NULL,

`id_dolg` int(11) DEFAULT NULL,

`is_torg` tinyint(1) DEFAULT NULL,

PRIMARY KEY (`id`),

KEY `id_dolg` (`id_dolg`),

CONSTRAINT `imus_ibfk_1` FOREIGN KEY (`id_dolg`) REFERENCES `dolgs` (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `imus` */

insert into `imus`(`id`,`name`,`cost`,`id_dolg`,`is_torg`) values (1,'Телевизор',256,1,1),(2,'Холодильник',255,1,1),(12,'фыцв',1234,2,1);

/*Table structure for table `isp_lists` */

DROP TABLE IF EXISTS `isp_lists`;

CREATE TABLE `isp_lists` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`id_type` int(11) DEFAULT NULL,

`id_dolg` int(11) DEFAULT NULL,

`sum` double DEFAULT NULL,

PRIMARY KEY (`id`),

KEY `id_dolg` (`id_dolg`),

KEY `id_type` (`id_type`),

CONSTRAINT `isp_lists_ibfk_1` FOREIGN KEY (`id_dolg`) REFERENCES `dolgs` (`id`),

CONSTRAINT `isp_lists_ibfk_2` FOREIGN KEY (`id_type`) REFERENCES `type_isp_list` (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `isp_lists` */

insert into `isp_lists`(`id`,`id_type`,`id_dolg`,`sum`) values (1,1,1,230),(2,2,2,220),(3,3,1,210),(6,3,1,220),(7,2,1,4444),(8,2,4,340),(9,2,4,340),(10,2,4,340);

/*Table structure for table `type_isp_list` */

DROP TABLE IF EXISTS `type_isp_list`;

CREATE TABLE `type_isp_list` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` text COLLATE utf8_bin,

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `type_isp_list` */

insert into `type_isp_list`(`id`,`name`) values (1,'Исполнительный акт'),(2,'Судебный приказ'),(3,'Натариально удостоверенное соглашение'),(4,'Удостоверение'),(5,'Акт');

/*Table structure for table `user` */

DROP TABLE IF EXISTS `user`;

CREATE TABLE `user` (

`login` int(11) NOT NULL AUTO_INCREMENT,

`pass` text COLLATE utf8_bin,

PRIMARY KEY (`login`)

) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*Data for the table `user` */

insert into `user`(`login`,`pass`) values (1,'22222'),(10,'345'),(11,'345'),(12,'345'),(13,'345'),(14,'345'),(15,'345'),(16,'345'),(17,'345'),(18,'345'),(19,'345'),(20,'123');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

...