javaåæ°æ®åºä¸æå
¥æ°æ®ï¼å¯ä»¥ä½¿ç¨mysqlæ°æ®åºï¼ä½¿ç¨statementç±»æ¥æä½æ°æ®åºï¼ç¤ºä¾å¦ä¸ï¼
Connection conn = null;
Statement st = null;
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");//å 载驱å¨ç±»
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://<server_name>:<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 < str.length; i++) {
sqlStr = "INSERT INTO <TABLENAME> (<COLNAME>)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();
}
}