当前位置: 首页>前端>正文

java 同步的订阅框架 java报刊订阅系统源代码

大家好,最近在网上又找到了一个学习项目,在此写一篇博文记录一下

本次项目名:Java高校教材征订系统的设计与实现

本次项目编号:054

一、项目展示图片

java 同步的订阅框架 java报刊订阅系统源代码,java 同步的订阅框架 java报刊订阅系统源代码_List,第1张

 

java 同步的订阅框架 java报刊订阅系统源代码,java 同步的订阅框架 java报刊订阅系统源代码_java 同步的订阅框架_02,第2张

 二、项目主要代码

package dao;

import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;
import java.util.Enumeration;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.Properties;

import javax.servlet.ServletContext;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import util.Info;


public class CommDAO
{
	public static String dbname = "";
	public static String dbtype = "";
	
	public static Connection conn = null;
	
	public CommDAO()
	{
		conn = this.getConn();
	}



         //给字段做加减法
	 public void jiajian(String tablename,String colname,String id,String num)
	 {
		 HashMap map = this.getmap(id, tablename);
		 String value = map.get(colname).toString();
		 if(value.equals(""))value="0";
		 int i = Integer.parseInt(value);
		 int j = Integer.parseInt(num);
		 commOper("update "+tablename+" set "+colname+" = "+(i+j)+" where id="+id);
	 }
	
	 //	该方法返回一个table 用于流动图片
	public String DynamicImage(String categoryid,int cut,int width,int height){

		StringBuffer imgStr = new StringBuffer();
		StringBuffer thePics1 = new StringBuffer();
		StringBuffer theLinks1 = new StringBuffer();
		StringBuffer theTexts1 = new StringBuffer();
	
		imgStr.append("<div id=picViwer1  style='background-color: #ffffff' align=center></div><SCRIPT src='js/dynamicImage.js' type=text/javascript></SCRIPT>\n<script language=JavaScript>\n");
		thePics1.append("var thePics1=\n'");
		theLinks1.append("var theLinks1='");
		theTexts1.append("var theTexts1='");
		
		List<HashMap> co = this.select("select * from xinwentongzhi where shouyetupian<>'' and shouyetupian<>'null'  and shouyetupian  like '%.jpg' order by id desc",1,6);
		int i = co.size();
		
		int j = 0; 
		for(HashMap b:co)
		{
			j++; 
		int id = Integer.parseInt(b.get("id").toString()) ;
		String title = Info.subStr(b.get("biaoti").toString(), 21) ;
		
		String url = ""+b.get("shouyetupian");
		
		String purl = "gg_detail.jsp?id="+b.get("id");
		
		if(j!=i){
		thePics1.append(url.replaceAll("\n", "")+"|");
		theLinks1.append(purl+"|");
		theTexts1.append(title+"|");
		}
		if(j==i)
		{
			thePics1.append(url.replaceAll("\n", ""));
			theLinks1.append("gg_detail.jsp?id="+b.get("id"));
			theTexts1.append(title);
		}
		
		}
	   thePics1.append("';");
		
		theLinks1.append("';");
		theTexts1.append("';");
		imgStr.append(thePics1+"\n");
		imgStr.append(theLinks1+"\n");
		imgStr.append(theTexts1+"\n");
		imgStr.append("\n setPic(thePics1,theLinks1,theTexts1,"+width+","+height+",'picViwer1');</script>");
		return imgStr.toString();
	}
	
	 


