问题描述:
求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);
}
} catch (Exception ex) {
ex.printStackTrace();
}
return rs;
}
public static void closesql(){
try {
if (rs!=null) {
rs.close();
}
if (st!=null) {
st.close();
}
if (conn!=null) {
conn.close();
}
} catch (Exception ex) {
ex.printStackTrace();
}
}
}