java连接sql server 2008
导入JDBC
import java.sql.SQLException;
public class text {
public static void main(){
Connection conn;
Statement stmt;
ResultSet rs;
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=我的数据库;";
String sql = "select * from address_list where "+s2+"=('"+s1+"')";
try {
conn = DriverManager.getConnection(url, "sa", "123456");
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
conn.close();
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
人一我百,人十我万!追逐青春的梦想,怀着自信的心,永不放弃!
浙公网安备 33010602011771号