62,615
社区成员
发帖
与我相关
我的任务
分享
package jdbc;
import java.sql.*;
public class TestConnect {
public static void main(String []args) {
try {
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:sqlserver://localhost:1433;DataBaseName=pubs";
String user = "sa";
String password = "a19890317";
// 1、加载驱动程序
Class.forName(driverName);
// 2、创建连接对象
Connection conn = DriverManager.getConnection(url, user, password);
// 3、创建Statement对象,该对象可以执行sql语句
Statement st = conn.createStatement();
String sql = "insert into [user](id,name) values('hack','hack')";
int result = st.executeUpdate(sql);
if (result > 0) {
System.out.println("增加成功");
}
else {
System.out.println("增加失败");
}
} catch(Exception e){
e.printStackTrace();
}
}
}
package com.xujianyou;
import java.sql.*;
public class TestConnect {
public static void main(String []args) {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String user = "sa";
String password = "da";
Connection con = DriverManager.getConnection(url, user, password);
Statement sta = con.createStatement();
int result = sta.executeUpdate();
if (result > 0) {
//证明成功插入啊.你就可以在这里写你想写的动作
}
else {
//插入失败!
}
} catch(Exception e){
e.printStackTrace();
}
}
}
package com.xujianyou;
import java.sql.*;
public class TestConnect {
public static void main(String []args) {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String user = "sa";
String password = "da";
Connection con = DriverManager.getConnection(url, user, password);
Statement sta = con.createStatement();
int result = sta.executeUpdate();
if (result > 0){//证明成功插入啊.你就可以在这里写你想写的动作
}
else {//插入失败!
} } catch(Exception e){
e.printStackTrace();
}
}
}