sqlserver 连接

package demosql;import java.sql.*;public class test {?static final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";?static final String URL = "jdbc:sqlserver://localhost:1433;databaseName=test";?static final String USER = "su";?static final String PWD = "zhang";?static Statement sm = null;?static Connection con = null;??public static void main(String args[]){????try {??????Class.forName(DRIVER);??????con = DriverManager.getConnection(URL,USER,PWD);???Statement sm = con.createStatement();???int i = sm.executeUpdate("insert into 部门? values(4,'yyy')");???if(i == 1)????System.out.println("Success");???else????System.out.println("Fail");??????} catch (ClassNotFoundException e) {???????// TODO Auto-generated catch block??????e.printStackTrace();????System.out.println("not found");} ??catch (SQLException e) {??????// TODO Auto-generated catch block?????e.printStackTrace();??}???finally{???if(sm != null)????try {?????sm.close();????} catch (SQLException e) {?????// TODO Auto-generated catch block?????e.printStackTrace();????}???if(con != null)????try {?????con.close();????} catch (SQLException e) {?????// TODO Auto-generated catch block?????e.printStackTrace();????}??}?//?return con;??}?}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!