java - 使用servlet和jsp在数据库中插入5行数据-6ren

java - 使用servlet和jsp在数据库中插入5行数据

转载作者：行者123 更新时间：2023-11-29 06:20:46

我想在mysql数据库中插入5行数据。我知道如何一次发送 1 行，但我不知道如何发送多行。

时间表.jsp

<%@page language="java" contentType="text/html charset=UTF-8" pageEncoding="UTF-8"%>
    <!DOCTYPE html>
    <html>  
    <head>  
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">  
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
    <script type="text/javascript">
    $(window).load(function(){
         function updateHours(row){ 
            var $date = row.find('[name="date"]');
            var $time1 = row.find('[name="logintime"]');
            var $time2 = row.find('[name="logouttime"]');
            var $time3 = row.find('[name="lunch"]');
            var $time4 = row.find('[name="afterlunchlogin"]');
            var $time5 = row.find('[name="afterlunchlogout"]');
            var $diff = row.find('.totalTime');
            var $over = row.find('.overTime');

                    if($time1.val() && $time2.val() && $time3.val() && $time4.val() && $time5.val())
            {   
                 var dateInput = $date.val();
                var dtStart = new Date(dateInput + " " + $time1.val());
                var dtEnd = new Date(dateInput + " " + $time2.val());
                var dtLunch= new Date(dateInput + " " + $time3.val());
                var dtStartafterlunch = new Date(dateInput + " " + $time4.val());
                var dtEndafterlunch = new Date(dateInput + " " + $time5.val());

                var diff = ((dtEnd - dtStart)+(dtEndafterlunch-dtStartafterlunch)) / 1000;

                var totalTime = 0;
                var overTime = 0;

                if (diff > 60*60*8) {

                    overTime = formatDate(diff - 60*60*8);
                } else {
                    totalTime = formatDate(diff);
                }
                totalTime = formatDate(diff);
                $diff.val(totalTime);
                $over.val(overTime);
            }
        }

        function formatDate(diff){
            var hours = parseInt( diff / 3600 ) % 24;
            var minutes = parseInt( diff / 60 ) % 60;
            var seconds = diff % 60;

            return (hours < 10 ? "0" + hours : hours) + ":" + (minutes < 10 ? "0" + minutes : minutes) + ":" + (seconds  < 10 ? "0" + seconds : seconds);
        }

        $(".start, .end, .lunch, .startafterlunch, .endafterlunch, .totalTime").on("change, keyup", function(){
            debugger
            updateHours($(this).closest('tr'));
        });

    });
         </script>

    <title>Timesheet Page</title>  
    </head>  
    <body>  
        <header>
            <h2>WEEKLY TIME SHEET MANAGEMENT V 1.0</h2>
        </header>

        <form action="TimeSheet" method="post">
            <fieldset style="width: 90%">  
                <legend>Timesheet</legend>   
                <h2>Time Sheet application</h2>
    <table border=1>
    <tr><th>Employee ID</th><th>Date</th><th>Time In</th><th>Time Out</th><th>Lunch</th><th>After Lunch Time in</th><th>After Lunch Time out</th><th>Task Description</th><th>Total Hours</th><th>Overtime</th> </tr>


        <tr> <td><input type="text" name="empid" required="required" /></td>   
    <td><input type="date" id="date" name="date"/></td>
    <td><input type="time" class="start" name="logintime"/></td>
    <td><input type="time" class="end"name="logouttime" /></td>
    <td><input type="time" class="lunch" name="lunch" /></td>
    <td><input type="time" class="startafterlunch" name="afterlunchlogin"/></td>
    <td><input type="time" class="endafterlunch" name="afterlunchlogout"/></td>
    <td><input type="textarea" name="task" required="required" /></td>
    <td><input class="totalTime" readonly="readonly" /></td>
    <td><input class="overTime" readonly="readonly" /></td></tr>
        <tr> <td><input type="text" name="empid" required="required" /></td>   
    <td><input type="date" id="date" name="date"/></td>
    <td><input type="time" class="start" name="logintime"/></td>
    <td><input type="time" class="end"name="logouttime" /></td>
    <td><input type="time" class="lunch" name="lunch" /></td>
    <td><input type="time" class="startafterlunch" name="afterlunchlogin"/></td>
    <td><input type="time" class="endafterlunch" name="afterlunchlogout"/></td>
    <td><input type="textarea" name="task" required="required" /></td>
    <td><input class="totalTime" readonly="readonly" /></td>
    <td><input class="overTime" readonly="readonly" /></td></tr>
        <tr> <td><input type="text" name="empid" required="required" /></td>   
    <td><input type="date" id="date" name="date"/></td>
    <td><input type="time" class="start" name="logintime"/></td>
    <td><input type="time" class="end"name="logouttime" /></td>
    <td><input type="time" class="lunch" name="lunch" /></td>
    <td><input type="time" class="startafterlunch" name="afterlunchlogin"/></td>
    <td><input type="time" class="endafterlunch" name="afterlunchlogout"/></td>
    <td><input type="textarea" name="task" required="required" /></td>
    <td><input class="totalTime" readonly="readonly" /></td>
    <td><input class="overTime" readonly="readonly" /></td></tr>
        <tr> <td><input type="text" name="empid" required="required" /></td>   
    <td><input type="date" id="date" name="date"/></td>
    <td><input type="time" class="start" name="logintime"/></td>
    <td><input type="time" class="end"name="logouttime" /></td>
    <td><input type="time" class="lunch" name="lunch" /></td>
    <td><input type="time" class="startafterlunch" name="afterlunchlogin"/></td>
    <td><input type="time" class="endafterlunch" name="afterlunchlogout"/></td>
    <td><input type="textarea" name="task" required="required" /></td>
    <td><input class="totalTime" readonly="readonly" /></td>
    <td><input class="overTime" readonly="readonly" /></td></tr>
        <tr> <td><input type="text" name="empid" required="required" /></td>   
    <td><input type="date" id="date" name="date"/></td>
    <td><input type="time" class="start" name="logintime"/></td>
    <td><input type="time" class="end"name="logouttime" /></td>
    <td><input type="time" class="lunch" name="lunch" /></td>
    <td><input type="time" class="startafterlunch" name="afterlunchlogin"/></td>
    <td><input type="time" class="endafterlunch" name="afterlunchlogout"/></td>
    <td><input type="textarea" name="task" required="required" /></td>
    <td><input class="totalTime" readonly="readonly" /></td>
    <td><input class="overTime" readonly="readonly" /></td></tr>
    </table>
            </fieldset>      
             <input type="submit" value="Submit">
        </form>
       <a href="logout.jsp">Logout</a>
    </body>  
    </html>