		public HashMap getmap(String id,String table)
		{
			List<HashMap> list = new ArrayList();
			try {
				Statement st = conn.createStatement();
				//System.out.println("select * from "+table+" where id="+id);
			    ResultSet rs = st.executeQuery("select * from "+table+" where id="+id);
			    ResultSetMetaData rsmd = rs.getMetaData();
	            while(rs.next())
			    {
			    	HashMap map = new HashMap();
			    	int i = rsmd.getColumnCount();
			    	for(int j=1;j<=i;j++)
			    	{
			    		if(!rsmd.getColumnName(j).equals("ID"))
			    		{
			    			String str = rs.getString(j)==null?"": rs.getString(j);
			    			if(str.equals("null"))str = "";
			    			map.put(rsmd.getColumnName(j), str);
			    		}
			    		else
			    			map.put("id", rs.getString(j));
			    	}
			    	list.add(map);
			    }
			    rs.close();
			    st.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			return list.get(0);
		}
		
		public HashMap getmaps(String nzd,String zdz,String table)
		{
			List<HashMap> list = new ArrayList();
			try {
				Statement st = conn.createStatement();
				//System.out.println("select * from "+table+" where "+nzd+"='"+zdz+"'");
			    ResultSet rs = st.executeQuery("select * from "+table+" where "+nzd+"='"+zdz+"'");
			    ResultSetMetaData rsmd = rs.getMetaData();
	            while(rs.next())
			    {
			    	HashMap map = new HashMap();
			    	int i = rsmd.getColumnCount();
			    	for(int j=1;j<=i;j++)
			    	{
			    		if(!rsmd.getColumnName(j).equals("ID"))
			    		{
			    			String str = rs.getString(j)==null?"": rs.getString(j);
			    			if(str.equals("null"))str = "";
			    			map.put(rsmd.getColumnName(j), str);
			    		}
			    		else
			    			map.put("id", rs.getString(j));
			    	}
			    	list.add(map);
			    }
			    rs.close();
			    st.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			return list.get(0);
		}
		
		
		 
		public String insert(HttpServletRequest request,HttpServletResponse response, String tablename,HashMap extmap,boolean alert,boolean reflush,String tzurl)
		{
			extmap.put("addtime", Info.getDateStr());
			if(request.getParameter("f")!=null){
			HashMap typemap = new HashMap();
			ArrayList<String> collist = new ArrayList();
			String sql = "insert into "+tablename+"(";
			
		 
			Connection conn = this.getConn();
			try {
				Statement st = conn.createStatement();
			    ResultSet rs = st.executeQuery("select * from "+tablename);
			    ResultSetMetaData rsmd = rs.getMetaData();
	            int i = rsmd.getColumnCount();
			    	 
			    	for(int j=1;j<=i;j++)
			    	{
			    	if(rsmd.getColumnName(j).equals("id"))continue;
					if(rsmd.getColumnName(j).equals("ID"))continue;
					if(rsmd.getColumnName(j).equals("iD"))continue;
					if(rsmd.getColumnName(j).equals("Id"))continue;
			    	typemap.put(rsmd.getColumnName(j)+"---", rsmd.getColumnTypeName(j));
			    	collist.add(rsmd.getColumnName(j));
	    	    	sql+=rsmd.getColumnName(j)+",";
			    	}
			    	sql = sql.substring(0,sql.length()-1);
			    
			    sql+=") values(";
			    rs.close();
			    st.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
			Enumeration enumeration = request.getParameterNames();
			String names = ",";
			while(enumeration.hasMoreElements())
			{
			names += enumeration.nextElement().toString()+",";
			}
			try {
				Statement st = conn.createStatement();
			    for(String str:collist)
			    {
			    	if(names.indexOf(","+str+",")>-1)
			    	{
			    		String[] values = request.getParameterValues(str);
			    		String value="";
			    		for(String vstr:values)
			    		{
			    			if(vstr==null)vstr="";
			    			if(vstr.equals("null"))vstr="";
			    			if(vstr.trim().equals(""))continue;
			    			
			    			if(request.getParameter(vstr)!=null&&!"".equals(request.getParameter(vstr))&&request.getParameter("dk-"+str+"-value")!=null)
			    			{
			    				String dkv = request.getParameter(vstr);
			    				String dknamevalue = request.getParameter("dk-"+str+"-value");
			    				vstr+=" - "+dknamevalue+":"+dkv;
			    			}
			    			
			    			value+=vstr+" ~ ";
			    			
			    			
			    			
			    		}
			    		if(value==null)value="";
		    			if(value.equals("null"))value="";
			    		if(value.length()>0)value=value.substring(0,value.length()-3);
			    		 
			    	    if(typemap.get(str+"---").equals("int"))
			    	    {
			    		sql+=(value.equals("")?-10:value)+",";
			    	    }else{
			    	    sql+="'"+(value.equals("null")?"":value)+"',";
			    	    }
			    	}else{
			    		if(typemap.get(str+"---").equals("int"))
			    	    {
			    		sql+=(extmap.get(str)==null?"":extmap.get(str))+",";
			    	    }else{
			    	    sql+="'"+(extmap.get(str)==null?"":extmap.get(str))+"',";
			    	    }
			    	}
			    }
			    
			    sql=sql.substring(0,sql.length()-1)+")";
			    System.out.println(sql);
			    this.commOper(sql);
			  
			    st.close();
			     
			} catch (SQLException e) {
				e.printStackTrace();
			}
			String str = "";
			if(!reflush)
			 str += "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\"> \n";
			 str +=	"<script language=javascript>\n";
			if(alert){
			str+="alert('操作成功');\n";
			}
			if(tzurl.equals(""))
			{
				if(reflush){
					str+="parent.location=parent.location;\n";
				}else{
					str+="window.location=String(window.location).replace(new RegExp('f=f', 'g'), '');";
				}
			}
			else
			{
				str+="location.href='"+tzurl+"';\n";
			}
			
			str+="</script>";
			
			
			PrintWriter wrt = null;
			try {
			wrt = response.getWriter();
			} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			}
			wrt.write(str);
			}
			
			return "";
		}
		
		public void delete(HttpServletRequest request,String tablename)
		{
			
			int i = 0;
			try {
				String did = request.getParameter("did");
				if(did==null)did = request.getParameter("scid");
				if(did!=null){
					if(did.length()>0){
				Statement st = conn.createStatement();
				System.out.println("delete from "+tablename+" where id="+did);
				 st.execute("delete from "+tablename+" where id="+did);
				 st.close();
					}
				}
				 
				   
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} 
		}

		
		
		public String getCols(String table)
		{  
			String str = "";
			Connection conn = this.getConn();
			try {
				Statement st = conn.createStatement();
			    ResultSet rs = st.executeQuery("select * from "+table);
			    ResultSetMetaData rsmd = rs.getMetaData();
			    
			    int i = rsmd.getColumnCount(); 
		    	for(int j=2;j<=i;j++)
		    	{
		    	str+=rsmd.getColumnName(j)+",";
		    	}
			    
			}catch (Exception e) {
				e.printStackTrace();
			}
			str = str.substring(0,str.length()-1);
			 
			return str;
		}
		
		
		public String update(HttpServletRequest request,HttpServletResponse response, String tablename,HashMap extmap,boolean alert,boolean reflush,String tzurl)
		{
			if(request.getParameter("f")!=null){
			Enumeration enumeration = request.getParameterNames();
			String names = ",";
			while(enumeration.hasMoreElements())
			{
			names += enumeration.nextElement().toString()+",";
			}
			HashMap typemap = new HashMap();
			ArrayList<String> collist = new ArrayList();
			String sql = "update "+tablename+" set ";
			Connection conn = this.getConn();
			try {
				Statement st = conn.createStatement();
			    ResultSet rs = st.executeQuery("select * from "+tablename);
			    ResultSetMetaData rsmd = rs.getMetaData();
	            int i = rsmd.getColumnCount();
			    	System.out.println(i);
			    	for(int j=1;j<=i;j++)
			    	{
			    	if(rsmd.getColumnName(j).equals("id"))continue;
					if(rsmd.getColumnName(j).equals("ID"))continue;
					if(rsmd.getColumnName(j).equals("Id"))continue;
					if(rsmd.getColumnName(j).equals("iD"))continue;
			    	typemap.put(rsmd.getColumnName(j)+"---", rsmd.getColumnTypeName(j));
			    	collist.add(rsmd.getColumnName(j));
	    	    	if(names.indexOf(","+rsmd.getColumnName(j)+",")>-1)
	    	    	{
	    	    		
	    	    		String[] values = request.getParameterValues(rsmd.getColumnName(j));
			    		String value="";
			    		for(String vstr:values)
			    		{
			    			if(vstr==null)vstr="";
			    			if(vstr.equals("null"))vstr="";
			    			if(vstr.trim().equals(""))continue;
			    			
			    			if(request.getParameter(vstr)!=null&&!"".equals(request.getParameter(vstr))&&request.getParameter("dk-"+rsmd.getColumnName(j)+"-value")!=null)
			    			{
			    				String dkv = request.getParameter(vstr);
			    				String dknamevalue = request.getParameter("dk-"+rsmd.getColumnName(j)+"-value");
			    				vstr+=" - "+dknamevalue+":"+dkv;
			    				System.out.println(vstr);
			    			}
			    			//if(vstr.length()<)
			    			value+=vstr+" ~ ";
			    		}
			    		if(value==null)value="";
		    			if(value.equals("null"))value="";
			    		if(value.length()>0)value=value.substring(0,value.length()-3);
	    	    		
	    	    		if(rsmd.getColumnTypeName(j).equals("int"))
	    	    		{
	    	    		 sql+=rsmd.getColumnName(j)+"="+value+",";
	    	    		}else{
	    	    			 sql+=rsmd.getColumnName(j)+"='"+value+"',";
	    	    		}
	    	    	}else{
	    	    		if(extmap.get(rsmd.getColumnName(j))!=null)
	    	    		{
	    	    			if(rsmd.getColumnTypeName(j).equals("int"))
	        	    		{
	        	    		 sql+=rsmd.getColumnName(j)+"="+extmap.get(rsmd.getColumnName(j))+",";
	        	    		}else{
	        	    			 sql+=rsmd.getColumnName(j)+"='"+extmap.get(rsmd.getColumnName(j))+"',";
	        	    		}
	    	    		}
	    	    	}
			    	}
			    	sql = sql.substring(0,sql.length()-1);
			    	sql+=" where id="+request.getParameter("id");
			       System.out.println(sql);
			    	Statement st1 = conn.createStatement();
			    	st1.execute(sql);
			    	st1.close();
			    rs.close();
			    st.close(); 
			     
			} catch (SQLException e) {
				e.printStackTrace();
			}
			String str = "";
			if(!reflush)
			 str += "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\n" ;
			 str +=	"<script language=javascript>\n";
			if(alert){
			str+="alert('操作成功');\n";
			}
			if(tzurl.equals(""))
			{
				if(reflush){
					str+="parent.location=parent.location;\n";
				}else{
					str+="window.location=String(window.location).replace(new RegExp('f=f', 'g'), '');";
				}
			}
			else
			{
				str+="location.href='"+tzurl+"';\n";
			}
			
			 
			str+="</script>\n";
			
			PrintWriter wrt = null;
			try {
				//request.get
			wrt = response.getWriter();
			} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			}
			wrt.write(str);
			}
	        return "";
		}
		
		
	
		public Connection getConn()
		{
		        try
		        { 
		        	if(conn==null||conn.isClosed()){
		        		
		        		Class.forName("com.mysql.jdbc.Driver");
			        	conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jspmgxjczdxthsg2856CCmysql","root","root");
						 
						 //Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			        	 //conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=jspmgxjczdxthsg2856CC","sa","sa123456");
			        	 
			        	// Class.forName("net.sourceforge.jtds.jdbc.Driver");
			        	// conn = DriverManager.getConnection("jdbc:jtds:sqlserver://127.0.0.1:1433;databaseName=jspmgxjczdxthsg2856CC","sa","sa123456");
		            }}
		        catch(Exception e)
		        {
		            e.printStackTrace();
		        }
		        return conn;
		}
	
	
	public int getInt(String sql)
	{
		int i = 0;
		try {
			Statement st = conn.createStatement();
			ResultSet rs = st.executeQuery(sql);
			if(rs.next())
			{
				i = rs.getInt(1);
			}
			    st.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return i;
	}
	
	
	public double getDouble(String sql)
	{
		double i = 0;
		try {
			Statement st = conn.createStatement();
			ResultSet rs = st.executeQuery(sql);
			if(rs.next())
			{
				i = rs.getDouble(1);
				
			}
			    st.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return i;
	}
	
	public void commOper(String sql)
	{
		System.out.println(sql);
		try {
			Statement st = conn.createStatement();
		    st.execute(sql);
		    st.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public void commOperSqls(ArrayList<String> sql)
	{
		
		try {
			conn.setAutoCommit(false);
			for(int i=0;i<sql.size();i++)
			{
			Statement st = conn.createStatement();
			System.out.println(sql.get(i));
		    st.execute(sql.get(i));
		    st.close();
			}
			conn.commit();
		} catch (SQLException e) {
			try {
				conn.rollback();
			} catch (SQLException e1) {
				e1.printStackTrace();
			}
			e.printStackTrace();
		}finally{
			try {
				conn.setAutoCommit(true);
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
	
	
	public List<HashMap> select(String sql)
	{ 
		System.out.println(sql);
		List<HashMap> list = new ArrayList();
		try {
			Statement st = conn.createStatement();
		    ResultSet rs = st.executeQuery(sql);
		    ResultSetMetaData rsmd = rs.getMetaData();
           
		    while(rs.next())
		    {
		    	HashMap map = new HashMap();
		    	int i = rsmd.getColumnCount();
		    	for(int j=1;j<=i;j++)
		    	{
		    		if(!rsmd.getColumnName(j).equals("ID"))
		    		{
		    			String str = rs.getString(j)==null?"": rs.getString(j);
		    			if(str.equals("null"))str = "";
		    			map.put(rsmd.getColumnName(j), str);
		    		}
		    		else
		    			map.put("id", rs.getString(j));
		    	}
		    	list.add(map);
		    }
		    rs.close();
		    st.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			
			if(sql.equals("show tables"))
			list = select("select table_name from   INFORMATION_SCHEMA.tables");
			else
				e.printStackTrace();
		}
		return list;
	}
	
	
	public List<List> selectforlist(String sql)
	{
		List<List> list = new ArrayList();
		try {
			Statement st = conn.createStatement();
		    ResultSet rs = st.executeQuery(sql);
		    ResultSetMetaData rsmd = rs.getMetaData();
           
		    while(rs.next())
		    {
		    	List<String> list2 = new ArrayList();
		    	int i = rsmd.getColumnCount();
		    	for(int j=1;j<=i;j++)
		    	{
		    		if(!rsmd.getColumnName(j).equals("ID"))
		    		{
		    			String str = rs.getString(j)==null?"": rs.getString(j);
		    			if(str.equals("null"))str = "";
		    			list2.add( str);
		    		}
		    		else
		    			list2.add(rs.getString(j));
		    	}
		    	list.add(list2);
		    }
		    rs.close();
		    st.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	
	
	public void close()
	{
		 
	}
	
	/**
	 * 执行一条查询sql,以 List<hashmap> 的形式返回查询的记录,记录条数,和从第几条开始,由参数决定,主要用于翻页
	 * pageno 页码  rowsize 每页的条数
	 */
	public List<HashMap> select(String sql, int pageno, int rowsize) {
		List<HashMap> list=new ArrayList<HashMap>();
		List<HashMap> mlist=new ArrayList<HashMap>();
		try{
			list=this.select(sql);
			int min = (pageno-1)*rowsize;
			int max = pageno*rowsize;
			
			for(int i=0;i<list.size();i++)
			{
				
				if(!(i<min||i>(max-1)))
				{
				mlist.add(list.get(i));
				}
			}
		}catch(RuntimeException re){
			re.printStackTrace();
			throw re;
		}
		
		
		return mlist;
	}
	

	
	
	public static void main(String[] args) { 
	}
}
package control;

import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.io.PrintWriter;
import java.io.UnsupportedEncodingException;
import java.net.URLEncoder;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;

import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.FileUpload;
import org.apache.commons.fileupload.RequestContext;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;
import org.apache.commons.fileupload.servlet.ServletRequestContext;


import util.Info;

import dao.CommDAO;

public class MainCtrl extends HttpServlet {

	public MainCtrl() {
		super();
	}

	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}
	
	public void doGet(HttpServletRequest request, HttpServletResponse response)
	throws ServletException, IOException {
	
	this.doPost(request, response);
	}

		public void go(String url,HttpServletRequest request, HttpServletResponse response)
		{
		try {
			request.getRequestDispatcher(url).forward(request, response);
		} catch (ServletException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		}
		}
		
		public void gor(String url,HttpServletRequest request, HttpServletResponse response)
		{
			try {
				response.sendRedirect(url);
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		
		}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
        response.setContentType("text/html");
		PrintWriter out = response.getWriter();
		String ac = request.getParameter("ac");
		if(ac==null)ac="";
		CommDAO dao = new CommDAO();
		String date = Info.getDateStr();
		String today = date.substring(0,10);
		String tomonth = date.substring(0,7);
		
		 
		if(ac.equals("login"))
		{
			String username = request.getParameter("username");
			String password = request.getParameter("pwd1");
			String utype = request.getParameter("cx");
			String pagerandom = request.getParameter("pagerandom")==null?"":request.getParameter("pagerandom");
			String random = (String)request.getSession().getAttribute("random");
			if(!pagerandom.equals(random)&&request.getParameter("a")!=null)
			{
				request.setAttribute("random", "");
				go("/index.jsp", request, response);
			}
			else{
				String sql1="";
				if (utype.equals("管理员")){sql1 = "select * from allusers where username='"+username+"' and pwd='"+password+"'"; }
				if(utype.equals("院系管理员")){sql1 = "select * from yuanxiguanliyuan where gonghao='"+username+"' and mima='"+password+"' ";}

				
				
			List<HashMap> userlist1 = dao.select(sql1);
			if(userlist1.size()==1)
			{
					request.getSession(). setAttribute("username", username);  
					if (utype.equals("管理员")){
						request.getSession(). setAttribute("cx",  userlist1.get(0).get("cx"));  
					}
					else
					{
						request.getSession(). setAttribute("cx", utype);  	
					}
				gor("index.jsp", request, response);
			}else{
				request.setAttribute("error", "");
				go("/index.jsp", request, response);
			}
			
			
			
			}
		}
		
		if(ac.equals("adminlogin"))
		{
			String username = request.getParameter("username");
			String password = request.getParameter("pwd");
			String utype = request.getParameter("cx");
			String pagerandom = request.getParameter("pagerandom")==null?"":request.getParameter("pagerandom");
			String random = (String)request.getSession().getAttribute("random");
			if(!pagerandom.equals(random)&&request.getParameter("a")!=null)
			{
				request.setAttribute("random", "");
				go("/login.jsp", request, response);
			}
			else{
				String sql1 = "";
				
				if (utype.equals("管理员")){sql1 = "select * from allusers where username='"+username+"' and pwd='"+password+"'"; }
				if(utype.equals("院系管理员")){sql1 = "select * from yuanxiguanliyuan where gonghao='"+username+"' and mima='"+password+"' ";}

			List<HashMap> userlist1 = dao.select(sql1);
			if(userlist1.size()==1)
			{
				request.getSession(). setAttribute("username", username);  
				if (utype.equals("管理员")){
					request.getSession(). setAttribute("cx",  userlist1.get(0).get("cx"));  
				}
				else
				{
					request.getSession(). setAttribute("cx", utype);  	
				}
				gor("main.jsp", request, response);
			}else{
				request.setAttribute("error", "");
				go("/login.jsp", request, response);
			}
			
			
			
			}
		}
		
		
		//修改密码
		if(ac.equals("uppass"))
		{
			String olduserpass = request.getParameter("ymm");
			String userpass = request.getParameter("xmm1");
			String copyuserpass = request.getParameter("xmm2");   
			HashMap m = dao.getmaps("yonghuming",(String)request.getSession().getAttribute("username"), "yonghuzhuce");
			if(!(((String)m.get("mima")).equals(olduserpass)))
			{
				request.setAttribute("error", "");
				go("mod2.jsp", request, response);
			}else{
			//String id = (String)user.get("id");
			String sql = "update yonghuzhuce set mima='"+userpass+"' where yonghuming='"+(String)request.getSession().getAttribute("username")+"'";
			dao.commOper(sql);
			request.setAttribute("suc", "");
			go("mod2.jsp", request, response);
			}
		}
		 
		 //修改密码
		if(ac.equals("adminuppass"))
		{
			String olduserpass = request.getParameter("ymm");
			String userpass = request.getParameter("xmm1");
			String copyuserpass = request.getParameter("xmm2");   
			//println(Info.getUser(request).get("id").toString());
			HashMap m = dao.getmaps("username",(String)request.getSession().getAttribute("username"), "allusers");
			
			if(!(((String)m.get("pwd")).equals(olduserpass)))
			{
				request.setAttribute("error", "");
				go("mod.jsp", request, response);
			}else{
			//String id = (String)user.get("id");
			String sql = "update allusers set pwd='"+userpass+"' where username='"+(String)request.getSession().getAttribute("username")+"'";
			dao.commOper(sql);
			request.setAttribute("suc", "");
			go("mod.jsp", request, response);
			}
		}
		 
		
		if(ac.equals("uploaddoc"))
		{
			try {
				String filename="";
			request.setCharacterEncoding("gb2312");
			RequestContext  requestContext = new ServletRequestContext(request);
			if(FileUpload.isMultipartContent(requestContext)){

			   DiskFileItemFactory factory = new DiskFileItemFactory();
			   factory.setRepository(new File(request.getRealPath("/upfile/")+"/"));
			   ServletFileUpload upload = new ServletFileUpload(factory);
			   upload.setSizeMax(100*1024*1024);
			   List items = new ArrayList();
			    
			     items = upload.parseRequest(request);
			     
			    FileItem fileItem = (FileItem) items.get(0);
			   if(fileItem.getName()!=null && fileItem.getSize()!=0)
			    {
			    if(fileItem.getName()!=null && fileItem.getSize()!=0){
			      File fullFile = new File(fileItem.getName());
			      filename = Info.generalFileName(fullFile.getName());
			      File newFile = new File(request.getRealPath("/upfile/")+"/" + filename);
			      try {
			       fileItem.write(newFile);
			      } catch (Exception e) {
			       e.printStackTrace();
			      }
			     }else{
			     }
			    }
			}
			
			go("/js/uploaddoc.jsp?docname="+filename, request, response);
			} catch (Exception e1) {
				e1.printStackTrace();
			    }
		}
		
		
		if(ac.equals("uploaddoc2"))
		{
			try {
				String filename="";
			request.setCharacterEncoding("gb2312");
			RequestContext  requestContext = new ServletRequestContext(request);
			if(FileUpload.isMultipartContent(requestContext)){

			   DiskFileItemFactory factory = new DiskFileItemFactory();
			   factory.setRepository(new File(request.getRealPath("/upfile/")+"/"));
			   ServletFileUpload upload = new ServletFileUpload(factory);
			   upload.setSizeMax(100*1024*1024);
			   List items = new ArrayList();
			    
			     items = upload.parseRequest(request);
			     
			    FileItem fileItem = (FileItem) items.get(0);
			   if(fileItem.getName()!=null && fileItem.getSize()!=0)
			    {
			    if(fileItem.getName()!=null && fileItem.getSize()!=0){
			      File fullFile = new File(fileItem.getName());
			      filename = Info.generalFileName(fullFile.getName());
			      File newFile = new File(request.getRealPath("/upfile/")+"/" + filename);
			      try {
			       fileItem.write(newFile);
			      } catch (Exception e) {
			       e.printStackTrace();
			      }
			     }else{
			     }
			    }
			}
			
			go("/js/uploaddoc2.jsp?docname="+filename, request, response);
			} catch (Exception e1) {
				e1.printStackTrace();
			    }
		}
		
		
		if(ac.equals("uploaddoc3"))
		{
			try {
				String filename="";
			request.setCharacterEncoding("gb2312");
			RequestContext  requestContext = new ServletRequestContext(request);
			if(FileUpload.isMultipartContent(requestContext)){

			   DiskFileItemFactory factory = new DiskFileItemFactory();
			   factory.setRepository(new File(request.getRealPath("/upfile/")+"/"));
			   ServletFileUpload upload = new ServletFileUpload(factory);
			   upload.setSizeMax(100*1024*1024);
			   List items = new ArrayList();
			    
			     items = upload.parseRequest(request);
			     
			    FileItem fileItem = (FileItem) items.get(0);
			   if(fileItem.getName()!=null && fileItem.getSize()!=0)
			    {
			    if(fileItem.getName()!=null && fileItem.getSize()!=0){
			      File fullFile = new File(fileItem.getName());
			      filename = Info.generalFileName(fullFile.getName());
			      File newFile = new File(request.getRealPath("/upfile/")+"/" + filename);
			      try {
			       fileItem.write(newFile);
			      } catch (Exception e) {
			       e.printStackTrace();
			      }
			     }else{
			     }
			    }
			}
			
			go("/js/uploaddoc3.jsp?docname="+filename, request, response);
			} catch (Exception e1) {
				e1.printStackTrace();
			    }
		}
		
		//导excel
		if(ac.equals("importexcel"))
		{
			String page = request.getParameter("page");
			String whzdstr = request.getParameter("whzdstr");
			String tablename = request.getParameter("tablename");
			try {
				String filename="";
			request.setCharacterEncoding("gb2312");
			RequestContext  requestContext = new ServletRequestContext(request);
			if(FileUpload.isMultipartContent(requestContext)){

			   DiskFileItemFactory factory = new DiskFileItemFactory();
			   factory.setRepository(new File(request.getRealPath("/upfile/")+"/"));
			   ServletFileUpload upload = new ServletFileUpload(factory);
			   upload.setSizeMax(100*1024*1024);
			   List items = new ArrayList();
			    
			     items = upload.parseRequest(request);
			     
			    FileItem fileItem = (FileItem) items.get(0);
			   if(fileItem.getName()!=null && fileItem.getSize()!=0)
			    {
			    if(fileItem.getName()!=null && fileItem.getSize()!=0){
			      File fullFile = new File(fileItem.getName());
			      filename = Info.generalFileName(fullFile.getName());
			      File newFile = new File(request.getRealPath("/upfile/")+"/" + filename);
			      try {
			       fileItem.write(newFile);
			      } catch (Exception e) {
			       e.printStackTrace();
			      }
			     }else{
			     }
			    }
			    
			   if(filename.indexOf(".xls")>-1)
				{
					Workbook workbook;
					try {
						workbook = Workbook.getWorkbook(new File(request.getRealPath("/upfile/")+"/"+filename));
		               //通过Workbook的getSheet方法选择第一个工作簿(从0开始)
						Sheet sheet = workbook.getSheet(0); 
		               //通过Sheet方法的getCell方法选择位置为C2的单元格(两个参数都从0开始)
						//int empty = 0;
						for(int i=1;i<1000;i++)
						{
							Cell cell = null;
							try{
								String isql = "insert into "+tablename+"(";
								
								for(String str:whzdstr.split("-"))
								{ 
									isql+=str+",";
								}
								isql = isql.substring(0,isql.length()-1);
								isql+=")values(";
								
								int j=0;
								int empty = 1;
								for(String str:whzdstr.split("-"))
								{
								cell = sheet.getCell(j,i); 
								isql+="'"+cell.getContents()+"',";
								String content = cell.getContents()==null?"":cell.getContents();
								if(!"".equals(content.trim()))
								{
									empty = 0;
								}
								j++;
								}
								if(empty==1)continue;
								isql = isql.substring(0,isql.length()-1);
								isql+=")";
								dao.commOper(isql);
							}catch (Exception e) {
							continue;
							}
						    
						 } 
						 workbook.close(); 
		            } catch (Exception e) {
						e.printStackTrace();
					} 
                  }
			}
			go("/admin/"+page+"?docname="+filename, request, response);
			} catch (Exception e1) {
				e1.printStackTrace();
			}
		}
	  

		if(ac.equals("uploadimg"))
		{
			try {
				String filename="";
			request.setCharacterEncoding("gb2312");
			RequestContext  requestContext = new ServletRequestContext(request);
			if(FileUpload.isMultipartContent(requestContext)){

			   DiskFileItemFactory factory = new DiskFileItemFactory();
			   factory.setRepository(new File(request.getRealPath("/upfile/")+"/"));
			   ServletFileUpload upload = new ServletFileUpload(factory);
			   upload.setSizeMax(100*1024*1024);
			   List items = new ArrayList();
			    
			     items = upload.parseRequest(request);
			     
			    FileItem fileItem = (FileItem) items.get(0);
			   if(fileItem.getName()!=null && fileItem.getSize()!=0)
			    {
			    if(fileItem.getName()!=null && fileItem.getSize()!=0){
			      File fullFile = new File(fileItem.getName());
			      filename = Info.generalFileName(fullFile.getName());
			      File newFile = new File(request.getRealPath("/upfile/")+"/" + filename);
			      try {
			       fileItem.write(newFile);
			      } catch (Exception e) {
			       e.printStackTrace();
			      }
			     }else{
			     }
			    }
			}
			
			go("/js/uploadimg.jsp?filename="+filename, request, response);
			} catch (Exception e1) {
				e1.printStackTrace();
			    }
		}
		
		
		if(ac.equals("uploadimg2"))
		{
			try {
				String filename="";
			request.setCharacterEncoding("gb2312");
			RequestContext  requestContext = new ServletRequestContext(request);
			if(FileUpload.isMultipartContent(requestContext)){

			   DiskFileItemFactory factory = new DiskFileItemFactory();
			   factory.setRepository(new File(request.getRealPath("/upfile/")+"/"));
			   ServletFileUpload upload = new ServletFileUpload(factory);
			   upload.setSizeMax(100*1024*1024);
			   List items = new ArrayList();
			    
			     items = upload.parseRequest(request);
			     
			    FileItem fileItem = (FileItem) items.get(0);
			   if(fileItem.getName()!=null && fileItem.getSize()!=0)
			    {
			    if(fileItem.getName()!=null && fileItem.getSize()!=0){
			      File fullFile = new File(fileItem.getName());
			      filename = Info.generalFileName(fullFile.getName());
			      File newFile = new File(request.getRealPath("/upfile/")+"/" + filename);
			      try {
			       fileItem.write(newFile);
			      } catch (Exception e) {
			       e.printStackTrace();
			      }
			     }else{
			     }
			    }
			}
			
			go("/js/uploadimg2.jsp?filename="+filename, request, response);
			} catch (Exception e1) {
				e1.printStackTrace();
			    }
		}
		
		if(ac.equals("uploadimg3"))
		{
			try {
				String filename="";
			request.setCharacterEncoding("gb2312");
			RequestContext  requestContext = new ServletRequestContext(request);
			if(FileUpload.isMultipartContent(requestContext)){

			   DiskFileItemFactory factory = new DiskFileItemFactory();
			   factory.setRepository(new File(request.getRealPath("/upfile/")+"/"));
			   ServletFileUpload upload = new ServletFileUpload(factory);
			   upload.setSizeMax(100*1024*1024);
			   List items = new ArrayList();
			    
			     items = upload.parseRequest(request);
			     
			    FileItem fileItem = (FileItem) items.get(0);
			   if(fileItem.getName()!=null && fileItem.getSize()!=0)
			    {
			    if(fileItem.getName()!=null && fileItem.getSize()!=0){
			      File fullFile = new File(fileItem.getName());
			      filename = Info.generalFileName(fullFile.getName());
			      File newFile = new File(request.getRealPath("/upfile/")+"/" + filename);
			      try {
			       fileItem.write(newFile);
			      } catch (Exception e) {
			       e.printStackTrace();
			      }
			     }else{
			     }
			    }
			}
			
			go("/js/uploadimg3.jsp?filename="+filename, request, response);
			} catch (Exception e1) {
				e1.printStackTrace();
			    }
		}
		
		if(ac.equals("uploadimg4"))
		{
			try {
				String filename="";
			request.setCharacterEncoding("gb2312");
			RequestContext  requestContext = new ServletRequestContext(request);
			if(FileUpload.isMultipartContent(requestContext)){

			   DiskFileItemFactory factory = new DiskFileItemFactory();
			   factory.setRepository(new File(request.getRealPath("/upfile/")+"/"));
			   ServletFileUpload upload = new ServletFileUpload(factory);
			   upload.setSizeMax(100*1024*1024);
			   List items = new ArrayList();
			    
			     items = upload.parseRequest(request);
			     
			    FileItem fileItem = (FileItem) items.get(0);
			   if(fileItem.getName()!=null && fileItem.getSize()!=0)
			    {
			    if(fileItem.getName()!=null && fileItem.getSize()!=0){
			      File fullFile = new File(fileItem.getName());
			      filename = Info.generalFileName(fullFile.getName());
			      File newFile = new File(request.getRealPath("/upfile/")+"/" + filename);
			      try {
			       fileItem.write(newFile);
			      } catch (Exception e) {
			       e.printStackTrace();
			      }
			     }else{
			     }
			    }
			}
			
			go("/js/uploadimg4.jsp?filename="+filename, request, response);
			} catch (Exception e1) {
				e1.printStackTrace();
			    }
		}
		
		if(ac.equals("uploadimg5"))
		{
			try {
				String filename="";
			request.setCharacterEncoding("gb2312");
			RequestContext  requestContext = new ServletRequestContext(request);
			if(FileUpload.isMultipartContent(requestContext)){

			   DiskFileItemFactory factory = new DiskFileItemFactory();
			   factory.setRepository(new File(request.getRealPath("/upfile/")+"/"));
			   ServletFileUpload upload = new ServletFileUpload(factory);
			   upload.setSizeMax(100*1024*1024);
			   List items = new ArrayList();
			    
			     items = upload.parseRequest(request);
			     
			    FileItem fileItem = (FileItem) items.get(0);
			   if(fileItem.getName()!=null && fileItem.getSize()!=0)
			    {
			    if(fileItem.getName()!=null && fileItem.getSize()!=0){
			      File fullFile = new File(fileItem.getName());
			      filename = Info.generalFileName(fullFile.getName());
			      File newFile = new File(request.getRealPath("/upfile/")+"/" + filename);
			      try {
			       fileItem.write(newFile);
			      } catch (Exception e) {
			       e.printStackTrace();
			      }
			     }else{
			     }
			    }
			}
			
			go("/js/uploadimg5.jsp?filename="+filename, request, response);
			} catch (Exception e1) {
				e1.printStackTrace();
			    }
		}
		
		
		dao.close();
		out.flush();
		out.close();
	}


	public void init() throws ServletException {
		// Put your code here
	}
	
	

}

三、项目数据库代码

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50160
Source Host           : localhost:3306
Source Database       : jspmgxjczdxthsg2856ccmysql

Target Server Type    : MYSQL
Target Server Version : 50160
File Encoding         : 65001

Date: 2022-03-18 20:51:13
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `allusers`
-- ----------------------------
DROP TABLE IF EXISTS `allusers`;
CREATE TABLE `allusers` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `pwd` varchar(50) DEFAULT NULL,
  `cx` varchar(50) DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of allusers
-- ----------------------------
INSERT INTO `allusers` VALUES ('1', 'hsg', 'hsg', '瓒呯骇绠$悊鍛�', '2022-03-01 01:53:27');

-- ----------------------------
-- Table structure for `kucunxinxi`
-- ----------------------------
DROP TABLE IF EXISTS `kucunxinxi`;
CREATE TABLE `kucunxinxi` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `shujibianhao` varchar(50) DEFAULT NULL,
  `shujimingcheng` varchar(50) DEFAULT NULL,
  `chubanriqi` varchar(50) DEFAULT NULL,
  `shujijiage` varchar(50) DEFAULT NULL,
  `shujizuozhe` varchar(50) DEFAULT NULL,
  `chubanshemingcheng` varchar(50) DEFAULT NULL,
  `chubanshedizhi` varchar(50) DEFAULT NULL,
  `shujikucun` varchar(50) DEFAULT NULL,
  `rukushuliang` varchar(50) DEFAULT NULL,
  `zongjine` varchar(50) DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of kucunxinxi
-- ----------------------------
INSERT INTO `kucunxinxi` VALUES ('1', '312895589104', '灏戞湁浜鸿蛋鐨勮矾', '2022-1-31', '69', '绉戞瘮', '娓╁窞鏂板崕鍑虹増绀�', '娉板叴璺�22鍙�', '67', '59', '4071', '2022-03-01 02:11:19');
INSERT INTO `kucunxinxi` VALUES ('2', '312855599535', '绠�鐖�', '2022-3-8', '69', '鐜嬫煆寮�', '鏃呮父鍑虹増绀�', '閼拰閿﹀洯2鏍�', '67', '82', '5658', '2022-03-01 02:11:19');
INSERT INTO `kucunxinxi` VALUES ('3', '312806508056', '绠�鐖�', '2022-3-20', '54', '闄堣吹鏌�', '榛庢槑鍑虹増绀�', '寤哄叴璺�138鍙�', '67', '97', '5238', '2022-03-01 02:11:19');
INSERT INTO `kucunxinxi` VALUES ('4', '312834669782', '瀹夊鍗″垪鐞冲', '2022-1-31', '83', '椹簡鐐�', '鍗椾含鏅开鍑虹増绀�', '榫欑繑璺�11鍙�', '99', '76', '6308', '2022-03-01 02:11:19');
INSERT INTO `kucunxinxi` VALUES ('5', '312895589104', '灏戞湁浜鸿蛋鐨勮矾', '2022-1-31', '69', '绉戞瘮', '娓╁窞鏂板崕鍑虹増绀�', '娉板叴璺�22鍙�', '67', '97', '6693', '2022-03-01 02:11:19');
INSERT INTO `kucunxinxi` VALUES ('6', '312843292730', '瀹夊緬鐢熺璇�', '2022-3-2', '56', '閮戜簹鏂�', '鍖椾含鏂拌春鍑虹増绀�', '鏂瑰煄涓藉渾11骞�201瀹�', '60', '59', '3304', '2022-03-01 02:11:19');
INSERT INTO `kucunxinxi` VALUES ('7', '312815131913', '涓夊浗婕斾箟', '2022-3-17', '88', '璧靛Э鍚�', '娴欐睙娉曟鍑虹増绀�', '涓滃煄璺�99鍙�', '2', '43', '3784', '2022-03-01 02:11:19');
INSERT INTO `kucunxinxi` VALUES ('8', '312815131913', '涓夊浗婕斾箟', '2022-3-17', '88', '璧靛Э鍚�', '娴欐睙娉曟鍑虹増绀�', '涓滃煄璺�99鍙�', '2', '50', '4400', '2022-03-01 02:11:19');
INSERT INTO `kucunxinxi` VALUES ('9', '312815131913', '涓夊浗婕斾箟', '2022-3-17', '88', '璧靛Э鍚�', '娴欐睙娉曟鍑虹増绀�', '涓滃煄璺�99鍙�', '2', '300', '26400.0', '2022-03-01 02:15:31');
INSERT INTO `kucunxinxi` VALUES ('10', '312815131913', '涓夊浗婕斾箟', '2022-3-17', '88', '璧靛Э鍚�', '娴欐睙娉曟鍑虹増绀�', '涓滃煄璺�99鍙�', '500', '99999999999', '8.800000016384E12', '2022-03-01 02:25:23');
INSERT INTO `kucunxinxi` VALUES ('11', '312815131913', '涓夊浗婕斾箟', '2022-3-17', '88', '璧靛Э鍚�', '娴欐睙娉曟鍑虹増绀�', '涓滃煄璺�99鍙�', '100000000499', '300', '26400.0', '2022-03-01 02:25:32');

-- ----------------------------
-- Table structure for `shujidinggou`
-- ----------------------------
DROP TABLE IF EXISTS `shujidinggou`;
CREATE TABLE `shujidinggou` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `shujibianhao` varchar(50) DEFAULT NULL,
  `shujimingcheng` varchar(50) DEFAULT NULL,
  `chubanriqi` varchar(50) DEFAULT NULL,
  `shujijiage` varchar(50) DEFAULT NULL,
  `shujizuozhe` varchar(50) DEFAULT NULL,
  `chubenshemingcheng` varchar(50) DEFAULT NULL,
  `shujikucun` varchar(50) DEFAULT NULL,
  `shenqingshuliang` varchar(50) DEFAULT NULL,
  `zongjine` varchar(50) DEFAULT NULL,
  `shenqingren` varchar(50) DEFAULT NULL,
  `issh` varchar(2) DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of shujidinggou
-- ----------------------------
INSERT INTO `shujidinggou` VALUES ('1', '312815131913', '涓夊浗婕斾箟', '2022-3-17', '88', '璧靛Э鍚�', '', '23', '1', '88.0', '001', '鏄�', '2022-03-01 02:16:51');
INSERT INTO `shujidinggou` VALUES ('2', '312815131913', '涓夊浗婕斾箟', '2022-3-17', '88', '璧靛Э鍚�', '', '22', '10', '880.0', '001', '鏄�', '2022-03-01 02:17:57');
INSERT INTO `shujidinggou` VALUES ('3', '312815131913', '涓夊浗婕斾箟', '2022-3-17', '88', '璧靛Э鍚�', '', '12', '10', '880.0', '001', '鏄�', '2022-03-01 02:24:45');

-- ----------------------------
-- Table structure for `shujifafang`
-- ----------------------------
DROP TABLE IF EXISTS `shujifafang`;
CREATE TABLE `shujifafang` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `shujibianhao` varchar(50) DEFAULT NULL,
  `shujimingcheng` varchar(50) DEFAULT NULL,
  `shujijiage` varchar(50) DEFAULT NULL,
  `shujizuozhe` varchar(50) DEFAULT NULL,
  `chubanshemingcheng` varchar(50) DEFAULT NULL,
  `shujikucun` varchar(50) DEFAULT NULL,
  `shenqingshuliang` varchar(50) DEFAULT NULL,
  `zongjine` varchar(50) DEFAULT NULL,
  `shenqingren` varchar(50) DEFAULT NULL,
  `fafangshijian` varchar(50) DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of shujifafang
-- ----------------------------
INSERT INTO `shujifafang` VALUES ('1', '312815131913', '涓夊浗婕斾箟', '88', '璧靛Э鍚�', '', '23', '1', '88.0', '001', '2022-03-01', '2022-03-01 02:17:12');
INSERT INTO `shujifafang` VALUES ('2', '312815131913', '涓夊浗婕斾箟', '88', '璧靛Э鍚�', '', '12', '10', '880.0', '001', '2022-03-01', '2022-03-01 02:25:42');

-- ----------------------------
-- Table structure for `shujixinxi`
-- ----------------------------
DROP TABLE IF EXISTS `shujixinxi`;
CREATE TABLE `shujixinxi` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `shujibianhao` varchar(50) DEFAULT NULL,
  `shujimingcheng` varchar(50) DEFAULT NULL,
  `chubanriqi` varchar(50) DEFAULT NULL,
  `shujijiage` varchar(50) DEFAULT NULL,
  `shujizuozhe` varchar(50) DEFAULT NULL,
  `chubanshemingcheng` varchar(50) DEFAULT NULL,
  `chubanshedizhi` varchar(255) DEFAULT NULL,
  `shujikucun` varchar(50) DEFAULT NULL,
  `shujitupian` varchar(50) DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of shujixinxi
-- ----------------------------
INSERT INTO `shujixinxi` VALUES ('1', '312834669782', '瀹夊鍗″垪鐞冲', '2022-1-31', '83', '椹簡鐐�', '鍗椾含鏅开鍑虹増绀�', '榫欑繑璺�11鍙�', '99', 'upload/nopic6.jpg', '2022-03-01 02:09:37');
INSERT INTO `shujixinxi` VALUES ('2', '312855599535', '绠�鐖�', '2022-3-8', '69', '鐜嬫煆寮�', '鏃呮父鍑虹増绀�', '閼拰閿﹀洯2鏍�', '67', 'upload/nopic2.jpg', '2022-03-01 02:09:37');
INSERT INTO `shujixinxi` VALUES ('3', '312893202161', '閲戠摱姊�', '2022-3-20', '88', '鍐瓙鏉�', '涓浗鏃ユ姤鍑虹増绀�', '涓婃睙灏忓尯2骞�', '67', 'upload/nopic8.jpg', '2022-03-01 02:09:37');
INSERT INTO `shujixinxi` VALUES ('4', '312854222592', '鑺遍鏂囬泦', '2022-1-31', '83', '楣挎櫁', '涓婃捣鏅氭姤鍑虹増绀�', '娌虫花涓滆矾139鍙�', '23', 'upload/nopic1.jpg', '2022-03-01 02:09:37');
INSERT INTO `shujixinxi` VALUES ('5', '312843292730', '瀹夊緬鐢熺璇�', '2022-3-2', '56', '閮戜簹鏂�', '鍖椾含鏂拌春鍑虹増绀�', '鏂瑰煄涓藉渾11骞�201瀹�', '60', 'upload/nopic7.jpg', '2022-03-01 02:09:37');
INSERT INTO `shujixinxi` VALUES ('6', '312806508056', '绠�鐖�', '2022-3-20', '54', '闄堣吹鏌�', '榛庢槑鍑虹増绀�', '寤哄叴璺�138鍙�', '67', 'upload/nopic4.jpg', '2022-03-01 02:09:37');
INSERT INTO `shujixinxi` VALUES ('7', '312895589104', '灏戞湁浜鸿蛋鐨勮矾', '2022-1-31', '69', '绉戞瘮', '娓╁窞鏂板崕鍑虹増绀�', '娉板叴璺�22鍙�', '67', 'upload/nopic3.jpg', '2022-03-01 02:09:37');
INSERT INTO `shujixinxi` VALUES ('8', '312815131913', '涓夊浗婕斾箟', '2022-3-17', '88', '璧靛Э鍚�', '娴欐睙娉曟鍑虹増绀�', '涓滃煄璺�99鍙�', '100000000499', 'upload/nopic5.jpg', '2022-03-01 02:09:37');

-- ----------------------------
-- Table structure for `yuanxiguanliyuan`
-- ----------------------------
DROP TABLE IF EXISTS `yuanxiguanliyuan`;
CREATE TABLE `yuanxiguanliyuan` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `gonghao` varchar(50) DEFAULT NULL,
  `mima` varchar(50) DEFAULT NULL,
  `xingming` varchar(50) DEFAULT NULL,
  `xingbie` varchar(50) DEFAULT NULL,
  `shenfenzheng` varchar(50) DEFAULT NULL,
  `shouji` varchar(50) DEFAULT NULL,
  `zhaopian` varchar(50) DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of yuanxiguanliyuan
-- ----------------------------
INSERT INTO `yuanxiguanliyuan` VALUES ('1', '016', '001', '鐜嬩笌棣�', '鐢�', '330327198811020456', '13025896548', 'upload/yuanxiguanliyuan3.jpg', '2022-03-01 01:56:33');
INSERT INTO `yuanxiguanliyuan` VALUES ('2', '018', '001', '榛勮闃�', '濂�', '330327198708070789', '17505772420', 'upload/yuanxiguanliyuan4.jpg', '2022-03-01 01:56:33');
INSERT INTO `yuanxiguanliyuan` VALUES ('3', '023', '001', '閮椤�', '濂�', '330327199005060003', '13748589658', 'upload/yuanxiguanliyuan1.jpg', '2022-03-01 01:56:33');
INSERT INTO `yuanxiguanliyuan` VALUES ('4', '005', '001', '娓╁畻杈�', '濂�', '330327198805060222', '13623256544', 'upload/yuanxiguanliyuan8.jpg', '2022-03-01 01:56:33');
INSERT INTO `yuanxiguanliyuan` VALUES ('5', '007', '001', '浼嶅厗鏂�', '鐢�', '330327198406150488', '13910215489', 'upload/yuanxiguanliyuan6.jpg', '2022-03-01 01:56:33');
INSERT INTO `yuanxiguanliyuan` VALUES ('6', '012', '001', '鏉ㄩ', '鐢�', '330327198615482633', '13186835580', 'upload/yuanxiguanliyuan2.jpg', '2022-03-01 01:56:33');
INSERT INTO `yuanxiguanliyuan` VALUES ('7', '009', '001', '浣欏皯搴�', '濂�', '33032719900723568X', '13184865998', 'upload/yuanxiguanliyuan5.jpg', '2022-03-01 01:56:33');
INSERT INTO `yuanxiguanliyuan` VALUES ('8', '001', '001', '濮氭槑', '濂�', '330327199010142546', '13769548711', 'upload/yuanxiguanliyuan7.jpg', '2022-03-01 01:56:33');

https://www.xamrdz.com/web/2kd1937795.html

相关文章: