java链接数据库

package demo1;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class sqlclass {
	final static String  driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	//加载JDBC驱动
	final static String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=sc";
	//连接服务器和数据库
	final static String userName = "sa"; //默认用户名
	final static String userPwd = "12345678"; //密码
	private Connection conn;
	public Statement stmt;
	public Statement getstmt(){
		return stmt;
	}
	public boolean opensqlconnection(){
		try {
			   Class.forName(driverName);
			   conn = DriverManager.getConnection(dbURL, userName, userPwd);
			   this.stmt=conn.createStatement();
			} catch (Exception e) {
			   e.printStackTrace();
			   return false;
			}
return true;
	}
}