在 TimsheetDao.java 中

package com.eis.Dao;
import com.eis.bean.ConnectionProvider;
import com.eis.bean.EmployeeBean;
import java.sql.*;
import java.text.SimpleDateFormat;
import java.util.Calendar;

    public class TimeSheetDao {
  public static int insert(EmployeeBean eb,String sql) throws Exception {

    int i=0;  
    PreparedStatement ps=null;
    System.out.println("In TimesheetDao");
    Connection conn=ConnectionProvider.getConn();  
    try{ 


        System.out.println(" in try in Timesheetdao");

         ps = conn.prepareStatement(sql);

        ps.setString(1,eb.getEmpid());
       // ps.setDate(2, (java.sql.Date) eb.getLoginDate());
       // ps.setDate(3, (Date) eb.getLoginTime());  
       // ps.setDate(4, (Date) eb.getLogoutTime());  
        ps.setDate(2,new Date(eb.getLogindate().getTime()));
        ps.setString(3,eb.getLogintime());  
        ps.setString(4,eb.getLogouttime()); 
        ps.setString(5,eb.getLunch());
        ps.setString(6,eb.getAfterlunchlogin());  
        ps.setString(7,eb.getAfterlunchlogout()); 
        ps.setString(8,eb.getTask());
        ps.setString(9,eb.getTotal());
        ps.setString(10,eb.getOvertime());

        i=ps.executeUpdate();  
        /*rs = pst.executeQuery();  
                    status = rs.next(); */
        }
    catch(Exception e){
        System.out.println(e);
    }
    finally { 
        if (conn != null) {  
            try {  
                conn.close();  
            } catch (SQLException e) {  
                e.printStackTrace();  
            }  
        }
        if (ps != null) {  
            try {  
                ps.close();  
            } catch (SQLException e) {  
                e.printStackTrace();  
            }  
        }  

    }  
    return i;  

}
}

