jdbc连接数据库例子

import java.sql.Connection;
import java.sql.Statement;
import java.sql.DriverManager;
public class DBTool {
private static Connection conn = null;
private static Statement stmt = null;
private static void getConn()
{
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=master;Uid=sa;Pwd=1234;","sa","1234");
}catch(Exception ex){ex.printStackTrace();}
}
public static boolean execSql(String sql){
boolean bool = false;
try{
getConn();
stmt = conn.createStatement();
bool = !stmt.execute(sql);
}catch(Exception ex){ex.printStackTrace();}
finally{
try {
if(!conn.isClosed()){
stmt.close();
}
} catch (Exception e) {e.printStackTrace();}
}
return bool;
}
}