jsp 连接javadb及插入数据如何实现？

Question

给个代码，谢谢！

Answer 1

不是JDBC，就市JAVA DB  数据库
问题已经解决了，分享一下：数据的插入：
                    Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();
                    Connection conn = null;
                    Properties props = new Properties();
                    props.put("user", "sa");
                    props.put("password", "123");
                    conn = DriverManager.getConnection("jdbc:derby://localhost:1527/test;", props);
                    conn.setAutoCommit(false);
                    Statement s = conn.createStatement();
                    String insertstr, ssnstr, namestr, addressstr, emailstr, agestr, sexstr, salarystr, loanstr;
                    ssnstr = "";
                    int nn  ;                           FileInputStream fssn = new FileInputStream(ff);
                    while ((nn = fssn.read()) != -1) {
                        ssnstr = ssnstr + (char) nn;
                    }
                    fssn.close();
                    namestr = request.getParameter("name");
                    addressstr = request.getParameter("address");
                    emailstr = request.getParameter("email");
                    agestr = request.getParameter("age");
                    sexstr = request.getParameter("gender");
                    salarystr = request.getParameter("salary");
                    loanstr = request.getParameter("loanamount");
                    insertstr = "insert into loaner values(" + ssntemp + ",'" + namestr + "','" + addressstr + "','" + emailstr + "','" + agestr + "','" + sexstr + "','" + salarystr + "','" + loanstr + "','待定')";
                    s.execute(insertstr);
                    s.close();
                    conn.commit();
                    conn.close();
                    out.println("你的SSN为：" + ssntemp);数据的查询：                        <%
            Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();
            Connection conn = null;
            Properties props = new Properties();
            props.put("user", "sa");
            props.put("password", "123");
            conn = DriverManager.getConnection("jdbc:derby://localhost:1527/test;", props);
            conn.setAutoCommit(false);
            Statement s = conn.createStatement();
            String ssntemp, sqlstr;
            ssntemp = request.getParameter("ssnstr");
            int ssni;
            ssni=Integer.parseInt(ssntemp);            sqlstr = "select status from loaner where ssn=3";
            
            ResultSet rs = s.executeQuery(sqlstr);
            String statusstr="";
            while (rs.next()) {
                StringBuilder builder = new StringBuilder(rs.getString(1));
                statusstr=builder.toString();
            }            out.println("你的申请状态:"+statusstr);
            rs.close();
            s.close();
            conn.commit();
            conn.close(); 
        %>

Answer 2

Landlord should be commended.Your spirts is worth our learning.Thank you for your help.May the joy and happiness around you today and always.