在TimeSheetServlet.java中

    package com.eis.servlet;

    import com.eis.Dao.TimeSheetDao;
    import com.eis.bean.EmployeeBean;
    import java.io.IOException;
    import java.io.PrintWriter;
    import java.text.ParseException;
    import java.text.SimpleDateFormat;
    import java.util.Date;
    import java.util.Locale;
    import java.util.logging.Level;
    import java.util.logging.Logger;
    import javax.servlet.RequestDispatcher;
    import javax.servlet.ServletException;
    import javax.servlet.http.HttpServlet;
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    import javax.servlet.http.HttpSession;

    public class TimeSheet extends HttpServlet {

        private static final long serialVersionUID = 1L;

        private TimeSheetDao dao;
        public TimeSheet() {
            super();
            dao = new TimeSheetDao();
        }

        protected void processRequest(HttpServletRequest request, HttpServletResponse response)
                throws ServletException, IOException, ParseException {
            response.setContentType("text/html;charset=UTF-8");
            PrintWriter out = response.getWriter();
            EmployeeBean eb = new EmployeeBean();
            String Emp_id=request.getParameter("empid");    
            eb.setEmpid(Emp_id);
            SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd", Locale.US);
            Date logindate = new java.sql.Date(formatter.parse(request.getParameter("logindate")).getTime());
            eb.setLogindate((java.sql.Date) logindate);
            String LoginTime=request.getParameter("logintime");
            eb.setLogintime(LoginTime);
            String LogoutTime=request.getParameter("logouttime");   eb.setLogouttime(LogoutTime);
            String Lunch=request.getParameter("lunch"); eb.setLunch(Lunch);
            String AfterLunchLogin=request.getParameter("afterlunchlogin"); eb.setAfterlunchlogin(AfterLunchLogin);
            String AfterLunchLogout=request.getParameter("afterlunchlogout"); eb.setAfterlunchlogout(AfterLunchLogout);
            String TaskDescription=request.getParameter("task"); eb.setTask(TaskDescription);
            String TotalHours=request.getParameter("total");  eb.setTotal(TotalHours);
            String OverTime=request.getParameter("overtime"); eb.setOvertime(OverTime);

            System.out.println(request.getParameter("empid"));
            HttpSession session = request.getSession(true);  
            try{if (Emp_id!=null){
                session.setAttribute("Emp_id",Emp_id);}
            }catch(Exception e){e.printStackTrace();}
            try{if (logindate!=null){
                session.setAttribute("LoginDate",logindate);}
            }catch(Exception e){e.printStackTrace();}
            try{if (LoginTime!=null){
                session.setAttribute("LoginTime",LoginTime);}
            }catch(Exception e){e.printStackTrace();}
            try{if (LogoutTime!=null){
                session.setAttribute("LogoutTime",LogoutTime);}
            }catch(Exception e){e.printStackTrace();}
            try{if (Lunch!=null){
                session.setAttribute("Lunch",Lunch);}
            }catch(Exception e){e.printStackTrace();}
            try{if (AfterLunchLogin!=null){
                session.setAttribute("AfterLunchLogin",AfterLunchLogin);}
            }catch(Exception e){e.printStackTrace();}
            try{if (AfterLunchLogout!=null){
                session.setAttribute("AfterLunchLogout",AfterLunchLogout);}
            }catch(Exception e){e.printStackTrace();}
            try{if (TaskDescription!=null){
                session.setAttribute("TaskDescription",TaskDescription);}
            }catch(Exception e){e.printStackTrace();}
            try{if (TotalHours!=null){
                session.setAttribute("TotalHours",TotalHours);}
            }catch(Exception e){e.printStackTrace();}
            try{if (OverTime!=null){
                session.setAttribute("OverTime",OverTime);}
            }catch(Exception e){e.printStackTrace();}


            TimeSheetDao dao = new TimeSheetDao();
            System.out.println("before sql");
              String sql= "insert into logintable values(?,?,?,?,?,?,?,?,?,?)";
              System.out.println("after sql");
           try {
               System.out.println("in try servlet after sql");
               int status = TimeSheetDao.insert(eb, sql);

               System.out.println("in try dao after sql");
            if(status!=0){
                out.print("<p style=\"color:Green\">Record saved successfully!!</p>");  
                RequestDispatcher rd=request.getRequestDispatcher("index.jsp");    
                rd.include(request,response);
            }
           else{    
                out.print("<p style=\"color:red\">**Record cannot be saved!**</p>");    
                RequestDispatcher rd=request.getRequestDispatcher("index.jsp");    
                rd.include(request,response);
            }

             }
           catch(Exception e){
               e.printStackTrace();
           }
        }

        // <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 {
            try {
                processRequest(request, response);
            } catch (ParseException ex) {
                Logger.getLogger(TimeSheet.class.getName()).log(Level.SEVERE, null, ex);
            }
        }

        /**
         * Handles the HTTP <code>POST</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 doPost(HttpServletRequest request, HttpServletResponse response)
                throws ServletException, IOException {
            try {
                processRequest(request, response);
            } catch (ParseException ex) {
                Logger.getLogger(TimeSheet.class.getName()).log(Level.SEVERE, null, ex);
            }
        }

        /**
         * Returns a short description of the servlet.
         *
         * @return a String containing servlet description
         */
        @Override
        public String getServletInfo() {
            return "Short description";
        }// </editor-fold>

    }

