慕仙森
java向数据库中插入数据,可以使用mysql数据库,使用statement类来操作数据库,示例如下:12345678910111213141516171819202122232425262728Connection conn = null; Statement st = null; try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");//加载驱动类 conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://:<1433>", "name","pwd"); conn.setAutoCommit(false); st = conn.createStatement(); // 模拟一个 str[i] = nd.getNodeValue().trim() String[] str = new String[] { "aaa", "bbb", "ccc", "ddd", "eee","fff" }; String sqlStr = null; for (int i = 0; i ()VALUES('" + str[i] + "')";//向数据库中插入数据 st.executeUpdate(sqlStr); } conn.commit(); } catch (Exception e) { e.printStackTrace(); } finally {//释放数据库的资源 try { if (st != null) st.close(); if(conn != null && !conn.isClosed()){ conn.close(); } } catch (SQLException e) { e.printStackTrace(); } }