sql自联格式和范例

首先自联需要三个包,连数据库语为:
package demo;

import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import com.microsoft.jdbc.sqlserver.SQLServerDriver;
public class JDBCDemo {
public static ResultSet rs = null;
public static Connection conn = null;
public static Statement st = null;

public static ResultSet Connect(String sql,boolean isselect) {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url ="jdbc:microsoft:sqlserver://localhost:1433;databasename=accp";
conn = DriverManager.getConnection(url, "sa", "");
st=conn.createStatement();
if (isselect==true) {
rs=st.executeQuery(sql);
} else {
st.execute(sql);
}