员工 bean :

package com.eis.bean;

    import java.util.Date;

    public class EmployeeBean {
        private String empid;
        private java.sql.Date logindate;
        private String logintime;
        private String logouttime;
        private String lunch;
        private String afterlunchlogin;
        private String afterlunchlogout;
        private String task;
        private String total;
        private String overtime;

        public String getEmpid() {
            return empid;
        }

        public void setEmpid(String empid) {
            this.empid = empid;
        }

        public java.sql.Date getLogindate() {
            return logindate;
        }

        public void setLogindate(java.sql.Date logindate) {
            this.logindate = logindate;
        }

        public String getLogintime() {
            return logintime;
        }

        public void setLogintime(String logintime) {
            this.logintime = logintime;
        }

        public String getLogouttime() {
            return logouttime;
        }

        public void setLogouttime(String logouttime) {
            this.logouttime = logouttime;
        }

        public String getLunch() {
            return lunch;
        }

        public void setLunch(String lunch) {
            this.lunch = lunch;
        }

        public String getAfterlunchlogin() {
            return afterlunchlogin;
        }

        public void setAfterlunchlogin(String afterlunchlogin) {
            this.afterlunchlogin = afterlunchlogin;
        }

        public String getAfterlunchlogout() {
            return afterlunchlogout;
        }

        public void setAfterlunchlogout(String afterlunchlogout) {
            this.afterlunchlogout = afterlunchlogout;
        }

        public String getTask() {
            return task;
        }

        public void setTask(String task) {
            this.task = task;
        }

        public String getTotal() {
            return total;
        }

        public void setTotal(String total) {
            this.total = total;
        }

        public String getOvertime() {
            return overtime;
        }

        public void setOvertime(String overtime) {
            this.overtime = overtime;
        }

        @Override
        public String toString() {
            return "EmployeeBean [empid=" + empid + ",logindate=" + logindate + ", logintime=" + logintime+ ", logouttime=" + logouttime + ", lunch=" + lunch+ ", afterlunchlogin=" + afterlunchlogin+ ", afterlunchlogout=" + afterlunchlogout+ ", task=" + task+ ", total=" + total+ ",overtime=" + overtime+ "]";
        }

    }

我不知道如何使 employeebean 成为列表类型...请检查 Timesheetservlet 和 timesheettao。

请帮我在数据库中插入 5 行。

谢谢!

最佳答案

