如何将Java Spinner值发送到SQL?我想在SQL中保存以日期时间格式

Question

第一部分是按钮单击一部分。第二部分是SQL Part

private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) { 
    try {
        String id1 = jTextField1.getText();
        String subj = kk.getSelectedItem().toString();
        String name_teacher = tt.getText();
        String grde = jComboBox1.getSelectedItem().toString();
        String st_d = spinner.getSelectedItem().toString();
        int en_d = jSpinner1.getSelectedItem().toString();
        String url = "jdbc:sqlserver://localhost:1433;databaseName=class ";
        String username = "mali";
        String password = "12345";
        Connection con = DriverManager.getConnection(url, username, password);
        Statement st = con.createStatement();
        //String sub = kk.getText();
        //String gg =tt.getText();
        String QUERY = "INSERT INTO addteacher(id,sub,namet,grd,start_time,end_time)VALUES('" + id1 + "','" + subj + "', '" + name_teacher + "','" + grde + "','" + st_d + "','" + en_d + "')";
        st.execute(QUERY);
    } catch (Exception e) {
    }
}

Answer 1

您可以尝试此解决方案：

JSpinner hour = new JSpinner();
JSpinner min = new JSpinner();
//Your date format
SimpleDateFormat format = new SimpleDateFormat("HHmm");
//Get values from your spinners
String HOUR = (String) hour.getValue();
String MIN = (String) min.getValue();
//Create a date 
Date parsed = format.parse(HOUR + MIN);
java.sql.Time sql = new java.sql.Time(parsed.getTime());
//Insert your date
System.out.println(sql);