sqlserverÌí¼ÓÊý¾ÝµÄÎÊÌâ - Java / Java EE

ÒÔÏ´úÂëÊÇÌí¼ÓÊý¾Ý°´Å¥µÄ´úÂ룬Ïë°Ñtestid£¬ºÍtestnameÁ½¸ötxt´«µÝµ½Êý¾Ý¿âÖÐ
Êý¾Ý¿âÁ¬½Ó¿Ï¶¨Ã»ÎÊÌâ
¾ÍÊǺìÉ«²¿·ÖÀϱ¨´í
²»ÖªµÀΪʲô-£¬-

Çë¸÷λ¸ßÈË°ïæ¿´¿´£¡
лл£¡


Java code:


private void newButtonActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:

Connection conn=null;
Statement stat=null;
//PrepareStatement ps = null;


System.out.println("connect sql"+ stat);

try{
conn = fetchconnection();

String sql = "insert into subject values('"+testIDField.getText()+"','"+testNameField.getText()+"')";
[color=#FF0000] stat = conn.createStatement();[/color]//ÕÒ²»µ½¼æÈÝÀàÐÍ
System.out.println(stat);
[color=#FF0000] stat.executeUpdate(sql);[/color]//ÕÒ²»µ½·ûºÅ
System.out.println(" ps.executeUpdate(sql);");

JOptionPane.showMessageDialog(this, "Ôö¼Ó³É¹¦£¡£¡");
//rs.close();
[color=#FF0000] stat.close();[/color]//ÕÒ²»µ½·ûºÅ
conn.close();

this.testIDField.setText("");
this.testNameField.setText("");



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

}

public static Connection fetchconnection(){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url