我已将您的 jsp 更改为对不同的行使用不同的名称。并且还更改了 serverlet 代码以读取和构建员工 bean 列表。完成这些更改后，您可以使用上述 chrisI08 提到的逻辑。时间表.jsp.

<%@page language="java" contentType="text/html charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>  
<head>  
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">  

<title>Timesheet Page</title>  
</head>  
<body>  

<form action="TimeSheetServlet" method="post">
    <fieldset style="width: 90%">  
        <legend>Timesheet</legend>   
        <table> 
            <thead><tr><th>Employee ID</th><th>Date</th><th>Time In</th><th>Time Out</th><th>Lunch</th><th>After Lunch Time in</th><th>After Lunch Time out</th><th>Task Description</th><th>Total Hours</th><th>Overtime</th> </tr>
            </thead>
            <tbody>
                <tr>
                    <td><input type="text" name="empid1" required="required" /></td>   
                    <td><input type="date" id="date" name="logindate1" required="required" /></td>  
                    <td><input type="time" class="start" name="logintime1" required="required" /></td>  
                    <td><input type="time" class="end" name="logouttime1" required="required" /></td> 
                    <td><input type="time" class="lunch" name="lunch1" required="required" /></td>  
                    <td><input type="time" class="startafterlunch"  name="afterlunchlogin1" required="required" /></td>  
                    <td><input type="time" class="endafterlunch" name="afterlunchlogout1" required="required" /></td> 
                    <td><input type="textarea" name="1" required="required" /></td>
                    <td><input type="time" class="totalTime" name="total1" /></td>
                    <td><input type="time" class="overTime" name="overtime1" required="required" /></td>
                </tr>  
                <tr>
                    <td><input type="text" name="empid2" required="required" /></td>   
                    <td><input type="date" id="date" name="logindate2" required="required" /></td>  
                    <td><input type="time" class="start" name="logintime2" required="required" /></td>  
                    <td><input type="time" class="end" name="logouttime2" required="required" /></td> 
                    <td><input type="time" class="lunch" name="lunch2" required="required" /></td>  
                    <td><input type="time" class="startafterlunch"  name="afterlunchlogin2" required="required" /></td>  
                    <td><input type="time" class="endafterlunch" name="afterlunchlogout2" required="required" /></td> 
                    <td><input type="textarea" name="task2" required="required" /></td>
                    <td><input type="time" class="totalTime" name="total2" /></td>
                    <td><input type="time" class="overTime" name="overtime2" required="required" /></td>
                </tr>  
                <tr>
                    <td><input type="text" name="empid3" required="required" /></td>   
                    <td><input type="date" id="date" name="logindate3" required="required" /></td>  
                    <td><input type="time" class="start" name="logintime3" required="required" /></td>  
                    <td><input type="time" class="end" name="logouttime3" required="required" /></td> 
                    <td><input type="time" class="lunch" name="lunch3" required="required" /></td>  
                    <td><input type="time" class="startafterlunch"  name="afterlunchlogin3" required="required" /></td>  
                    <td><input type="time" class="endafterlunch" name="afterlunchlogout3" required="required" /></td> 
                    <td><input type="textarea" name="task" required="required" /></td>
                    <td><input type="time" class="totalTime" name="total3" /></td>
                    <td><input type="time" class="overTime" name="overtime3" required="required" /></td>
                </tr>  
                <tr>
                    <td><input type="text" name="empid4" required="required" /></td>   
                    <td><input type="date" id="date" name="logindate4" required="required" /></td>  
                    <td><input type="time" class="start" name="logintime4" required="required" /></td>  
                    <td><input type="time" class="end" name="logouttime4" required="required" /></td> 
                    <td><input type="time" class="lunch" name="lunch4" required="required" /></td>  
                    <td><input type="time" class="startafterlunch"  name="afterlunchlogin4" required="required" /></td>  
                    <td><input type="time" class="endafterlunch" name="afterlunchlogout4" required="required" /></td> 
                    <td><input type="textarea" name="task" required="required" /></td>
                    <td><input type="time" class="totalTime" name="total4" /></td>
                    <td><input type="time" class="overTime" name="overtime4" required="required" /></td>
                </tr>  
                <tr>
                    <td><input type="text" name="empid5" required="required" /></td>   
                    <td><input type="date" id="date" name="logindate5" required="required" /></td>  
                    <td><input type="time" class="start" name="logintime5" required="required" /></td>  
                    <td><input type="time" class="end" name="logouttime5" required="required" /></td> 
                    <td><input type="time" class="lunch" name="lunch5" required="required" /></td>  
                    <td><input type="time" class="startafterlunch"  name="afterlunchlogin5" required="required" /></td>  
                    <td><input type="time" class="endafterlunch" name="afterlunchlogout5" required="required" /></td> 
                    <td><input type="textarea" name="task5" required="required" /></td>
                    <td><input type="time" class="totalTime" name="total5" /></td>
                    <td><input type="time" class="overTime" name="overtime5" required="required" /></td>
                </tr>  
            </tbody>
        </table>  
    </fieldset>      
     <input type="submit" value="Submit">
</form>
<a href="logout.jsp">Logout</a>
</body>  
</html>

服务小程序:

List<EmployeeBean> ebList=  ArrayList<EmployeeBean>();
     SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd", Locale.US);
    for(int i=1;i<=5;i++){
        EmployeeBean eb = new EmployeeBean();
         eb.setEmpid(Emp_id);


         Date logindate = new java.sql.Date(formatter.parse(request.getParameter("logindate"+i)).getTime());
          eb.setLogindate((java.sql.Date) logindate);


      //String Date=request.getParameter("logindate");    
      String LoginTime=request.getParameter("logintime"+i);
      eb.setLogintime(LoginTime);
      eb.setLogouttime(request.getParameter("logouttime"+i));
       eb.setLunch(request.getParameter("lunch"+i));
       eb.setAfterlunchlogin(request.getParameter("afterlunchlogin"+i));
       eb.setAfterlunchlogout(request.getParameter("afterlunchlogout"+i));
       eb.setTask(request.getParameter("task"+i));
        eb.setTotal(request.getParameter("total"+i));
       eb.setOvertime(request.getParameter("overtime"+i));
    }
    TimeSheetDao.insert(ebList);

注意:我没有编译这段代码。您可能需要更改一些东西。

关于java - 使用servlet和jsp在数据库中插入5行数据，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/33411108/

文章推荐： mysql - 如何将多行变成具有不同列的单行

文章推荐： MySQL 5.6 : Select where value is in CSV colum

文章推荐： php - sql - 使用时间戳计算每周的记录

数据库
我的问题是如何在 python 中创建一个简单的数据库。我的例子是: User = { 'Name' : {'Firstname', 'Lastname'}, 'Address' : {'Street
mysql - iOS开发。数据库？数据库？什么是最好的方法？
我需要创建一个与远程数据库链接的应用程序! mysql 是最好的解决方案吗？ Sqlite 是唯一的本地解决方案吗？我使用下面的方法，我想知道它是否是最好的方法! NSString *evento
java 应用程序无法连接到远程 MySQL 数据库，但可以连接到本地 MySQL 数据库
给定两台 MySQL 服务器，一台本地，一台远程。两者都有一个包含表 bohica 的数据库 foobar。本地服务器定义了用户 'myadmin'@'%' 和 'myadmin'@'localhos
java - 灵活查询适用于 HANA 数据库，但不适用于 HSQL 数据库
我有以下灵活的搜索查询 Select {vt:code},{vt:productcode},{vw:code},{vw:productcode} from {abcd AS vt JOIN wxyz
mysql - 从原始数据文件恢复 MySQL 数据库 [XAMPP | MySQL |数据库]
好吧，我的电脑开始运行有点缓慢，所以我重置了 Windows，保留了我的文件。因为我的大脑还没有打开，所以我忘记事先备份我的 MySQL 数据库。我仍然拥有所有原始文件，因此我实际上仍然拥有数据库，但
android - 如何将我的 Access 数据库 (.accdb) 转换为 SQLite 数据库 (.sqlite)？
如何将我的 Access 数据库 (.accdb) 转换为 SQLite 数据库 (.sqlite)？请，任何帮助将不胜感激。最佳答案 1)如果要转换 db 的结构，则应使用任何 DB 建模工具:
django - 实际上我将我的 django 数据库 sqlite3 连接到 Mysql 数据库，每当我迁移时我都会收到此错误
系统检查发现了一些问题: 警告:？:(mysql.W002)未为数据库连接“默认”设置 MySQL 严格模式提示:MySQL 的严格模式通过将警告升级为错误来修复 MySQL 中的许多数据完整性问题
django - 实际上我将我的 django 数据库 sqlite3 连接到 Mysql 数据库，每当我迁移时我都会收到此错误
系统检查发现了一些问题: 警告:？:(mysql.W002)未为数据库连接“默认”设置 MySQL 严格模式提示:MySQL 的严格模式通过将警告升级为错误来修复 MySQL 中的许多数据完整性问题
android - 如何在 phonegap 数据库中使用 android 数据库/作为 phonegap 数据库
我想在相同的 phonegap 应用程序中使用 android 数据库。更多说明: 我创建了 phonegap 应用程序，但 phonegap 应用程序不支持服务，所以我们已经在 java 中为 a
javascript - 将日期插入 mysql 数据库 [我正在使用 php 和 xampp mysql 数据库]
Time Tracker function clock() { var mytime = new Date(); var seconds
php - MySQL如何从年份(参数)、weekOfYear(参数)、时间(数据库)和dayofweek(数据库)创建时间戳？
我需要在现有项目上实现一些事件的显示。我无法更改数据库结构。在我的 Controller 中，我(从 ajax 请求)传递了一个时间戳，并且我需要显示之前的 8 个事件。因此，如果时间戳是(转换后)
performance - : {REST API, 网站} --> {数据库} 或 {网站} --> {REST API} --> {数据库} 哪个更好？
我有一个可以收集和显示各种测量值的产品(不会详细介绍)。正如人们所期望的那样，显示部分是一个数据库+建立在其之上的网站(使用 Symfony)。但是，我们可能还会创建一个 API 来向第三方公开数据
sql-server - Azure SQL 数据库 - 查询速度明显慢于 Azure VM 上的 SQL 数据库
我们将 SQL Server 从 Azure VM 迁移到 Azure SQL 数据库。 Azure VM 为 DS2_V2、2 核、7GB RAM、最大 6400 IOPS Azure SQL 数据
java - MongoDB 如何在 Java 本地测试 MongoDB 数据库，比如 H2 和 sql 数据库？
我正在开发一个使用 MongoDB 数据库的程序，但我想问在通过 Java 执行 SQL 时是否可以使用内部数据库进行测试，例如 H2？最佳答案你可以尝试使用Testcontainers Test
sql - 如何从 unix 终端连接到 Microsoft SQL Server 数据库？我必须连接 SQL Server 2008 数据库
已关闭。此问题不符合Stack Overflow guidelines 。目前不接受答案。已关闭 9 年前。此问题似乎与 a specific programming problem, a sof
python - 尝试使用 MSI 身份验证从 Azure ML 服务连接 Azure SQL 数据库(无需用户名和密码即可连接 Azure 数据库)
我正在尝试使用 MSI 身份验证(无需用户名和密码)从 Azure 机器学习服务连接 Azure SQL 数据库。我正在尝试在 Azure 机器学习服务上建立机器学习模型，目的是我需要数据，这就是我
数据库；空场似乎不空
我在我的 MySQL 数据库中使用这个查询来查找 my_column 不为空的所有行: SELECT * FROM my_table WHERE my_column != ""; 不幸的是，许多行在
数据库 |选择不同的记录
我有那个基地:http://sqlfiddle.com/#!2/e5a24/2这是 WordPress 默认模式的简写。我已经删除了该示例不需要的字段。如您所见，我的结果是“类别 1”的两倍。我喜欢
数据库。提取过滤列的数据
我有一张这样的 table : mysql> select * from users; +--------+----------+------------+-----------+ | userid
数据库 |高级分面搜索
我有表: CREATE TABLE IF NOT EXISTS `category` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

java - 使用servlet和jsp在数据库中插入5行数据